]> 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:42:25 +0000 (09:42 -0400)
commit3a5bbe4cbe12d180fba2b942d0467b46be705bea
tree7613927bb275e4b53712cb28c15a1b3f2abe50bd
parente33cff44b5822a22c540d316151699203a1fff52
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
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