/ History for test/indexexpr2.test
Login

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

History for test/indexexpr2.test

2019-10-29
16:18
[dba11dbb] part of check-in [4d424f30] 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] (check-in: [4d424f30] user: drh branch: trunk, size: 10329)
2019-08-29
19:34
[b580f378] part of check-in [96ff2ba9] Fix other problems similar to ticket [c0390363]. (check-in: [96ff2ba9] user: dan branch: trunk, size: 10330)
15:06
[efffd39a] part of check-in [84ae41fd] 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]. (check-in: [84ae41fd] user: dan branch: trunk, size: 8575)
2019-05-21
16:32
[d319e7d1] part of check-in [a3e77c77] Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. (check-in: [a3e77c77] user: dan branch: trunk, size: 8187)
14:42
[a8a648c1] part of check-in [b8071d10] Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. (check-in: [b8071d10] user: dan branch: trunk, size: 8149)
2019-01-28
18:08
[38020c24] part of check-in [3ef711d9] Make indexes on CAST(...) expressions work. (check-in: [3ef711d9] user: dan branch: index-on-cast, size: 7801)
2018-12-14
08:40
[8dd1f8f9] part of check-in [89a25abf] Possible fix for [d96eba87]. (check-in: [89a25abf] user: dan branch: tkt-d96eba87, size: 6813)
2018-11-28
11:49
[fc994dcd] part of check-in [b53a9a3d] Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: [b53a9a3d] user: dan branch: trunk, size: 6326)
2018-09-16
16:18
[d8f56b6c] part of check-in [2404304c] 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. (check-in: [2404304c] user: drh branch: trunk, size: 6253)
2018-09-15
21:38
[05f490de] part of check-in [a71b1016] 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. (check-in: [a71b1016] user: drh branch: trunk, size: 5260)
2018-05-02
18:00
[08551aa8] part of check-in [5f0e803e] 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. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 4349)
2017-09-28
01:09
[13247bac] part of check-in [04130018] Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (check-in: [04130018] user: drh branch: trunk, size: 4291)
2017-09-04
00:19
[fdccd5c1] part of check-in [03f3cc03] Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. (check-in: [03f3cc03] user: drh branch: trunk, size: 3567)
2017-08-18
08:29
[2237f140] part of check-in [37e19008] Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (check-in: [37e19008] user: dan branch: trunk, size: 3575)
2017-07-07
19:43
[3ddd7f23] part of check-in [732f90d6] 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). (check-in: [732f90d6] user: drh branch: trunk, size: 1053)
2017-04-21
17:03
[68ee9dbe] part of check-in [bdc50d8d] Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. (check-in: [bdc50d8d] user: dan branch: trunk, size: 1054)
2017-04-11
11:52
[bcf694ae] part of check-in [d6bb7c42] Fix a segfault that could occur if an indexed expression was used in a comparison operation within the result-set of a SELECT statement. (check-in: [d6bb7c42] user: dan branch: trunk, size: 915) Added