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)
