/ Check-in [fb9044d1]
Login

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

Overview
Comment:Add the logic to keep partial indices up to date through DML statements and when new partial indices are created. This new logic is untested except to verify that it does not interfere with full indices.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | partial-indices
Files: files | file ages | folders
SHA1: fb9044d15ad4fd6ae4a38858c0c0e6fe9d4faa25
User & Date: drh 2013-08-01 01:14:43
Context
2013-08-01
03:36
Test cases and bug fixes for the partial index logic. check-in: 6b73ae7c user: drh tags: partial-indices
01:14
Add the logic to keep partial indices up to date through DML statements and when new partial indices are created. This new logic is untested except to verify that it does not interfere with full indices. check-in: fb9044d1 user: drh tags: partial-indices
2013-07-31
23:22
Add logic to the query planner to only use partial indices if the WHERE clause constrains the search to rows covered by the partial index. This is just infrastructure. The key routine, sqlite3ExprImpliesExpr(), is currently a no-op so that partial indices will never be used. check-in: 8ca3eac1 user: drh tags: partial-indices
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/build.c.

Changes to src/delete.c.

Changes to src/expr.c.

Changes to src/insert.c.

Changes to src/pragma.c.

Changes to src/sqliteInt.h.

Changes to src/update.c.

Changes to src/vdbeaux.c.

Changes to src/where.c.