Hi Devs,

Currently we have an inconsistent behavior regarding the comparators:

In join, we allow such operation

SELECT *
FROM [[1],[2],[3]] array1, [[1],[2],[3]] array2
WHERE array1 = array2

In select, an exception is thrown
SELECT *
FROM [[1],[2],[3]] array1
WHERE array1 = [1]

Error ASX0004: Unsupported type: comparison operations (>, >=, <, and <=)
cannot process input type array

What should be the semantics for such operations?


-- 

*Regards,*
Wail Alkowaileet

Reply via email to