[FLINK-35687] JSON_QUERY should return a well formatted nested objects/arrays for ARRAY<STRING>

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Dawid Wysakowicz
• Reporter: Dawid Wysakowicz
• Created: 5 days ago 12:25
• Updated: 3 days ago 06:50
• Resolved: 3 days ago 06:50

Description

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

returns

['{itemId=1234, count=10}']

but it should:

['{"itemId":1234, "count":10}']

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

Issue Links

• is related to: FLINK-35216 Support for RETURNING clause of JSON_QUERY
• links to: GitHub Pull Request #24976