Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 9C7C5200D77 for ; Fri, 29 Dec 2017 06:20:09 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 90410160C20; Fri, 29 Dec 2017 05:20:09 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D3CEA160C1F for ; Fri, 29 Dec 2017 06:20:08 +0100 (CET) Received: (qmail 49233 invoked by uid 500); 29 Dec 2017 05:20:08 -0000 Mailing-List: contact dev-help@asterixdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.apache.org Delivered-To: mailing list dev@asterixdb.apache.org Received: (qmail 49154 invoked by uid 99); 29 Dec 2017 05:20:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 29 Dec 2017 05:20:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 60CD0C1E5F for ; Fri, 29 Dec 2017 05:20:06 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.879 X-Spam-Level: * X-Spam-Status: No, score=1.879 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id vLn4jzO0sCsi for ; Fri, 29 Dec 2017 05:20:05 +0000 (UTC) Received: from mail-ot0-f171.google.com (mail-ot0-f171.google.com [74.125.82.171]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 6E1025FB29 for ; Fri, 29 Dec 2017 05:20:05 +0000 (UTC) Received: by mail-ot0-f171.google.com with SMTP id n18so27666497otd.1 for ; Thu, 28 Dec 2017 21:20:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=9Ukl63ZqSQ7qQMf/sMMHvc/mS756a6QpA1O906BTWyQ=; b=hq4Jw0JwzYo3OBQHRejBryQGHDgjXrbqad7mLN7Z4m+Wjbd5rp2emJooYXLRz2VkgT QZmkuN6PPbaQamv62gcAoU7FeENfCJROJxTL5JwcSxAeSrKdGxKvEhCPHKemslrct1Rf Lvul2rfEGYYmqrxJhPEMPJ3MZ+MtRMqPtAZT1i6dEpxceWcHpEgw+V6Tn765yJn5/lDq OMNomWwH23P+HY8e529tPGAuoL/DtxdfbPQ/+nHVweeQNK0yT2Z3Q7T7SsnqdGMUGMQq 3feqyhq6HKvY7GGbbR/DVHgWb+vmAn3wNtfMUfFDP/3y8vAkvfH0gQUStrKXnexDWD4s nqMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=9Ukl63ZqSQ7qQMf/sMMHvc/mS756a6QpA1O906BTWyQ=; b=lm1TTFoglF0nOMiVQu1w21HRY2q5eU6Y2mVwU9JDBp5VVucbFIRCtNynOShFUd2sxK vaRrVzzKWYxuj5i3txmZwWqhWKCsM/uTPn+v5pIwoDNn9CvXEPG/pB86Rx8OE9Sv4ylM cAlFJJQWaKntGJYdV8ofjnEhiGxM6o4ls0OYM2+n8Xa70VY5PYqHUks+bhjwkzFpWx6y HBfgkyB0sA879KHuX3buHgHyMUdGSODhUwhxOXa10di+H0H2PN1IE0YmMkiO4ih7KQT7 EOvhLVQk2XJQ7m6ut+lGNpplKF7f+rbqUG/+iMQCtVmzazoJggn38p56DsrWxcHHNcxF 5iOQ== X-Gm-Message-State: AKGB3mKbc5IjTZkzRfSmX0x2g4YxNC3+Fd+Qh9Iw5d3Yhmy7Xjr4Boo1 cq732UFgsvRp7izL9P7xaNMbTirk3KBLDS3FOqtArQ== X-Google-Smtp-Source: ACJfBosQeWoUGl77XjaWXXtZqMto++b0bo31ynhmArG8RqrkPu4l32jPLkZcJKxXhmKsbCUgMalA76Ff4687NA6j+QI= X-Received: by 10.157.22.194 with SMTP id s2mr20803455ots.153.1514524799046; Thu, 28 Dec 2017 21:19:59 -0800 (PST) MIME-Version: 1.0 Received: by 10.157.87.200 with HTTP; Thu, 28 Dec 2017 21:19:58 -0800 (PST) From: Wail Alkowaileet Date: Thu, 28 Dec 2017 21:19:58 -0800 Message-ID: Subject: Comparison semantics for complex types To: dev@asterixdb.apache.org Content-Type: multipart/alternative; boundary="001a113ecea6a69b10056173c874" archived-at: Fri, 29 Dec 2017 05:20:09 -0000 --001a113ecea6a69b10056173c874 Content-Type: text/plain; charset="UTF-8" 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 --001a113ecea6a69b10056173c874--