Mailing-List: contact dev-help@asterixdb.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.incubator.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CABytAGobf1528x5P0V1WG05fa7vfmpyufBfDSTXOsKyiOfcthw@mail.gmail.com>
References: 
 <CAE1xAnurzfC9dP4cAvCZcMyT79ME4GH-aGqeM413QPnoPB_TPA@mail.gmail.com>
 <CABytAGoyf8LhVBFiH_SYvAL5dEDwuSNPMsDMy46CALroQdjppw@mail.gmail.com>
 <CAE1xAntiG6SyJYuXprbDMBWJURrFP2a8OgPY24tFb+W_nc+rKg@mail.gmail.com>
 <CABytAGobf1528x5P0V1WG05fa7vfmpyufBfDSTXOsKyiOfcthw@mail.gmail.com>
From: Taewoo Kim <wangsaeu@gmail.com>
Date: Wed, 19 Aug 2015 10:50:23 -0700
Message-ID: 
 <CABytAGrDOLXLZhT49x=CJP7_CT+578HQqrdQEHoRc8ZRA+BtAQ@mail.gmail.com>
Subject: Re: Strange Comparison Allowed
To: dev@asterixdb.incubator.apache.org
Content-Type: multipart/alternative; boundary=001a113a9baa73eb1f051dadac7a

--001a113a9baa73eb1f051dadac7a
Content-Type: text/plain; charset=UTF-8

Sorry. The direction of inequality operator was misleading. STRING 13 is
smaller than (<) POINT 20.

Best,
Taewoo

On Wed, Aug 19, 2015 at 10:49 AM, Taewoo Kim <wangsaeu@gmail.com> wrote:

> Yes. Type conversion (casting) only happens among numeric types so far.
> Actually, since there is a type-tag, if you try to compare two non numeric
> types, it stops the comparing as soon as it sees the first byte from both
> side since type-tag itself has the given order (e.g., STRING 13 > POINT
> 20). This is required for ORDER BY, too.
>
> Best,
> Taewoo
>
> On Wed, Aug 19, 2015 at 10:45 AM, Steven Jacobs <sjaco002@ucr.edu> wrote:
>
>> I see, so we are technically allowed to compare anything to anything?
>>
>> Steven
>>
>> On Wed, Aug 19, 2015 at 10:37 AM, Taewoo Kim <wangsaeu@gmail.com> wrote:
>>
>> > If there is no right comparator for the given types (STRING vs POINT),
>> then
>> > it does the "byte by byte" comparison.
>> >
>> > Best,
>> > Taewoo
>> >
>> > On Wed, Aug 19, 2015 at 10:32 AM, Steven Jacobs <sjaco002@ucr.edu>
>> wrote:
>> >
>> > > This is currently working in master:
>> > >
>> > > create type CSXType as closed {
>> > >   id: int32,
>> > >   csxid: string
>> > > }
>> > > create dataset CSX(CSXType) primary key id;
>> > >
>> > > for $b in dataset('CSX')
>> > > where $b.id > point("3,5")
>> > > return $b;
>> > >
>> > > Is this supposed to be working?
>> > > Steven
>> > >
>> >
>>
>
>

--001a113a9baa73eb1f051dadac7a--