SQLite

All files named ”test/whereL.test”
Login

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

History for test/whereL.test

2025-04-10
14:53
[cb115604cc] part of check-in [d82725dcae] Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. (check-in: [d82725dcae] user: dan branch: forum-0109bca824, size: 8651)
2024-03-17
16:01
[438a397fa8] part of check-in [0eb2fbb891] Omit the "noop(X)" test SQL function. Accomplish the same thing using the idiom: "coalesce(X,random())". (check-in: [0eb2fbb891] user: drh branch: exp-values-clause2, size: 7480)
2024-03-16
19:36
[bf41203fda] part of check-in [92afea3888] Activate the enhanced constant-expression for the [constant propagation optimization](/info/f4229707ac08d66c). (check-in: [92afea3888] user: drh branch: enhanced-expr-is-const, size: 7435)
2024-03-07
12:34
[f0e9585623] part of check-in [720ce06d93] Do not allow the query planner to be tricked into thinking that an index on a constant expression might be useful for something. Problem reported on forum post ecdfc02339. This is a follow-up to the fixes at [44200596aa943963] and [2d2b91cc0f6fed8c]. (check-in: [720ce06d93] user: drh branch: trunk, size: 6730)
2023-02-10
21:53
[9d7c8a9f4e] part of check-in [44200596aa] Do a better job of detecting when a WHERE clause term might be useful to an expression index. Fix for performance regression reported by forum thread e65800d8cb. (check-in: [44200596aa] user: drh branch: trunk, size: 6113)
2021-05-14
15:37
[50171e3ec0] part of check-in [cf63abbe55] Avoid adding superfluous virtual WHERE clause terms that might arise due to the constant propagation optimization. (check-in: [cf63abbe55] user: drh branch: trunk, size: 5461)
2021-03-20
15:11
[7717caf61f] 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: 5461)
2020-12-16
20:00
[1afe47227f] part of check-in [00e4bf74d3] Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch. (check-in: [00e4bf74d3] user: dan branch: union-all-flattener, size: 5503)
2020-04-24
17:55
[e05cedc938] part of check-in [9e9f1e96c9] New test case for ticket [1dcb4d44964846ad]. (check-in: [9e9f1e96c9] user: drh branch: trunk, size: 5495)
2020-02-13
22:12
[d19499a39c] part of check-in [c9a8defcef] Fix problems in the constant propagation optimization that were introduced by check-in [1c3e5c20a9e6f501]. Fix for ticket [1dcb4d44964846ad] (check-in: [c9a8defcef] user: drh branch: trunk, size: 4560)
2020-01-08
01:43
[976f100f41] part of check-in [6db1c3498f] Fix the constant propagation optimization so that it does not try to propagate constant expressions that have affinity. Ticket [82ac75ba0093e5dc] (check-in: [6db1c3498f] user: drh branch: trunk, size: 4203)
2018-10-25
14:15
[0a19fc44cd] part of check-in [5d5b596f15] In the WHERE-constraint propagation optimization, if there are duplicate constraint, make sure only one of them propagates. Proposed fix for ticket [cf5ed20fc8621b165]. (check-in: [5d5b596f15] user: drh branch: trunk, size: 3572)
2018-10-05
20:09
[df02ffde4e] part of check-in [5c243eec7b] When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] (check-in: [5c243eec7b] user: drh branch: unique-constraint-weights, size: 3315)
2018-08-09
18:36
[84de61afe4] part of check-in [7404ea8316] When a column must be a constant due to WHERE clause and the value of that column is being coded as a constant, make sure the affinity is correct. (check-in: [7404ea8316] user: drh branch: trunk, size: 3263)
2018-07-26
23:54
[786ae3e0b6] part of check-in [50add839fd] Add a test case demonstrating the collation problem with constant propagation. (check-in: [50add839fd] user: drh branch: propagate-const-opt, size: 2222)
23:47
[eca38f3f9e] part of check-in [57eb2abd5b] Generalize the constant propagation optimization so that it applies on every WHERE close, not just those that contain a subquery. This then demonstrates that the current implementation is inadequate since it does not take into account collating sequences. (check-in: [57eb2abd5b] user: drh branch: propagate-const-opt, size: 1732)
21:16
Added: [46492cf4b3] part of check-in [2fb82ad8eb] Initial implementation of the WHERE-clause constant propagation optimization. (check-in: [2fb82ad8eb] user: drh branch: propagate-const-opt, size: 1260)