]> git.ipfire.org Git - thirdparty/sqlite.git/commit
In partial index scans, if the WHERE clause implies a constant value for a table...
authordan <Dan Kennedy>
Fri, 22 Sep 2023 20:21:27 +0000 (20:21 +0000)
committerdan <Dan Kennedy>
Fri, 22 Sep 2023 20:21:27 +0000 (20:21 +0000)
commitbd42642431853d9bb83544e123ae905633636e97
tree02404c596360434fd975ba5e902555de4edaee02
parent8aaf63c6ac8b8292c0ecead0d2b04b68e9e6be78
In partial index scans, if the WHERE clause implies a constant value for a table column, replace occurences of that table column with the constant. This increases the likelihood of the partial index being a covering index.

FossilOrigin-Name: 66ed7abdfa228abde2052e3988589371f0e49b11582b1b4a83255d2df3a0aefa
manifest
manifest.uuid
src/build.c
src/expr.c
src/sqliteInt.h
src/where.c
test/indexA.test [new file with mode: 0644]