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)