diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-14 01:15:43 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-14 01:15:43 +0000 |
| commit | fe62ca292bd7646a378d4dd1526aa9728ad3a4b4 (patch) | |
| tree | 88ea624271764a293726c5100073c31b51bc022f /lib/sqlalchemy/databases/oracle.py | |
| parent | 14dbac460037c1c662b8e33c7349bcd312cbfcf4 (diff) | |
| download | sqlalchemy-fe62ca292bd7646a378d4dd1526aa9728ad3a4b4.tar.gz | |
tweak to oracle limit/offset to not put ora_rn in the select list
Diffstat (limited to 'lib/sqlalchemy/databases/oracle.py')
| -rw-r--r-- | lib/sqlalchemy/databases/oracle.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index 14e4b33cd..a1957dcb3 100644 --- a/lib/sqlalchemy/databases/oracle.py +++ b/lib/sqlalchemy/databases/oracle.py @@ -213,7 +213,7 @@ class OracleCompiler(ansisql.ANSICompiler): else: orderby = "rowid ASC" select.append_column(sql.ColumnClause("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) - limitselect = select.select() + limitselect = sql.select([c for c in select.c if c.key!='ora_rn']) if select.offset is not None: limitselect.append_whereclause("ora_rn>%d" % select.offset) if select.limit is not None: |