SQLite

All files named ”test/unordered.test”
Login

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

History for test/unordered.test

2021-03-20
15:11
[0edaf3411d] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 2121)
2018-05-02
18:00
[ffeea7747d] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 2205)
2014-04-28
15:11
[ca7adce041] part of check-in [20f468dfbc] 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: [20f468dfbc] user: dan branch: experimental-costs, size: 2351)
2013-06-12
17:08
[ef85ac8f2f] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 2348)
2013-06-10
23:30
[08b4ea1c27] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 2383)
2012-09-15
18:45
[93dce7b6c9] part of check-in [cfaa7bc128] 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: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 2525)
2011-08-26
13:52
[279856a614] part of check-in [0df04f920b] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f920b] user: drh branch: stat3-3.7.2, size: 2380)
2011-08-13
19:35
[f53095cee3] part of check-in [89b2f70884] 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: [89b2f70884] user: drh branch: stat3-enhancement, size: 2501)
2011-04-15
15:18
Added: [87ecfbb688] part of check-in [8d924e1607] 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: [8d924e1607] user: drh branch: branch-3.7.2, size: 2304)
14:46
[e81169ce2a] part of check-in [a8761a9128] Do not do full table scans of unordered indices. (check-in: [a8761a9128] user: drh branch: trunk, size: 2425)
2011-04-09
19:17
Added: [c479d3027f] part of check-in [f346dae127] Add test file unordered.test. (check-in: [f346dae127] user: dan branch: trunk, size: 2280)