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: |
22eda0985ecd1f456c073e6ad735a841 |
| 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
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.