[FLINK-34633] Support unnesting array constants - ASF JIRA

XML

Word

Printable

JSON

It seems that the current planner doesn't support using UNNEST on array constants.

SELECT * FROM UNNEST(ARRAY[1,2,3]);

The following query can't be compiled.

SELECT * FROM (VALUES('a')) CROSS JOIN UNNEST(ARRAY[1, 2, 3])

The rewritten version works.

SELECT * FROM (SELECT *, ARRAY[1,2,3] AS A FROM (VALUES('a'))) CROSS JOIN UNNEST(A)

links to

GitHub Pull Request #24510