]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
projects / thirdparty / sqlalchemy / sqlalchemy.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 62e68be) | patch
Fix MSSQL / Oracle limit/offset regressions
authorFederico Caselli <cfederico87@gmail.com>
Tue, 30 Mar 2021 21:15:04 +0000 (23:15 +0200)
committerMike Bayer <mike_mp@zzzcomputing.com>
Thu, 1 Apr 2021 02:13:30 +0000 (22:13 -0400)
commita357baec856bb73c511f8f8484d316f19a29252a
treebcc2f6c4da109191e93e74bfb5558d9ab09b8c7ftree
parent62e68beea671215e98cb939bb87af95d6d9f35eecommit | diff
Fix MSSQL / Oracle limit/offset regressions

Fixed a regression in MSSQL 2012+ that prevented the order clause
to be rendered when ``offset=0`` is used in a subquery.

Fixed critical regression where the Oracle compiler would not maintain the
correct parameter values in the LIMIT/OFFSET for a select due to a caching
issue.

Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
Fixes: #6163
Fixes: #6173
Change-Id: Ieb12354271d09ad935d684ee0db4fa0128837215
doc/build/changelog/unreleased_14/6163.rst [new file with mode: 0644] blob
doc/build/changelog/unreleased_14/6173.rst [new file with mode: 0644] blob
lib/sqlalchemy/dialects/mssql/base.py diff | blob | blame | history
lib/sqlalchemy/dialects/oracle/base.py diff | blob | blame | history
lib/sqlalchemy/sql/selectable.py diff | blob | blame | history
lib/sqlalchemy/testing/suite/test_select.py diff | blob | blame | history
test/dialect/mssql/test_compiler.py diff | blob | blame | history
test/dialect/oracle/test_compiler.py diff | blob | blame | history
test/dialect/oracle/test_dialect.py diff | blob | blame | history
Mirror of https://github.com/sqlalchemy/sqlalchemy.git