/ Check-in [22eda098]
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 | SQL 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
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: b7f70c7f 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: 22eda098 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: 0a5e1c04 user: drh tags: index-on-date-func
Changes
Unified Diffs Side-by-Side Diffs 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.