From 1e1eea05538e43a41750ba8548da517d77284e9c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 5 Feb 2006 17:04:37 +0000 Subject: got oracle LIMIT/OFFSET to use row_number() syntax sql: ColumnClause will use the given name when proxying itself (used for the "ora_rn" label) ansisql: When adding on ORDER_BY, GROUP_BY, etc. clauses, if there is no string for the column list, then dont add the clause (this allows oracle to strip out the ORDER BY) Oracle is modifying the select statement, which is not ideal - should fix that --- lib/sqlalchemy/sql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/sql.py') diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index 8be40ac1d..c8a05470c 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -987,7 +987,7 @@ class ColumnClause(ColumnElement): else: return BindParamClause(self.table.name + "_" + self.text, obj, shortname = self.text, type=self.type) def _make_proxy(self, selectable, name = None): - c = ColumnClause(self.text or name, selectable) + c = ColumnClause(name or self.text, selectable) selectable.columns[c.key] = c return c -- cgit v1.2.1