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)