]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Fix for the problem identified in
authordrh <>
Thu, 3 Mar 2022 15:59:22 +0000 (15:59 +0000)
committerdrh <>
Thu, 3 Mar 2022 15:59:22 +0000 (15:59 +0000)
commitc9bcc5aab787e65ef1593d5b0943ad7b4bf4645b
tree3c03e912781891a3fd099719ddf9900a6386ca6e
parent1902516d16d24506a7ae8ce3ac776bbad78c539e
Fix for the problem identified in
[forum:/forumpost/0cd8e058bf|forum post 0cd8e058bf]:
When evaluating an multi-index OR, do not push down auxiliary WHERE clause
terms that involve subqueries into the OR-subqueries.  Otherwise, the
covering-index optimizer might convert table-references into index-references
for the particular OR index that is active for the branch in which the
subquery subroutine is coded, and those index-references
will not work if the subquery subroutine is invoked from a different OR branch
that uses a different index.

FossilOrigin-Name: 61a1c6dbd089979cbeb8b0c0c5ee1ab1abcb466be1d21a3a851be73c27e67a6c
manifest
manifest.uuid
src/wherecode.c
test/where7.test