Dmitry Sysolyatin created CALCITE-5160: ------------------------------------------
Summary: ANY, SOME functions should support subquery and scalar arrays Key: CALCITE-5160 URL: https://issues.apache.org/jira/browse/CALCITE-5160 Project: Calcite Issue Type: Bug Components: core Reporter: Dmitry Sysolyatin At the moment ANY, SOME functions support subquery: {code} SELECT 1 = SOME (SELECT * FROM UNNEST(ARRAY[1,2,3])) {code} But if input argument is array, then query fails {code} SELECT 1 = SOME (ARRAY[1,2,3]) SELECT 1 = SOME(<table>.<array_type_field> FROM <table>) {code} [https://www.postgresql.org/docs/current/functions-comparisons.html#id-1.5.8.30.16] It is useful for checking if a value exists in an array. -- This message was sent by Atlassian Jira (v8.20.7#820007)