]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Allow for multiple FOLLOWING/PRECEDING in a window range
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 25 Aug 2017 13:41:18 +0000 (09:41 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Fri, 25 Aug 2017 13:43:38 +0000 (09:43 -0400)
commitfb55270835b18e6ba942b74ee72719ce0fc4d062
treeb94f4c40a62006046e80a796b7a00f2b9d971cc5
parent3b5840f16a27e972c950890b3bbab1d9bfc460a6
Allow for multiple FOLLOWING/PRECEDING in a window range

Altered the range specification for window functions to allow
for two of the same PRECEDING or FOLLOWING keywords in a range
by allowing for the left side of the range to be positive
and for the right to be negative, e.g. (1, 3) is
"1 FOLLOWING AND 3 FOLLOWING".

Change-Id: I7d3a6c641151bb49219104968d18dac2266f3db8
Fixes: #4053
(cherry picked from commit 3a5bbe4cbe12d180fba2b942d0467b46be705bea)
doc/build/changelog/unreleased_11/4053.rst [new file with mode: 0644]
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/elements.py
test/sql/test_compiler.py