]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
- move LIMIT/OFFSET rendering to be as bind parameters, for all backends
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 29 Aug 2010 20:35:02 +0000 (16:35 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sun, 29 Aug 2010 20:35:02 +0000 (16:35 -0400)
commite4bc7d289477e22815f4c6ab86b3f0c1bf356e08
treefdfe33b2ab7e5ef54b62877d4c17a56a401e23ed
parent87fd1e3260d957ae25c44cc2ac30ce97feb89b35
- move LIMIT/OFFSET rendering to be as bind parameters, for all backends
which support it.  This includes SQLite, MySQL, Postgresql, Firebird,
Oracle (already used binds with ROW NUMBER OVER), MSSQL (when ROW NUMBER
is used, not TOP).   Not included are Informix, Sybase, MaxDB, Access
[ticket:805]
- LIMIT/OFFSET parameters need to stay as literals within SQL
constructs.  This because they may not be renderable as binds on
some backends.
14 files changed:
lib/sqlalchemy/dialects/firebird/base.py
lib/sqlalchemy/dialects/maxdb/base.py
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/dialects/mysql/base.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/dialects/sqlite/base.py
lib/sqlalchemy/dialects/sybase/base.py
lib/sqlalchemy/sql/compiler.py
test/dialect/test_mysql.py
test/orm/inheritance/test_query.py
test/orm/test_eager_relations.py
test/orm/test_query.py
test/sql/test_compiler.py
test/sql/test_generative.py