summaryrefslogtreecommitdiff
path: root/test/sql
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2008-10-24 15:58:17 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2008-10-24 15:58:17 +0000
commit3bbf8037f8408b590d64624b7ce71963053f555c (patch)
treec3ffb39d25e233251302a1b0259a3d5cb946987e /test/sql
parent4ba496442555b8808941b7674b2081452417dfd5 (diff)
downloadsqlalchemy-3bbf8037f8408b590d64624b7ce71963053f555c.tar.gz
- 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]
Diffstat (limited to 'test/sql')
-rw-r--r--test/sql/defaults.py3
-rw-r--r--test/sql/query.py2
2 files changed, 3 insertions, 2 deletions
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)