I realize that SQLite will handle NULLs according to: https://sqlite.org/nulls.html
As best as I can tell this is a case not listed on that page and gives an
answer different than I would expect:
select case when null not in ('a') then 'not in list' else 'is in list' end;
This gives "is in list". But since null is clearly not in the list of one
member ('a'), I would expect this to generate "not in the list".
Is this expected behavior, or a bug?
Thank you,
Denis Burke
