[
https://issues.apache.org/jira/browse/CALCITE-3504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16974902#comment-16974902
]
Pressenna commented on CALCITE-3504:
------------------------------------
here's a quick check in postgresql:
{code:sql}
postgres=# create table arr (id int, ia int[]);
CREATE TABLE
postgres=# insert into arr values(1, [1]);
ERROR: syntax error at or near "["
LINE 1: insert into arr values(1, [1]);
^
postgres=# insert into arr values(1, array[1]);
INSERT 0 1
postgres=# insert into arr values(0, array[]);
ERROR: cannot determine type of empty array
LINE 1: insert into arr values(0, array[]);
^
HINT: Explicitly cast to the desired type, for example ARRAY[]::integer[].
postgres=# insert into arr values(0, cast(array[] as int[]));
INSERT 0 1
postgres=# update arr set ia=array[] where id = 1;
ERROR: cannot determine type of empty array
LINE 1: update arr set ia=array[] where id = 1;
^
HINT: Explicitly cast to the desired type, for example ARRAY[]::integer[].
postgres=# update arr set ia=cast(array[] as int[]) where id = 1;
UPDATE 1
postgres=# update arr set ia=cast(array[] as bool[]) where id = 1;
ERROR: column "ia" is of type integer[] but expression is of type boolean[]
LINE 1: update arr set ia=cast(array[] as bool[]) where id = 1;
^
HINT: You will need to rewrite or cast the expression.
{code}
> 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
> Priority: Major
>
> 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)
