Mailing-List: contact dev-help@chemistry.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@chemistry.apache.org
MIME-Version: 1.0
In-Reply-To: <F3C20471-B575-4A50-84CD-623545A80262@gmail.com>
References: <F3C20471-B575-4A50-84CD-623545A80262@gmail.com>
From: Florent Guillaume <fguillaume@nuxeo.com>
Date: Tue, 30 Aug 2016 14:58:31 +0200
Message-ID: <CAF-4BpP3T6Q=J=ge7X5EzBDggysAALPa0RoGGZ-ihBmx-SnqSA@mail.gmail.com>
Subject: Re: Query - IN/ANY Predicate
To: dev@chemistry.apache.org
Content-Type: multipart/alternative; boundary=001a113faa58e3fa78053b498a17
archived-at: Tue, 30 Aug 2016 12:58:59 -0000

--001a113faa58e3fa78053b498a17
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,

Please check the spec, =C2=A72.1.14.2.1 (BNF Grammar) for the allowed synta=
x:

  <column reference> [ NOT ] IN "(" <in value list> ")"
  <literal> "=3D" ANY <multi-valued-column reference>
  ANY <multi-valued-column reference> [ NOT ] IN "(" <in value list> ")

Also read =C2=A72.1.14.2.4.3 (Multi-valued column references) for explanati=
ons.

Florent


On Tue, Aug 30, 2016 at 8:10 AM, Sascha Homeier <sascha.homeier@gmail.com>
wrote:

>
> Hi together,
>
> I am unsure about what is the proper behaviour for queries on multi-value=
d
> properties.
>
> Is a simple IN operation (without the ANY predicate) on a multi-valued
> property type allowed or should the server return a
> CmisInvalidArgumentException?
> If allowed, what is the difference between a simple IN and an ANY/IN
> operation?
>
> tia
>
> Cheers
> Sascha


--=20
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87

--001a113faa58e3fa78053b498a17--