[CALCITE-5855] Implement frame exclusion in window functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Itiel Sadeh
• Reporter: Itiel Sadeh
• Created: 17/Jul/23 15:07
• Updated: 5 days ago 22:41
• Resolved: 5 days ago 22:41

Description

PostgreSQL supports "frame exclusion" in window function, e.g. :

SELECT sum(x) OVER (PARTITION BY y ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING EXCLUDE CURRENT ROW) from t

(see here) which let you ignore some rows from the selected scope.

This ticket is adding support for it in Calcite

Issue Links

• links to: GitHub Pull Request #3811