From 80f48f250b49f87a67c83ea71b0635d6645f26c3 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 4 Feb 2007 03:43:22 +0000 Subject: - added literal_column() to specify a column clause that should not undergo any quoting - straight text sent to select() added as literal_column - fix for issue in [ticket:450] --- lib/sqlalchemy/databases/oracle.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'lib/sqlalchemy/databases') diff --git a/lib/sqlalchemy/databases/oracle.py b/lib/sqlalchemy/databases/oracle.py index 8730ecdb1..7221d5662 100644 --- a/lib/sqlalchemy/databases/oracle.py +++ b/lib/sqlalchemy/databases/oracle.py @@ -394,7 +394,7 @@ class OracleCompiler(ansisql.ANSICompiler): orderby = self.strings[orderby] class SelectVisitor(sql.ClauseVisitor): def visit_select(self, select): - select.append_column(sql.column("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) + select.append_column(sql.literal_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: @@ -429,7 +429,7 @@ class OracleCompiler(ansisql.ANSICompiler): orderby = select.oid_column orderby.accept_visitor(self) orderby = self.strings[orderby] - select.append_column(sql.column("ROW_NUMBER() OVER (ORDER BY %s)" % orderby).label("ora_rn")) + select.append_column(sql.literal_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) -- cgit v1.2.1