/ History for test/cost.test
Login

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

History for test/cost.test

2020-05-28
00:45
[1d156ce9] part of check-in [98d42620] When the sqlite_stat1 data is missing for some indexes of a table but is present for the table itself or for other indexes in the same table, then do not let the estimated number of rows in that table get too small, as doing so can deceive the query planner into ignoring a perfectly good index. (check-in: [98d42620] user: drh branch: trunk, size: 7025)
2018-12-24
20:21
[51f4fcaa] part of check-in [7153552b] 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. (check-in: [7153552b] user: drh branch: reuse-subqueries, size: 7025)
2018-05-04
00:39
[b37db8a1] part of check-in [75ac7b4e] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e] user: drh branch: trunk, size: 6892)
2018-05-02
18:00
[dadd9905] 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: 6811)
2016-02-05
16:46
[1eedbfd8] part of check-in [a6b35273] From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (check-in: [a6b35273] user: drh branch: trunk, size: 6953)
2014-06-03
11:32
[19d31452] part of check-in [c6b512a7] Add a test to double-check that [1cbe7a0883] did not affect anything. (check-in: [c6b512a7] user: dan branch: trunk, size: 6956)
2014-04-30
18:11
[04842ade] part of check-in [9bbca48b] Fix a problem in calculating the costs of "OR" scans. (check-in: [9bbca48b] user: dan branch: trunk, size: 6011)
14:53
[3f7904d6] part of check-in [9b975bf3] 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. (check-in: [9b975bf3] user: dan branch: experimental-costs, size: 5922)
2014-04-29
19:01
[41b350fc] part of check-in [e2d42f90] Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. (check-in: [e2d42f90] user: dan branch: experimental-costs, size: 5826)
16:10
[62386cca] part of check-in [5bb7757a] Ignore likelihood() values on indexed IPK lookups. (check-in: [5bb7757a] user: dan branch: experimental-costs, size: 4884)
2014-04-28
20:11
[84473f27] part of check-in [a8ae93f0] 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. (check-in: [a8ae93f0] user: dan branch: experimental-costs, size: 4389)
08:49
[39d014a9] part of check-in [d491de62] Fix an error in estimating of the number of rows visited by a range scan. (check-in: [d491de62] user: dan branch: experimental-costs, size: 2350)
2014-04-26
20:21
[8a2b846e] part of check-in [dee20409] Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. (check-in: [dee20409] user: dan branch: experimental-costs, size: 1634) Added