1. Mike Bayer Avatar Mike Bayer
  2. Untitled project
  3. sqlalchemy_old
  4. Issues

support RANGE BETWEEN x FOLLOWING and y FOLLOWING

Issue #4053 resolved
Mike Bayer repo owner created an issue

apparently you can have both sides of the range be FOLLOWING (or PRECEDING I would assume).

Comments (3)

  2. Mike Bayer reporter

    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)

    → <<cset fb55270835b1>>

  3. Mike Bayer reporter

    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

    → <<cset 3a5bbe4cbe12>>

  4. Log in to comment
Assignee
–
Type
bug
Priority
major
Status
resolved
Component
sql
Milestone
1.1.x
Votes
0
Watchers
1
Jira: the preferred issue tracker for Bitbucket. Join the team!