Many hyperlinks are disabled.

Use anonymous login
to enable hyperlinks.

## History of test/whereL.test

2020-02-13
| ||

22:12 | [d19499a3] part of check-in [c9a8defc] Fix problems in the constant propagation optimization that were introduced by check-in [1c3e5c20a9e6f501]. Fix for ticket [1dcb4d44964846ad] (check-in: [c9a8defc] user: drh branch: trunk, size: 4560) | |

2020-01-08
| ||

01:43 | [976f100f] part of check-in [6db1c349] Fix the constant propagation optimization so that it does not try to propagate constant expressions that have affinity. Ticket [82ac75ba0093e5dc] (check-in: [6db1c349] user: drh branch: trunk, size: 4203) | |

2018-10-25
| ||

14:15 | [0a19fc44] part of check-in [5d5b596f] 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: [5d5b596f] user: drh branch: trunk, size: 3572) | |

2018-10-05
| ||

20:09 | [df02ffde] part of check-in [5c243eec] 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: [5c243eec] user: drh branch: unique-constraint-weights, size: 3315) | |

2018-08-09
| ||

18:36 | [84de61af] part of check-in [7404ea83] 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: [7404ea83] user: drh branch: trunk, size: 3263) | |

2018-07-26
| ||

23:54 | [786ae3e0] part of check-in [50add839] Add a test case demonstrating the collation problem with constant propagation. (check-in: [50add839] user: drh branch: propagate-const-opt, size: 2222) | |

23:47 | [eca38f3f] part of check-in [57eb2abd] 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: [57eb2abd] user: drh branch: propagate-const-opt, size: 1732) | |

21:16 |
[46492cf4]
part of check-in [2fb82ad8]
Initial implementation of the WHERE-clause constant propagation optimization.
(check-in: [2fb82ad8]
user: drh
branch: propagate-const-opt,
size: 1260)
Added
| |