diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-04-13 22:22:07 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-04-13 22:22:07 +0000 |
| commit | b9ce8e38c9a406f2b979aec133c36cc587d888c7 (patch) | |
| tree | b8a374e88ef6c6bf81903e1d02c0139565d53ab7 /test/sql | |
| parent | e44857977a79e306808e9e56638d6ca339b983a4 (diff) | |
| download | sqlalchemy-b9ce8e38c9a406f2b979aec133c36cc587d888c7.tar.gz | |
- small fix to allow successive compiles of the same SELECT object
which features LIMIT/OFFSET. oracle dialect needs to modify
the object to have ROW_NUMBER OVER and wasn't performing
the full series of steps on successive compiles.
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/select.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index 56584e708..91b293cbe 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -280,7 +280,9 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A def testoraclelimit(self): metadata = MetaData() users = Table('users', metadata, Column('name', String(10), key='username')) - self.runtest(select([users.c.username], limit=5), "SELECT name FROM (SELECT users.name AS name, ROW_NUMBER() OVER (ORDER BY users.rowid) AS ora_rn FROM users) WHERE ora_rn<=5", dialect=oracle.dialect()) + s = select([users.c.username], limit=5) + self.runtest(s, "SELECT name FROM (SELECT users.name AS name, ROW_NUMBER() OVER (ORDER BY users.rowid) AS ora_rn FROM users) WHERE ora_rn<=5", dialect=oracle.dialect()) + self.runtest(s, "SELECT name FROM (SELECT users.name AS name, ROW_NUMBER() OVER (ORDER BY users.rowid) AS ora_rn FROM users) WHERE ora_rn<=5", dialect=oracle.dialect()) def testgroupby_and_orderby(self): self.runtest( |