]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2c71887) | patch
When an index is used by all branches of the WHERE_MULTI_OR optimization and
authordrh <>
Tue, 22 Jun 2021 23:24:58 +0000 (23:24 +0000)
committerdrh <>
Tue, 22 Jun 2021 23:24:58 +0000 (23:24 +0000)
commit415ac68ae8a5c6c9a8806cc34b01101ca0891bd3
tree7bf99c180c7bb5245d643ed40ce13c072c0f8cdftree | snapshot
parent2c7188732d7c62a0b04bc972c3b161442e693e28commit | diff
When an index is used by all branches of the WHERE_MULTI_OR optimization and
becomes a covering index, make sure the index has been created prior to
NULLing it in the OP_NullRow opcode of a LEFT JOIN.  See
[forum:/forumpost/0575376e07|forum post 0575376e07]. The covering-index for
WHERE_MULTI_OR optimization was added by [62678be3df35cdcb].  Test cases are
in the orindex01.test module of TH3.

FossilOrigin-Name: 787c76a865dc51dbca4f30432d64783199c2efb1df4619e4bbaf32182977321e
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/where.c diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git