Opened 6 years ago

Last modified 3 months ago

#29850 closed New feature

Add window support for RowRange frames — at Version 3

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

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+, other databases do not support exclusion (see ​Oracle 18c doc, ​MariaDB doc, and ​MySQL doc).

Change History (2)

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
Note: See TracTickets for help on using tickets.
Back to Top