]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d3285e6) | patch
Enhance the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] so that
authordrh <>
Thu, 22 Jan 2026 19:02:32 +0000 (19:02 +0000)
committerdrh <>
Thu, 22 Jan 2026 19:02:32 +0000 (19:02 +0000)
commitcb3d6d14febae2547f1bd4661eab0795dc8e815b
treeeffedd32d8f066dee2ee8753d68ae4a6bb99f3ectree | snapshot
parentd3285e67a80ede72022f782d09fde6b08e67ab46commit | diff
Enhance the [/info/e33da6d5dc964db8|EXISTS-to-JOIN optimization] so that
the inserted JOIN terms are not required to be on the inner-most loops,
as long as all dependencies for the EXISTS-to-JOIN loops are in outer
loops.  This addresses the performance concern of
[forum:/forumpost/2026-01-21T19:49:04z|forum post 2026-01-21T19:49:04z].
Test cases in TH3.

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