it would give the same result, its the exact same "mental-mistake".... if you negate the filter you get exactly what you would get negating the operator i.e. WHERE NOT column = 'T' matches exactly WHERE COLUMN <> 'T'
a column holding a NULL value is "non-existant" for any (and I mean, really any) where condition you may want to apply, except the specific ones: - IS NULL - IS NOT NULL On Thursday, August 8, 2013 3:31:17 AM UTC+2, Joe Barnhart wrote: > > Not to be flip, but couldn't you just reverse the test and use > ~(mytable.mybool==False)? That would be false for False and true for True > and None (NULL) > > But I agree it is an interesting find, and I will watch out for this in my > own code. Thanks for posting! > > -- Joe > > On Wednesday, August 7, 2013 2:00:42 PM UTC-7, Richard wrote: >> >> Hello, >> >> Found this not working : >> >> db((db.mytable.id == 1) & (db.mytable.mybool != True).select() >> >> That translate as : >> SELECT * FROM mytable WHERE mytable.id = 1 AND mytable.mybool <> 'T' >> >> NO RECORD, BUT THERE IS A RECORD >> >> If i change the select like this : >> SELECT * FROM mytable WHERE mytable.id = 1 AND mytable.mybool IS NOT TRUE >> >> I get my record. >> >> The issue seems to occure only when the "mybool" is NULL other then that >> (TRUE or FALSE) I got my record... >> >> Thanks >> >> Richard >> >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
