Opened 6 years ago

Last modified 3 months ago

#29850 closed New feature

Add window support for RowRange frames — at Version 5

Reported by: Daniel Fuchs Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: GSoC
Cc: Raphael Michel, Mads Jensen, John Speno Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no
Pull Requests:18935 merged, 17401 unmerged, 17423 merged, 17422 merged

Description (last modified by Mariusz Felisiak)

The current RowRange frame is missing handling for several cases.

None of the following are currently supported:
RowRange(start=-2, end=-1)
ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING
RowRange(start=1, end=2)
ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING

It's also missing support for EXCLUDE.
ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING EXCLUDE CURRENT ROW

Frame exclusion is supported only in ​PostgreSQL 11+ and ​SQLite 3.28+, other databases do not support exclusion (see ​Oracle 18c doc, ​MariaDB doc, and ​MySQL doc).

Change History (3)

comment:1 by Tim Graham, 6 years ago

Summary: Poor Window Support for RowRange Frames → Add window support for RowRange frames
Triage Stage: Unreviewed → Accepted
Type: Uncategorized → New feature

comment:3 by Mariusz Felisiak, 6 years ago

Description: modified (diff)
Version: 2.1 → master

comment:5 by Mariusz Felisiak, 5 years ago

Description: modified (diff)

Exclusion is supported also on SQLite 3.28+ (see ​release notes).

Note: See TracTickets for help on using tickets.
Back to Top