[ 
https://issues.apache.org/jira/browse/CALCITE-855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde resolved CALCITE-855.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.8.0

Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/354e8240.

By the way, you can use {{UNNEST ... WITH ORDINALITY}} with multiple arguments 
too.

> Allow UNNEST to have multiple arguments
> ---------------------------------------
>
>                 Key: CALCITE-855
>                 URL: https://issues.apache.org/jira/browse/CALCITE-855
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>             Fix For: 1.8.0
>
>
> The SQL standard allows UNNEST to have more than one argument. The result is 
> a collection of records whose i'th record draws fields from the i'th record 
> of each input.
> We have laid groundwork for this in CALCITE-854, specifically how the type of 
> an Uncollect is derived. Uncollect will continue to have one input, but with 
> this change, the input may now have more than one column. Each column must be 
> an array or multiset (slightly looser than the standard, which only allows 
> multiple arguments if all are arrays).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to