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)