/ File History
Login

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