/ History for test/eqp.test
Login

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

History for test/eqp.test

2018-12-24
20:21
[84879b63] 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: 21516)
12:09
[5e8b1b2d] part of check-in [06de44ec] Do not generate subroutines for non-static SELECT and EXISTS expressions. Fix up some test cases to account for the minor changes in EXPLAIN QUERY PLAN output. (check-in: [06de44ec] user: drh branch: reuse-subqueries, size: 21398)
2018-08-16
15:29
[fc00ad1a] part of check-in [60045fbf] Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. (check-in: [60045fbf] user: drh branch: trunk, size: 21384)
2018-05-04
00:39
[4fd69d25] 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: 19123)
2018-05-03
01:37
[2ac18a1d] part of check-in [c75eee69] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69] user: drh branch: rework-EQP, size: 19071)
2018-05-02
14:24
[0d06518e] part of check-in [82ca44b8] Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. (check-in: [82ca44b8] user: drh branch: rework-EQP, size: 18885)
2017-06-22
16:51
[3f9ba0b2] part of check-in [e4a022be] When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (check-in: [e4a022be] user: dan branch: or-optimization, size: 18285)
2016-03-14
17:05
[3fe051af] part of check-in [d866fffb] Many test cases fixed to work with encryption. (check-in: [d866fffb] user: drh branch: see-testing, size: 18285)
2015-06-10
17:20
[bd139cee] part of check-in [a1eaf171] Resolve FROM-clause subqueries after query planning instead of before. Greatly reduce the estimated cost of automatic indexes for VIEWs and ephemeral tables since performance problems there cannot be mitigated via a CREATE INDEX. (check-in: [a1eaf171] user: drh branch: view-optimization, size: 18182)
2014-05-23
17:17
[85873fa5] part of check-in [9268df30] Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table. (check-in: [9268df30] user: dan branch: trunk, size: 18182)
2014-04-30
14:53
[90b56d03] 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: 17284)
2013-10-04
15:58
[57c6c604] part of check-in [2f394de8] Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. (check-in: [2f394de8] user: drh branch: index-scan-rate, size: 17191)
02:36
[d4386348] part of check-in [6c352edb] Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: [6c352edb] user: drh branch: index-scan-rate, size: 17143)
2013-08-02
23:40
[d9e7ad4e] part of check-in [21302076] Updates to requirements marks. No code changes. (check-in: [21302076] user: drh branch: trunk, size: 16984)
2013-06-12
17:08
[8ef4d89d] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 16952)
2013-06-11
01:50
[68dd66c8] part of check-in [e612664a] Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. (check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 16952)
2013-06-10
23:30
[ac506be9] 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: 16976)
2012-09-17
20:44
[46aa946d] part of check-in [ccb8ecc3] Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. (check-in: [ccb8ecc3] user: drh branch: fullscan-covering-index, size: 18859)
2012-09-15
18:45
[103243f8] 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: 18859)
2012-02-13
10:00
[6a389bba] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 18661)
2011-02-21
17:49
[f14fadd7] part of check-in [9f9f3288] Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl". (check-in: [9f9f3288] user: dan branch: trunk, size: 18613)
2011-01-28
01:57
[8f535d90] part of check-in [4847c6cb] Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 17596)
2010-11-16
02:49
[69670e79] part of check-in [56bbc539] Use the estimated number of rows computed for subqueries in the cost computations for outer queries. (check-in: [56bbc539] user: drh branch: trunk, size: 17596)
2010-11-15
21:50
[7cc9b11f] part of check-in [d52b5939] Change the EQP output for the min/max optimization from "SCAN" to "SEARCH". Other changes in where.c in support of full branch coverage testing. (check-in: [d52b5939] user: drh branch: trunk, size: 16447)
16:12
[0a76679d] part of check-in [88a854e1] Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: [88a854e1] user: dan branch: trunk, size: 16444)
14:51
[32567e06] part of check-in [547bc2c2] Test some example code from documentation page eqp.html. (check-in: [547bc2c2] user: dan branch: trunk, size: 16557)
2010-11-13
16:42
[8f8e8ca5] part of check-in [6611b76b] Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (check-in: [6611b76b] user: dan branch: experimental, size: 15482)
2010-11-12
17:41
[4ca41a9f] part of check-in [85fdad85] Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. (check-in: [85fdad85] user: dan branch: experimental, size: 15317)
2010-11-11
17:48
[13c875a9] part of check-in [28643b85] Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: [28643b85] user: dan branch: experimental, size: 9761)
16:46
[d4a411b2] part of check-in [00fb8468] Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: [00fb8468] user: dan branch: experimental, size: 9775)
10:36
[b5737656] part of check-in [30904ef8] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef8] user: dan branch: experimental, size: 8512)
2010-11-09
14:49
[a63c03a3] part of check-in [73c93f5a] Further enhancements and fixes for explain query plan. (check-in: [73c93f5a] user: dan branch: experimental, size: 7907)
2010-11-08
19:01
[d8ad22f6] part of check-in [f4747eb8] Experimental changes to EXPLAIN QUERY PLAN. (check-in: [f4747eb8] user: dan branch: experimental, size: 5217) Added