]> 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:55:23 +0000 (12:55 -0400)
commit0604116814a862d4d9dbc1a8866a2a3b0126caf1
tree1ddc470c634b5fb4cf474767b0d728817df5a142
parent743e9d4589946f1a29cdec7f2f1a2e4ec0853db7
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
doc/build/changelog/changelog_10.rst
lib/sqlalchemy/dialects/mssql/base.py
lib/sqlalchemy/sql/util.py
test/dialect/mssql/test_compiler.py