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)