Julian Hyde created CALCITE-854:
-----------------------------------
Summary: Implement UNNEST ... WITH ORDINALITY
Key: CALCITE-854
URL: https://issues.apache.org/jira/browse/CALCITE-854
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
The SQL standard provides UNNEST, a function that converts a multiset- or
array-valued scalar expression into a relation. Calcite already implements this
(for multisets).
This case would add support for WITH ORDINALITY, the generated relation has an
additional ORDINALITY column that contains the position of the element in the
array.
See http://farrago.sourceforge.net/design/CollectionTypes.html for examples.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
