]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Do not allow a partial index scan on the left table of a RIGHT JOIN, because
authordrh <>
Wed, 8 Jun 2022 12:46:58 +0000 (12:46 +0000)
committerdrh <>
Wed, 8 Jun 2022 12:46:58 +0000 (12:46 +0000)
commit093dd41e9790396c31538b4a30b4b62e75d9ac82
treecfa5434d0d4228127d1f86917df4d280da100436
parentf6bee94e226914a9cf5b5a0a93b536e787bdc8f6
Do not allow a partial index scan on the left table of a RIGHT JOIN, because
since the index is partial, some rows will be omitted from the scan, and
those rows will subsequently be picked up by the no-match logic in the
right-join post-processing loop.
[forum:/forumpost/c4676c4956|forum post c4676c4956].

FossilOrigin-Name: 615c0026119f7870c3b6ef9dcb57ce4ecf5acedea3e2b5cfc25aa450eb8f17a0
manifest
manifest.uuid
src/where.c
test/index6.test