[jira] [Created] (FLINK-37695) Parsing for a JSON() function call fail to its position

["Gustavo de Morais (Jira)" <ji...@apache.org>]

Gustavo de Morais created FLINK-37695:
-----------------------------------------

             Summary: 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


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.
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)