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 <pomperma...@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 <jamestay...@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 <pomperma...@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 >
