Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/whereF.test
|
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: [a7fd9eda] check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 9312 | |
|
2018-01-27
| ||
| 13:55 | New test case for ticket [ec32177c99ccac2b1] that works without the STAT4. file: [3d9412b1] check-in: [5259d484] user: drh branch: trunk, size: 9347 | |
| 05:40 | Proposed fix for the query planner problem of ticket [ec32177c99ccac2b1]. file: [15552693] check-in: [eef8cbef] user: drh branch: trunk, size: 8173 | |
|
2017-10-12
| ||
| 11:13 | Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and DEFAULT_AUTOVACUUM builds. file: [d44b5833] check-in: [4b68f424] user: dan branch: trunk, size: 6458 | |
|
2017-10-04
| ||
| 14:13 | New test cases for ticket [b899b6042f97f5] derived from a bug report on the mailing list from Wout Mertens. file: [a44c7d73] check-in: [ef94ea06] user: drh branch: trunk, size: 6452 | |
|
2017-09-11
| ||
| 23:46 | New test case for ticket [b899b6042f97f52d]. file: [7c426e0b] check-in: [9d91ee5e] user: drh branch: trunk, size: 5784 | |
|
2017-09-04
| ||
| 00:33 | Proposed fix for ticket [b899b6042f97f5] file: [ec178da9] check-in: [c7f9f47b] user: drh branch: trunk, size: 5354 | |
|
2017-06-22
| ||
| 16:51 | When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. file: [97a86ecd] check-in: [e4a022be] user: dan branch: or-optimization, size: 5136 | |
|
2013-08-30
| ||
| 17:35 | If the cost of two whereLoop objects is the same in every way except that one has fewer expected output rows than the other, then choose the one with fewer output rows. file: [5b2ba0db] check-in: [79e458ef] user: drh branch: trunk, size: 3704 | |
|
2013-06-12
| ||
| 14:52 | Add the "queryplanner" test permutation. Continuing refinements to NGQP. file: [136a7301] check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 3472 | |
|
2012-11-09
| ||
| 17:59 | Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. file: [a0e29664] check-in: [94255634] user: drh branch: inner-loop-cost, size: 3461 Added | |