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

Support for RETURNING clause of JSON_QUERY

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.38.0
    • None

    Description

      SQL standard says JSON_QUERY should support RETURNING clause similar to JSON_VALUE. Calcite supports the clause for JSON_VALUE already, but not for the JSON_QUERY.

      <JSON query> ::=
        JSON_QUERY <left paren>
            <JSON API common syntax>
            [ <JSON output clause> ]
            [ <JSON query wrapper behavior> WRAPPER ]
            [ <JSON query quotes behavior> QUOTES [ ON SCALAR STRING ] ]
            [ <JSON query empty behavior> ON EMPTY ]
            [ <JSON query error behavior> ON ERROR ]
            <right paren>
      
      <JSON output clause> ::=
        RETURNING <data type>
            [ FORMAT <JSON representation> ]
      

      In this issue I'd like to support only part of the full specification, namely:

      <JSON output clause> ::=
        RETURNING <data type>
      

      Attachments

        Issue Links

          Activity

            People

              dwysakowicz Dawid Wysakowicz
              dwysakowicz Dawid Wysakowicz
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: