From 72fe1b9d1cd1efe833805019e33b4bbe70c61326 Mon Sep 17 00:00:00 2001 From: Philip Jenvey Date: Sun, 19 Jul 2009 21:12:12 +0000 Subject: [PATCH] o don't assume exact insertion order in test_polymorph2.testjointo o zxjdbc fails like pg8000 on test_query.test_values_with_boolean_selectspn --- test/orm/inheritance/test_polymorph2.py | 2 +- test/orm/test_query.py | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/test/orm/inheritance/test_polymorph2.py b/test/orm/inheritance/test_polymorph2.py index 40ec01f176..80c14413a0 100644 --- a/test/orm/inheritance/test_polymorph2.py +++ b/test/orm/inheritance/test_polymorph2.py @@ -787,7 +787,7 @@ class GenerativeTest(TestBase, AssertsExecutionResults): e = exists([Car.owner], Car.owner==employee_join.c.person_id) Query(Person)._adapt_clause(employee_join, False, False) - r = session.query(Person).filter(Person.name.like('%2')).join('status').filter_by(name="active") + r = session.query(Person).filter(Person.name.like('%2')).join('status').filter_by(name="active").order_by(Person.person_id) eq_(str(list(r)), "[Manager M2, category YYYYYYYYY, status Status active, Engineer E2, field X, status Status active]") r = session.query(Engineer).join('status').filter(Person.name.in_(['E2', 'E3', 'E4', 'M4', 'M2', 'M1']) & (status.c.name=="active")).order_by(Person.name) eq_(str(list(r)), "[Engineer E2, field X, status Status active, Engineer E3, field X, status Status active]") diff --git a/test/orm/test_query.py b/test/orm/test_query.py index cb6f9c7665..a71bfa0b3d 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1773,6 +1773,7 @@ class MixedEntitiesTest(QueryTest): @testing.fails_on('mssql', 'FIXME: unknown') @testing.fails_on('oracle', "Oracle doesn't support boolean expressions as columns") @testing.fails_on('postgresql+pg8000', "pg8000 parses the SQL itself before passing on to PG, doesn't parse this") + @testing.fails_on('postgresql+zxjdbc', "zxjdbc parses the SQL itself before passing on to PG, doesn't parse this") def test_values_with_boolean_selects(self): """Tests a values clause that works with select boolean evaluations""" sess = create_session() -- 2.47.3