[CALCITE-883] Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Sean Hsuan-Yi Chu
• Created: 09/Sep/15 20:47
• Updated: 10/Sep/24 09:29
• Resolved: 31/Mar/19 22:44

Description

This issue was brought up in Drill community: (https://issues.apache.org/jira/browse/DRILL-3597)

For convenience, I copied and pasted the reporter Khurram Faraaz's description here:

"The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead, lag, first_value, and last_value window functions."

In Calcite, we should have been able to recognized this option.

Issue Links

• causes: CALCITE-6569 RelToSqlConverter support IGNORE NULLS for window functions
• duplicates: CALCITE-337 Support IGNORE NULLS in window aggregates
• is depended upon by: DRILL-4397 Add support for NULL treatment in LAG/LEAD functions
• relates to: CALCITE-6442 Validator rejects FILTER in OVER windows
• links to: GitHub Pull Request #1108