/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/unordered.test

2018-05-02
18:00
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. file: [ffeea774] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 2205
2014-04-28
15:11
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. file: [ca7adce0] check-in: [20f468df] user: dan branch: experimental-costs, size: 2351
2013-06-12
17:08
"make test" now passing. file: [ef85ac8f] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 2348
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [08b4ea1c] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 2383
2012-09-15
18:45
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. file: [93dce7b6] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 2525
2011-08-26
13:52
Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. file: [279856a6] check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 2380
2011-08-13
19:35
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. file: [f53095ce] check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 2501
2011-04-15
15:18
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. file: [87ecfbb6] check-in: [8d924e16] user: drh branch: branch-3.7.2, size: 2304 Added
14:46
Do not do full table scans of unordered indices. file: [e81169ce] check-in: [a8761a91] user: drh branch: trunk, size: 2425
2011-04-09
19:17
Add test file unordered.test. file: [c479d302] check-in: [f346dae1] user: dan branch: trunk, size: 2280 Added