Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-35216

Support for RETURNING clause of JSON_QUERY

    XMLWordPrintableJSON

Details

    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> ]
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: