Jiajun Xie created CALCITE-6569:
-----------------------------------
Summary: RelToSqlConverter support IGNORE NULLS for window
functions
Key: CALCITE-6569
URL: https://issues.apache.org/jira/browse/CALCITE-6569
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.20.0
Reporter: Jiajun Xie
Assignee: Jiajun Xie
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
{code:java}
SELECT LAG("employee_id", 2) IGNORE NULLS OVER (ORDER BY "hire_date")
FROM "employee"{code}
It lost `IGNORE NULLS `
{code:java}
SELECT LAG("employee_id", 2) OVER (ORDER BY "hire_date")
FROM "employee"{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
