Xingcan Cui created FLINK-34633: ----------------------------------- Summary: Support unnesting array constants Key: FLINK-34633 URL: https://issues.apache.org/jira/browse/FLINK-34633 Project: Flink Issue Type: New Feature Components: Table SQL / Planner Affects Versions: 1.18.1 Reporter: Xingcan Cui
It seems that the current planner doesn't support using UNNEST on array constants.(x) {code:java} SELECT * FROM UNNEST(ARRAY[1,2,3]);{code} The following query can be compiled.(x) {code:java} SELECT * FROM (VALUES('a')) CROSS JOIN UNNEST(ARRAY[1, 2, 3]){code} The rewritten version works. (/) {code:java} SELECT * FROM (SELECT *, ARRAY[1,2,3] AS A FROM (VALUES('a'))) CROSS JOIN UNNEST(A){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)