[
https://issues.apache.org/jira/browse/FLINK-35216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dawid Wysakowicz closed FLINK-35216.
------------------------------------
Resolution: Implemented
Implemented in 0737220959fe52ee22535e7db55b015a46a6294e
> Support for RETURNING clause of JSON_QUERY
> ------------------------------------------
>
> Key: FLINK-35216
> URL: https://issues.apache.org/jira/browse/FLINK-35216
> Project: Flink
> Issue Type: New Feature
> Components: Table SQL / Planner
> Reporter: Dawid Wysakowicz
> Assignee: Dawid Wysakowicz
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.20.0
>
>
> 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.
> {code}
> <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> ]
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
