2 ms·
> The one thing that I have occasionally tripped over...this doesn't seem intuitive. This paragraph led me to discovering this oddity: > select 'true' from
by dotancohen 5y ago
> The one thing that I have occasionally tripped over...this doesn't seem intuitive.
This paragraph led me to discovering this oddity:
> select 'true' from dual where 3 not in (1, 2, null)
> Empty set (0.00 sec)
That's unexpected, and definitely something that I should be aware of. Thank you.
- yencabulator 5y agoSQL NULL is like NaN, it never equals anything. (And on top of that, the result of any comparison with NULL isn't a boolean, it's NULL.) Similarly (except the result is a boolean), $ deno eval --print 'NaN == NaN' false
- dotancohen 5y agoThanks.