/ All files named "test/whereF.test"
Login

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

History for test/whereF.test

2018-10-05
20:09
[a7fd9eda] 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: 9312)
2018-01-27
13:55
[3d9412b1] part of check-in [5259d484] New test case for ticket [ec32177c99ccac2b1] that works without the STAT4. (check-in: [5259d484] user: drh branch: trunk, size: 9347)
05:40
[15552693] part of check-in [eef8cbef] Proposed fix for the query planner problem of ticket [ec32177c99ccac2b1]. (check-in: [eef8cbef] user: drh branch: trunk, size: 8173)
2017-10-12
11:13
[d44b5833] part of check-in [4b68f424] Update some test cases to work with SQLITE_OMIT_VIRTUALTABLE and DEFAULT_AUTOVACUUM builds. (check-in: [4b68f424] user: dan branch: trunk, size: 6458)
2017-10-04
14:13
[a44c7d73] part of check-in [ef94ea06] New test cases for ticket [b899b6042f97f5] derived from a bug report on the mailing list from Wout Mertens. (check-in: [ef94ea06] user: drh branch: trunk, size: 6452)
2017-09-11
23:46
[7c426e0b] part of check-in [9d91ee5e] New test case for ticket [b899b6042f97f52d]. (check-in: [9d91ee5e] user: drh branch: trunk, size: 5784)
2017-09-04
00:33
[ec178da9] part of check-in [c7f9f47b] Proposed fix for ticket [b899b6042f97f5] (check-in: [c7f9f47b] user: drh branch: trunk, size: 5354)
2017-06-22
16:51
[97a86ecd] part of check-in [e4a022be] 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. (check-in: [e4a022be] user: dan branch: or-optimization, size: 5136)
2013-08-30
17:35
[5b2ba0db] part of check-in [79e458ef] 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. (check-in: [79e458ef] user: drh branch: trunk, size: 3704)
2013-06-12
14:52
[136a7301] part of check-in [25e2cde1] Add the "queryplanner" test permutation. Continuing refinements to NGQP. (check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 3472)
2012-11-09
17:59
Added: [a0e29664] part of check-in [94255634] Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (check-in: [94255634] user: drh branch: inner-loop-cost, size: 3461)