[
https://issues.apache.org/jira/browse/FLINK-37695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gustavo de Morais updated FLINK-37695:
--------------------------------------
Description:
Parsing for a JSON() function call fail to its position if not in the first
param.
{{SELECT JSON_OBJECT('key' VALUE JSON('{}'), 'key_2' VALUE JSON('{}'));}}
Outputs:
{code:java}
The JSON() function is currently only supported inside a JSON_OBJECT() or
JSON_ARRAY() function. Example: JSON_OBJECT('a', JSON('{\"key\": \"value\"}'))
or JSON_ARRAY(JSON('{\"key\": \"value\"}'))."
This is incorrect, and we're stricly allowing json to be called only as the
second param in the function, when it should be allowed for every second.
{code}
was:
Parsing for a JSON() function call fail to its position if not in the first
param.
{{SELECT JSON_OBJECT('key' VALUE JSON('{}'), 'key_2' VALUE JSON('{}'));}}
Outputs:
{code:java}
Failed to (re)submit Job to Flink: {"errors":["The JSON() function is currently
only supported inside a JSON_OBJECT() or JSON_ARRAY() function. Example:
JSON_OBJECT('a', JSON('{\"key\": \"value\"}')) or JSON_ARRAY(JSON('{\"key\":
\"value\"}'))."]}{code}
This is incorrect, and we're stricly allowing json to be called only as the
second param in the function, when it should be allowed for every second.
> Parsing for a JSON() function call fail to its position
> -------------------------------------------------------
>
> Key: FLINK-37695
> URL: https://issues.apache.org/jira/browse/FLINK-37695
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Reporter: Gustavo de Morais
> Priority: Major
>
> Parsing for a JSON() function call fail to its position if not in the first
> param.
> {{SELECT JSON_OBJECT('key' VALUE JSON('{}'), 'key_2' VALUE JSON('{}'));}}
> Outputs:
> {code:java}
> The JSON() function is currently only supported inside a JSON_OBJECT() or
> JSON_ARRAY() function. Example: JSON_OBJECT('a', JSON('{\"key\":
> \"value\"}')) or JSON_ARRAY(JSON('{\"key\": \"value\"}'))."
> This is incorrect, and we're stricly allowing json to be called only as the
> second param in the function, when it should be allowed for every second.
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
