phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Pompermaier <pomperma...@okkam.it>
Subject Re: Boolean condition doesn't support IS operator
Date Tue, 05 Dec 2017 17:23:00 GMT
Ok, fine for me :)
Thanks for the discussion anyway

On Tue, Dec 5, 2017 at 5:54 PM, James Taylor <jamestaylor@apache.org> wrote:

> 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 <+39%200461%20041809>
>>
>


-- 
Flavio Pompermaier
Development Department

OKKAM S.r.l.
Tel. +(39) 0461 041809

Mime
View raw message