]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When the left-hand side of a WHERE clause contraint is a UNIQUE column, unique-constraint-weights
authordrh <drh@noemail.net>
Fri, 5 Oct 2018 20:09:07 +0000 (20:09 +0000)
committerdrh <drh@noemail.net>
Fri, 5 Oct 2018 20:09:07 +0000 (20:09 +0000)
commit07f9fbd52fd3534efc2be56e2920c11d25b3f125
treee12faa1246dd20dd558c4b6ac731a7228038171d
parentbebf54438e5393dcfa0f5c4b04f9c90428274ed8
When the left-hand side of a WHERE clause contraint is a UNIQUE column,
and that term of the WHERE clause is not used for indexing, assume that the
term reduces the number of output rows by half.  This is one proposed fix
for ticket [e8b674241947eb3ba4]

FossilOrigin-Name: 5c243eec7bcccda3f97c20c2f8a44e2811807615cf0ef378bb548f0791c55964
ext/rtree/rtreeC.test
manifest
manifest.uuid
src/where.c
test/whereF.test
test/whereG.test
test/whereL.test
test/with3.test