/ Check-in [5c243eec]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment: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]
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | unique-constraint-weights
Files: files | file ages | folders
SHA3-256: 5c243eec7bcccda3f97c20c2f8a44e2811807615cf0ef378bb548f0791c55964
User & Date: drh 2018-10-05 20:09:07
Context
2018-10-05
20:09
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] Leaf check-in: 5c243eec user: drh tags: unique-constraint-weights
15:10
Changes to geopoly to silience false-positive warnings coming out of clang. check-in: 11d9015f user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to ext/rtree/rtreeC.test.

Changes to src/where.c.

Changes to test/whereF.test.

Changes to test/whereG.test.

Changes to test/whereL.test.

Changes to test/with3.test.