On 1 Nov 2019, at 4:17pm, Simon Slavin <slav...@bigfraud.org> wrote: > 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'm so sorry. It is actually WHERE (c1 IS NULL) OR (C1 != 2) which could quite reasonably return rows. However, the NULL possibility may be redundant. I can't tell without tests. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users