/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/whereL.test

2018-10-25
14:15
In the WHERE-constraint propagation optimization, if there are duplicate constraint, make sure only one of them propagates. Proposed fix for ticket [cf5ed20fc8621b165]. file: [0a19fc44] check-in: [5d5b596f] user: drh branch: trunk, size: 3572
2018-10-05
20:09
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] file: [df02ffde] check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 3315
2018-08-09
18:36
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. file: [84de61af] check-in: [7404ea83] user: drh branch: trunk, size: 3263
2018-07-26
23:54
Add a test case demonstrating the collation problem with constant propagation. file: [786ae3e0] check-in: [50add839] user: drh branch: propagate-const-opt, size: 2222
23:47
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. file: [eca38f3f] check-in: [57eb2abd] user: drh branch: propagate-const-opt, size: 1732
21:16
Initial implementation of the WHERE-clause constant propagation optimization. file: [46492cf4] check-in: [2fb82ad8] user: drh branch: propagate-const-opt, size: 1260 Added