[ https://issues.apache.org/jira/browse/FLINK-37695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948493#comment-17948493 ]
Sergey Nuyanzin commented on FLINK-37695: ----------------------------------------- Merged as [45588b31410fc612051b0294d379c08036f04079|https://github.com/apache/flink/commit/45588b31410fc612051b0294d379c08036f04079] > 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 > Assignee: Gustavo de Morais > Priority: Major > Labels: pull-request-available > > 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)