SQLite

Check-in [bc446449a1]
Login

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

Overview
Comment:Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bc446449a19171c0fa0681973b06bc80d3c0517f
User & Date: drh 2013-09-13 17:47:57.412
Context
2013-09-13
18:15
Remove one unreachable branch and add asserts() to dupedExprStructSize(). New asserts verify that removed branch is unused and that constants that are ORed together in the output do not overlap. (check-in: 86ad358b5a user: drh tags: trunk)
17:47
Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms. (check-in: bc446449a1 user: drh tags: trunk)
16:56
Enhance the pragma lookup table generator script to output a comment that gives the number of pragmas. (check-in: ca05205050 user: drh tags: trunk)
2013-09-12
23:42
Refactor the ExprSetIrreducible() macro into ExprSetVVAProperty(*,EP_NoReduce). This is a naming change only. The logic is the same. (Closed-Leaf check-in: 695aee46e9 user: drh tags: unlikely-func)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/attach.c.
Changes to src/expr.c.
Changes to src/func.c.
Changes to src/parse.y.
Changes to src/resolve.c.
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/walker.c.
Changes to src/where.c.
Changes to test/analyze9.test.
Added test/whereG.test.