EveyWu created CALCITE-6231:
--------------------------------
Summary: ORDINALITY is omitted during the RelToSql stage
Key: CALCITE-6231
URL: https://issues.apache.org/jira/browse/CALCITE-6231
Project: Calcite
Issue Type: Bug
Reporter: EveyWu
The syntax UNNEST() WITH ORDINALITY is missing the ORDINALITY keyword.
For example sql：
{code:java}
select did + 1 from
unnest(select collect("department_id") as deptid from "department")
with ordinality as t(did, pos){code}
current planned sql：
{code:java}
SELECT DEPTID + 1 FROM UNNEST (
SELECT COLLECT("department_id") AS "DEPTID" FROM "foodmart"."department")
AS "t0" ("DEPTID", "ORDINALITY") {code}
fixed planned sql：
{code:java}
SELECT "DEPTID" + 1 FROM UNNEST (
SELECT COLLECT("department_id") AS "DEPTID" FROM "foodmart"."department")
WITH ORDINALITY AS "t0" ("DEPTID", "ORDINALITY") {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
