[jira] [Created] (CALCITE-3504) allow empty ARRAY[] literals

[Pressenna (Jira)]

Pressenna created CALCITE-3504:
----------------------------------

             Summary: allow empty ARRAY[] literals
                 Key: CALCITE-3504
                 URL: https://issues.apache.org/jira/browse/CALCITE-3504
             Project: Calcite
          Issue Type: Wish
    Affects Versions: 1.21.0
            Reporter: Pressenna


Currently an ARRAY expression requires at least one element.
Please allow empty ARRAY expressions.

{code:sql}
SELECT ARRAY[] FROM foo;

-- or more concise for updates:

UPDATE food set array_column = ARRAY[];
{code}




--
This message was sent by Atlassian Jira
(v8.3.4#803005)