Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|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|
|User & Date:||drh 2013-08-01 01:14:43|
|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|
|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 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.