Mihai Budiu created CALCITE-6003: ------------------------------------ Summary: json_array() with no arguments does not unparse correctly Key: CALCITE-6003 URL: https://issues.apache.org/jira/browse/CALCITE-6003 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.35.0 Reporter: Mihai Budiu
The following expression "json_array()" is compiled by the SqlOperatorTest into the following query: {code:sql} select json_array() from (values (1)) as t(p0) {code} Parsing and unparsing this query generates the following incorrect SQL: {code:sql} SELECT JSON_ARRAY(ABSENT ON NULL) FROM (VALUES ROW(1)) AS "T" ("P0") {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)