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.

        Issue Links

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Fixed on https://github.com/julianhyde/incubator-calcite/tree/816-sub-query branch but it will be a while before that branch can be merged to master.

          Show
          julianhyde Julian Hyde added a comment - Fixed on https://github.com/julianhyde/incubator-calcite/tree/816-sub-query branch but it will be a while before that branch can be merged to master.
          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/4762b889 .
          Hide
          julianhyde Julian Hyde added a comment -

          Resolved in release 1.6.0 (2016-01-22).

          Show
          julianhyde Julian Hyde added a comment - Resolved in release 1.6.0 (2016-01-22).

            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:

                Development