If I remember correctly, we don't support deep equality comparison in AsterixDB yet.
Best, Taewoo On Thu, Dec 28, 2017 at 9:19 PM, Wail Alkowaileet <wael....@gmail.com> wrote: > 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 >