SQLite

Check-in [22eda0985e]
Login

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

Overview
Comment:Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | index-on-date-func
Files: files | file ages | folders
SHA3-256: 22eda0985ecd1f456c073e6ad735a8417f3ff1fb6aaad1640e1cec01e50c51d8
User & Date: drh 2017-07-20 13:17:08.298
Context
2017-07-20
14:36
New test cases for date/time functions in indexes on expressions, in the WHERE clause of partial indexes, and in CHECK constraints. (Closed-Leaf check-in: b7f70c7fca user: drh tags: index-on-date-func)
13:17
Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. (check-in: 22eda0985e user: drh tags: index-on-date-func)
2017-07-19
19:48
Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (check-in: 0a5e1c04d9 user: drh tags: index-on-date-func)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/date.c.
Changes to src/expr.c.
Changes to src/insert.c.
Changes to src/pragma.c.
Changes to src/shell.c.
Changes to src/sqliteInt.h.
Changes to src/vdbe.h.
Changes to src/vdbeaux.c.
Added test/date2.test.
Changes to test/indexexpr1.test.