[jira] [Created] (FLINK-35687) JSON_QUERY should return a proper JSON for ARRAY

[Dawid Wysakowicz (Jira)]

Dawid Wysakowicz created FLINK-35687:
----------------------------------------

             Summary: JSON_QUERY should return a proper JSON for ARRAY<STRING>
                 Key: FLINK-35687
                 URL: https://issues.apache.org/jira/browse/FLINK-35687
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.19.1
            Reporter: Dawid Wysakowicz
            Assignee: Dawid Wysakowicz
             Fix For: 1.20.0, 1.19.2


{code}
SELECT JSON_QUERY('{"items": [{"itemId":1234, "count":10}]}', '$.items' 
RETURNING ARRAY<STRING>)
{code}

returns

{code}
{itemId=1234, count=10}
{code}

but it should:

{code}
{"itemId":1234, "count":10}
{code}

We should call jsonize for Collection types here: 
https://github.com/apache/flink/blob/f6f88135b3a5fa5616fe905346e5ab6dce084555/flink-table/flink-table-runtime/src/main/java/org/apache/flink/table/runtime/functions/SqlJsonUtils.java#L268



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