SQLite

All files named ”test/indexexpr2.test”
Login

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

History for test/indexexpr2.test

2023-04-03
23:49
[1c382e81ef] part of check-in [898bfa1afd] When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. Forum post 409ebc7368. (check-in: [898bfa1afd] user: drh branch: trunk, size: 12169)
17:46
[f5732485ab] part of check-in [cf6454ce26] When changing a COLLATE expression node into TK_AGG_COLUMN because the nodes value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. Fix for the assertion faults reported by forum post e45108732c and forum post 44270909bb. (check-in: [cf6454ce26] user: drh branch: trunk, size: 11611)
2023-03-24
20:35
[8a4cf83e12] part of check-in [d8259877ea] Fix the handling of indexed expressions in an outer query that appear as corelated values inside an aggregate function within a subquery. Forum post 79cf371080. (check-in: [d8259877ea] user: drh branch: trunk, size: 10732)
2021-03-20
15:11
[2c7abe3c48] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 10299)
2019-10-29
16:18
[dba11dbb0a] part of check-in [4d424f3047] 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: [4d424f3047] user: drh branch: trunk, size: 10329)
2019-08-29
19:34
[b580f37842] part of check-in [96ff2ba9c4] Fix other problems similar to ticket [c0390363]. (check-in: [96ff2ba9c4] user: dan branch: trunk, size: 10330)
15:06
[efffd39a27] part of check-in [84ae41fd2f] 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: [84ae41fd2f] user: dan branch: trunk, size: 8575)
2019-05-21
16:32
[d319e7d1b1] part of check-in [a3e77c7776] Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. (check-in: [a3e77c7776] user: dan branch: trunk, size: 8187)
14:42
[a8a648c1a6] part of check-in [b8071d10cb] 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: [b8071d10cb] user: dan branch: trunk, size: 8149)
2019-01-28
18:08
[38020c247e] part of check-in [3ef711d98f] Make indexes on CAST(...) expressions work. (check-in: [3ef711d98f] user: dan branch: index-on-cast, size: 7801)
2018-12-14
08:40
[8dd1f8f936] part of check-in [89a25abfcd] Possible fix for [d96eba87]. (check-in: [89a25abfcd] user: dan branch: tkt-d96eba87, size: 6813)
2018-11-28
11:49
[fc994dcd4b] part of check-in [b53a9a3dc6] Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: [b53a9a3dc6] user: dan branch: trunk, size: 6326)
2018-09-16
16:18
[d8f56b6cf4] part of check-in [2404304cc1] 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: [2404304cc1] user: drh branch: trunk, size: 6253)
2018-09-15
21:38
[05f490de32] part of check-in [a71b101635] 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: [a71b101635] user: drh branch: trunk, size: 5260)
2018-05-02
18:00
[08551aa895] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 4349)
2017-09-28
01:09
[13247bac49] part of check-in [0413001843] Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (check-in: [0413001843] user: drh branch: trunk, size: 4291)
2017-09-04
00:19
[fdccd5c13a] part of check-in [03f3cc03aa] Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. (check-in: [03f3cc03aa] user: drh branch: trunk, size: 3567)
2017-08-18
08:29
[2237f1408e] part of check-in [37e1900880] Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (check-in: [37e1900880] user: dan branch: trunk, size: 3575)
2017-07-07
19:43
[3ddd7f23bc] part of check-in [732f90d632] 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: [732f90d632] user: drh branch: trunk, size: 1053)
2017-04-21
17:03
[68ee9dbe83] part of check-in [bdc50d8d12] Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. (check-in: [bdc50d8d12] user: dan branch: trunk, size: 1054)
2017-04-11
11:52
Added: [bcf694ae72] part of check-in [d6bb7c42ff] 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: [d6bb7c42ff] user: dan branch: trunk, size: 915)