/ File History
Login

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

History of test/indexexpr2.test

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