Is this similar to the “deep_equal” function I implemented a while ago?
-heri Sent from my iPhone > On Dec 29, 2017, at 17:23, Mike Carey <[email protected]> wrote: > > 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 >>> >
