Opened 6 years ago
Last modified 6 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 |
Description (last modified by )
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 , 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 , 5 years ago
| Description: | modified (diff) |
|---|---|
| Version: | 2.1 → master |
comment:5 by , 5 years ago
| Description: | modified (diff) |
|---|
Note:
See TracTickets
for help on using tickets.
Exclusion is supported also on SQLite 3.28+ (see release notes).