Indeed - we need it someday! (Sooner rather than later would be nice.)
It basically needs to work like it does in languages like Python, I
think. (Cardinality and element by element equality for arrays,
cardinality and order-independent equality for bags, field by field
equality for records, and recursively through all of them.)
On 12/28/17 11:14 PM, Taewoo Kim wrote:
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 <[email protected]>
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
