/ File History
Login

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