/ History for test/unordered.test
Login

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

History for test/unordered.test

2018-05-02
18:00
[ffeea774] part of check-in [5f0e803e] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 2205)
2014-04-28
15:11
[ca7adce0] part of check-in [20f468df] Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. (check-in: [20f468df] user: dan branch: experimental-costs, size: 2351)
2013-06-12
17:08
[ef85ac8f] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 2348)
2013-06-10
23:30
[08b4ea1c] part of check-in [aa580e36] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 2383)
2012-09-15
18:45
[93dce7b6] part of check-in [cfaa7bc1] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 2525)
2011-08-26
13:52
[279856a6] part of check-in [0df04f92] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 2380)
2011-08-13
19:35
[f53095ce] part of check-in [89b2f708] Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. (check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 2501)
2011-04-15
15:18
[87ecfbb6] part of check-in [8d924e16] Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: [8d924e16] user: drh branch: branch-3.7.2, size: 2304) Added
14:46
[e81169ce] part of check-in [a8761a91] Do not do full table scans of unordered indices. (check-in: [a8761a91] user: drh branch: trunk, size: 2425)
2011-04-09
19:17
[c479d302] part of check-in [f346dae1] Add test file unordered.test. (check-in: [f346dae1] user: dan branch: trunk, size: 2280) Added