[jira] [Created] (FLINK-34633) Support unnesting array constants

["Xingcan Cui (Jira)" <ji...@apache.org>]

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)