Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/indexexpr2.test
|
2019-10-29
| ||
| 16:18 | Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] file: [dba11dbb] check-in: [4d424f30] user: drh branch: trunk, size: 10329 | |
|
2019-08-29
| ||
| 19:34 | Fix other problems similar to ticket [c0390363]. file: [b580f378] check-in: [96ff2ba9] user: dan branch: trunk, size: 10330 | |
| 15:06 | Avoid assuming that for "~ (? AND FALSE)" to be true, "?" must not be NULL, just as we do for "NOT (? AND FALSE)". Fix for ticket [c0390363]. file: [efffd39a] check-in: [84ae41fd] user: dan branch: trunk, size: 8575 | |
|
2019-05-21
| ||
| 16:32 | Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. file: [d319e7d1] check-in: [a3e77c77] user: dan branch: trunk, size: 8187 | |
| 14:42 | Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. file: [a8a648c1] check-in: [b8071d10] user: dan branch: trunk, size: 8149 | |
|
2019-01-28
| ||
| 18:08 | Make indexes on CAST(...) expressions work. file: [38020c24] check-in: [3ef711d9] user: dan branch: index-on-cast, size: 7801 | |
|
2018-12-14
| ||
| 08:40 | Possible fix for [d96eba87]. file: [8dd1f8f9] check-in: [89a25abf] user: dan branch: tkt-d96eba87, size: 6813 | |
|
2018-11-28
| ||
| 11:49 | Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. file: [fc994dcd] check-in: [b53a9a3d] user: dan branch: trunk, size: 6326 | |
|
2018-09-16
| ||
| 16:18 | Add the new "explain" virtual table in ext/misc. Use this virtual table for additional test cases for the optimization that avoids updating indexes on expressions when none of the columns changed by the UPDATE are in the expression. file: [d8f56b6c] check-in: [2404304c] user: drh branch: trunk, size: 6253 | |
|
2018-09-15
| ||
| 21:38 | Optimization: when doing an UPDATE on a table with indexes on an expression, do not update the expression indexes if they do not refer to any of the columns of the table being updated. file: [05f490de] check-in: [a71b1016] user: drh branch: trunk, size: 5260 | |
|
2018-05-02
| ||
| 18:00 | Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [08551aa8] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 4349 | |
|
2017-09-28
| ||
| 01:09 | Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. file: [13247bac] check-in: [04130018] user: drh branch: trunk, size: 4291 | |
|
2017-09-04
| ||
| 00:19 | Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. file: [fdccd5c1] check-in: [03f3cc03] user: drh branch: trunk, size: 3567 | |
|
2017-08-18
| ||
| 08:29 | Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. file: [2237f140] check-in: [37e19008] user: dan branch: trunk, size: 3575 | |
|
2017-07-07
| ||
| 19:43 | Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). file: [3ddd7f23] check-in: [732f90d6] user: drh branch: trunk, size: 1053 | |
|
2017-04-21
| ||
| 17:03 | Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. file: [68ee9dbe] check-in: [bdc50d8d] user: dan branch: trunk, size: 1054 | |
|
2017-04-11
| ||
| 11:52 | Fix a segfault that could occur if an indexed expression was used in a comparison operation within the result-set of a SELECT statement. file: [bcf694ae] check-in: [d6bb7c42] user: dan branch: trunk, size: 915 Added | |