phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Boolean condition doesn't support IS operator
Date Tue, 05 Dec 2017 16:54:25 GMT
In SQL, you use IS with NULL or NOT NULL as a way to test for null since
column = NULL will never return true. I’ve never seen a SQL dialect that
allows column IS true or column IS 4 as some kind of alternative to using
an equality expression. More on that here:
https://stackoverflow.com/questions/859762/is-this-the-proper-way-to-do-boolean-test-in-sql

On Tue, Dec 5, 2017 at 8:28 AM Flavio Pompermaier <pompermaier@okkam.it>
wrote:

> At the moment I'm usign VALID = true but IMHO Phoenix should support the
> IS syntax for boolean columns as well..of course this is just a +1 on this
> topic
> If no other one ask for this feature you could ignore this :)
>
> On Tue, Dec 5, 2017 at 4:31 PM, James Taylor <jamestaylor@apache.org>
> wrote:
>
>> How about just using VALID = true or just VALID like this: select * from
>> t where VALID
>>
>> On Tue, Dec 5, 2017 at 2:52 AM Flavio Pompermaier <pompermaier@okkam.it>
>> wrote:
>>
>>> Hi to all,
>>> I'm using Phoenix 4.7 and I cannot use IS operator on boolean values
>>> (e.g. VALID IS TRUE)
>>> Would it be that difficult to support it?
>>>
>>> Best,
>>> Flavio
>>>
>>
>
>
> --
> Flavio Pompermaier
> Development Department
>
> OKKAM S.r.l.
> Tel. +(39) 0461 041809
>

Mime
View raw message