diff options
Diffstat (limited to 'lib/sqlalchemy/databases/oracle.py')
| -rw-r--r-- | lib/sqlalchemy/databases/oracle.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index b9aa09695..91e54ea75 100644 --- a/lib/sqlalchemy/databases/oracle.py +++ b/lib/sqlalchemy/databases/oracle.py @@ -364,7 +364,7 @@ class OracleCompiler(ansisql.ANSICompiler): orderby = self.strings[orderby] class SelectVisitor(sql.ClauseVisitor): def visit_select(self, select): - select.append_column(sql.ColumnClause("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) + select.append_column(sql.column("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) select.accept_visitor(SelectVisitor()) limitselect = sql.select([c for c in select.c if c.key!='ora_rn']) if select.offset is not None: @@ -399,7 +399,7 @@ class OracleCompiler(ansisql.ANSICompiler): orderby = select.oid_column orderby.accept_visitor(self) orderby = self.strings[orderby] - select.append_column(sql.ColumnClause("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) + select.append_column(sql.column("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) 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) |