[ https://issues.apache.org/jira/browse/FLINK-34633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17853040#comment-17853040 ]
Rui Fan commented on FLINK-34633: --------------------------------- Hi [~qingyue] [~jeyhunkarimov] , during I review the 1.19.1 release PR[1], I found this Jira is included in 1.19.1 release note. In general, the patch version shouldn't include the new Feature. After I checked, this PR is only merged to master branch(1.20). So the Fix version should be updated to 1.20.0, right? [1]https://github.com/apache/flink-web/pull/745#discussion_r1630711306 > 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 > Assignee: Jeyhun Karimov > Priority: Minor > Labels: pull-request-available > Fix For: 1.19.1 > > > 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't 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)