]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9debb58) | patch
Cannot use an automatic index on the right table of a RIGHT JOIN because
authordrh <>
Sun, 10 Apr 2022 23:48:47 +0000 (23:48 +0000)
committerdrh <>
Sun, 10 Apr 2022 23:48:47 +0000 (23:48 +0000)
commit529394e5c1399577be9a882b2f8be11fa1966cf5
tree34b3f08195bf8ebe9d385882dee8e83226fd25betree | snapshot
parent9debb58e4801ad5737ff88fbc117a1fc06695efacommit | diff
Cannot use an automatic index on the right table of a RIGHT JOIN because
automatic indexes must be WHERE_IDX_ONLY, but the RIGHT JOIN post-processing
does not know how to work with an index-only scan.

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