SQLite

Check-in [fb9044d15a]
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
Timelines: family | ancestors | descendants | both | partial-indices
Files: files | file ages | folders
SHA1: fb9044d15ad4fd6ae4a38858c0c0e6fe9d4faa25
User & Date: drh 2013-08-01 01:14:43.210
Context
2013-08-01
03:36
Test cases and bug fixes for the partial index logic. (check-in: 6b73ae7c12 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: fb9044d15a 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: 8ca3eac111 user: drh tags: partial-indices)
Changes
Unified Diff Side-by-Side Diff 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.