SQLite

All files named ”test/date2.test”
Login

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

History for test/date2.test

2021-03-16
18:41
[7e12ec14aa] part of check-in [1734c332e7] Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f]. (check-in: [1734c332e7] user: drh branch: trunk, size: 5802)
2020-08-27
18:36
[520a1708e4] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 5548)
2019-10-30
18:50
[5ef8265c71] part of check-in [2978b65ebe] Always disallow the use of non-deterministic functions in CHECK constraints, even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] (check-in: [2978b65ebe] user: drh branch: trunk, size: 5495)
2017-07-20
14:36
[74c234bece] part of check-in [b7f70c7fca] New test cases for date/time functions in indexes on expressions, in the WHERE clause of partial indexes, and in CHECK constraints. (check-in: [b7f70c7fca] user: drh branch: index-on-date-func, size: 4179)
13:17
Added: [f8d82bb0bd] part of check-in [22eda0985e] 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 branch: index-on-date-func, size: 1612)