[CALCITE-6569] RelToSqlConverter support IGNORE NULLS for window functions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jiajun Xie
• Reporter: Jiajun Xie
• Created: 10/Sep/24 09:24
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

CALCITE-883(https://issues.apache.org/jira/browse/CALCITE-883) Support  IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions.

But RelToSqlConverter not support them, IGNORE NULLS will be lost.

 

For example

 

SELECT LAG("employee_id", 2) IGNORE NULLS OVER (ORDER BY "hire_date") 
FROM "employee"

 

It lost `IGNORE NULLS `

SELECT LAG("employee_id", 2) OVER (ORDER BY "hire_date") 
FROM "employee"

Issue Links

• is caused by: CALCITE-883 Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions
• links to: GitHub Pull Request #3957