From 3bbf8037f8408b590d64624b7ce71963053f555c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 24 Oct 2008 15:58:17 +0000 Subject: - fixed some oracle unit tests in test/sql/ - wrote a docstring for oracle dialect, needs formatting perhaps - made FIRST_ROWS optimization optional based on optimize_limits=True, [ticket:536] --- test/sql/defaults.py | 3 ++- test/sql/query.py | 2 +- 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'test/sql') diff --git a/test/sql/defaults.py b/test/sql/defaults.py index 169d60c67..de939f08d 100644 --- a/test/sql/defaults.py +++ b/test/sql/defaults.py @@ -261,7 +261,7 @@ class DefaultTest(testing.TestBase): t.insert().execute() ctexec = sa.select([currenttime.label('now')], bind=testing.db).scalar() - l = t.select().execute() + l = t.select().order_by(t.c.col1).execute() today = datetime.date.today() eq_(l.fetchall(), [ (x, 'imthedefault', f, ts, ts, ctexec, True, False, @@ -475,6 +475,7 @@ class PKIncrementTest(_base.TablesTest): class EmptyInsertTest(testing.TestBase): @testing.exclude('sqlite', '<', (3, 3, 8), 'no empty insert support') + @testing.fails_on('oracle') def test_empty_insert(self): metadata = MetaData(testing.db) t1 = Table('t1', metadata, diff --git a/test/sql/query.py b/test/sql/query.py index 4decf3b68..3118aef64 100644 --- a/test/sql/query.py +++ b/test/sql/query.py @@ -200,7 +200,7 @@ class QueryTest(TestBase): self.assert_(not (rp != equal)) self.assert_(not (equal != equal)) - @testing.fails_on('mssql') + @testing.fails_on('mssql', 'oracle') def test_or_and_as_columns(self): true, false = literal(True), literal(False) -- cgit v1.2.1