/ File History
Login

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

History of test/cost.test

2018-12-24
20:21
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. file: [51f4fcaa] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 7025
2018-05-04
00:39
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. file: [b37db8a1] check-in: [75ac7b4e] user: drh branch: trunk, size: 6892
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: [dadd9905] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 6811
2016-02-05
16:46
From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. file: [1eedbfd8] check-in: [a6b35273] user: drh branch: trunk, size: 6953
2014-06-03
11:32
Add a test to double-check that [1cbe7a0883] did not affect anything. file: [19d31452] check-in: [c6b512a7] user: dan branch: trunk, size: 6956
2014-04-30
18:11
Fix a problem in calculating the costs of "OR" scans. file: [04842ade] check-in: [9bbca48b] user: dan branch: trunk, size: 6011
14:53
Update a couple of test cases to account for the fact that this branch prefers an index scan and partial sort over a full-table scan and full external sort. file: [3f7904d6] check-in: [9b975bf3] user: dan branch: experimental-costs, size: 5922
2014-04-29
19:01
Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. file: [41b350fc] check-in: [e2d42f90] user: dan branch: experimental-costs, size: 5826
16:10
Ignore likelihood() values on indexed IPK lookups. file: [62386cca] check-in: [5bb7757a] user: dan branch: experimental-costs, size: 4884
2014-04-28
20:11
Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. file: [84473f27] check-in: [a8ae93f0] user: dan branch: experimental-costs, size: 4389
08:49
Fix an error in estimating of the number of rows visited by a range scan. file: [39d014a9] check-in: [d491de62] user: dan branch: experimental-costs, size: 2350
2014-04-26
20:21
Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. file: [8a2b846e] check-in: [dee20409] user: dan branch: experimental-costs, size: 1634 Added