Dawid Wysakowicz created FLINK-35216:
----------------------------------------
Summary: 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
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)
