[CALCITE-6003] JSON_ARRAY() with no arguments does not unparse correctly

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Mihai Budiu
• Created: 12/Sep/23 22:57
• Updated: 10/Nov/23 11:34
• Resolved: 26/Sep/23 23:22

Description

The following expression "json_array()" is compiled by the SqlOperatorTest into the following query:

select json_array() from (values (1)) as t(p0)

Parsing and unparsing this query generates the following incorrect SQL:

SELECT JSON_ARRAY(ABSENT ON NULL)
FROM (VALUES ROW(1)) AS "T" ("P0")

Issue Links

• links to: GitHub Pull Request #3426