]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Improvements to "NOT IN (SELECT ...)" processing. Only test for NULL values
authordrh <drh@noemail.net>
Tue, 18 Feb 2014 01:07:38 +0000 (01:07 +0000)
committerdrh <drh@noemail.net>
Tue, 18 Feb 2014 01:07:38 +0000 (01:07 +0000)
commit552fd4544162c4ae28dda3ef29a62175c7bf630f
treef0f3e1a6475005a5fd2724e38ced38e6bd3768c0
parentbb13813ed1c68aaa3120c648db444922b9ec18c9
Improvements to "NOT IN (SELECT ...)" processing.  Only test for NULL values
on the RHS on the first iteration, then remember the result.  There has been
logic to do this for year, but it didn't work right and ended up repeating
the NULL test on every iteration.  This inefficiency was found using the
VDBE coverage testing tools.

FossilOrigin-Name: 915f6f1c7aab54583729e60bdc1565f25ecc6f74
manifest
manifest.uuid
src/expr.c