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
