]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Fix label referencing in SQL Server OFFSET logic
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 10 May 2016 16:49:56 +0000 (12:49 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 10 May 2016 16:57:08 +0000 (12:57 -0400)
commit40b0e4b424c87adedfdf3bf968f3ee6851743fc2
tree80fefa8f93e46a56307e31bdc55d615432c24268
parenta9f74400b179e9d19e073a2a1e43cbffda6e1fad
Fix label referencing in SQL Server OFFSET logic

Fixed bug where by ROW_NUMBER OVER clause applied for OFFSET
selects in SQL Server would inappropriately substitute a plain column
from the local statement that overlaps with a label name used by
the ORDER BY criteria of the statement.

Change-Id: Ic2500c886cbfc83a1ad5a2681783f008b9f23838
Fixes: #3711
(cherry picked from commit a4be7c92393e08607dc46f318e97803519052a93)
doc/build/changelog/changelog_10.rst
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/sql/util.py
test/dialect/mssql/test_compiler.py