]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
projects / thirdparty / sqlalchemy / sqlalchemy.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 226f25f) | patch
MSSQL 2014 OFFSET/FETCH syntax support
authorElkin <elkin@raketa.im>
Wed, 5 Feb 2020 14:51:14 +0000 (09:51 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 7 Feb 2020 15:15:10 +0000 (10:15 -0500)
commitab1799a2a1951fe8f188b6395fde04a233a3ac0d
tree9228479a408a8f47665ddd74c6ede3efa226c716tree
parent226f25fdce33b1427807de7decc6e8d11f678c99commit | diff
MSSQL 2014 OFFSET/FETCH syntax support

SQL Server OFFSET and FETCH keywords are now used for limit/offset, rather
than using a window function, for SQL Server versions 11 and higher. TOP is
still used for a query that features only LIMIT.   Pull request courtesy
Elkin.

Fixes: #5084
Closes: #5125
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5125
Pull-request-sha: a45b7f73090d2053e3a7020d4e3d7fabb0c5627d

Change-Id: Id6a01ba30caac87d7d3d92c3903cdfd77fbcee5e
doc/build/changelog/unreleased_14/5084.rst [new file with mode: 0644] blob
lib/sqlalchemy/dialects/mssql/base.py diff | blob | blame | history
test/dialect/mssql/test_compiler.py diff | blob | blame | history
test/sql/test_query.py diff | blob | blame | history
Mirror of https://github.com/sqlalchemy/sqlalchemy.git