On 1 Nov 2019, at 3:12pm, And Clover <and-...@doxdesk.com> wrote:
> WHERE NOT (c1 IS NOT NULL AND c1=2);
>
> Expected result: (1)
> Actual result: no rows returned
This is a cut-down example, right ? You can't possibly mean to do that WHERE
clause in production code. It amounts to
WHERE (c1 IS NULL) AND (C1 != 2)
I don't know how SQLite will evaluate that for all cases but I wouldn't be
surprised to find zero rows returned.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
