Comment by dotancohen
4 years 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.
SQL 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),
Thanks.