[ 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)