]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
got oracle LIMIT/OFFSET to use row_number() syntax
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 5 Feb 2006 17:04:37 +0000 (17:04 +0000)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 5 Feb 2006 17:04:37 +0000 (17:04 +0000)
commit1e1eea05538e43a41750ba8548da517d77284e9c
treed2998bf781b5f7f8e9b4c08767436265a7a4118f
parenta9fb2f3e6f9b3dd50385cfea5570a023a89ddd8c
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/ansisql.py
lib/sqlalchemy/databases/oracle.py
lib/sqlalchemy/sql.py