]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Interpret empty LIMIT, expression LIMIT correctly
authorMike Bayer <mike_mp@zzzcomputing.com>
Sat, 9 Nov 2019 21:12:30 +0000 (16:12 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sat, 9 Nov 2019 21:13:13 +0000 (16:13 -0500)
commita28674db3c6321e5fa16f62d595171fd4688b22e
treecd9e9d6644aa17a4347cedc13c64964bc6e7d81a
parent69bd9ade90e283e9e55b5753ae5c1602a9954887
Interpret empty LIMIT, expression LIMIT correctly

Fixed issue in MSSQL dialect where an expression-based OFFSET value in a
SELECT would be rejected, even though the dialect can render this
expression inside of a ROW NUMBER-oriented LIMIT/OFFSET construct.

Fixes: #4973
Change-Id: I040d34f781791c4ed5a727e1b8fb98c68ddd0622
(cherry picked from commit b3c3562ecf67ae7c94091287504579fcace6a500)
doc/build/changelog/unreleased_13/4973.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
test/dialect/mssql/test_compiler.py
test/requirements.py