Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-854

Implement UNNEST ... WITH ORDINALITY

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.6.0
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: