/ 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/eqp.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: [84879b63] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 21516
12:09
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. file: [5e8b1b2d] check-in: [06de44ec] user: drh branch: reuse-subqueries, size: 21398
2018-08-16
15:29
Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. file: [fc00ad1a] check-in: [60045fbf] user: drh branch: trunk, size: 21384
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: [4fd69d25] check-in: [75ac7b4e] user: drh branch: trunk, size: 19123
2018-05-03
01:37
Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. file: [2ac18a1d] check-in: [c75eee69] user: drh branch: rework-EQP, size: 19071
2018-05-02
14:24
Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. file: [0d06518e] check-in: [82ca44b8] user: drh branch: rework-EQP, size: 18885
2017-06-22
16:51
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. file: [3f9ba0b2] check-in: [e4a022be] user: dan branch: or-optimization, size: 18285
2016-03-14
17:05
Many test cases fixed to work with encryption. file: [3fe051af] check-in: [d866fffb] user: drh branch: see-testing, size: 18285
2015-06-10
17:20
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. file: [bd139cee] check-in: [a1eaf171] user: drh branch: view-optimization, size: 18182
2014-05-23
17:17
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. file: [85873fa5] check-in: [9268df30] user: dan branch: trunk, size: 18182
2014-04-30
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: [90b56d03] check-in: [9b975bf3] user: dan branch: experimental-costs, size: 17284
2013-10-04
15:58
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. file: [57c6c604] check-in: [2f394de8] user: drh branch: index-scan-rate, size: 17191
02:36
Progress toward using the iScanRatio information on indices. Many tests are still failing. file: [d4386348] check-in: [6c352edb] user: drh branch: index-scan-rate, size: 17143
2013-08-02
23:40
Updates to requirements marks. No code changes. file: [d9e7ad4e] check-in: [21302076] user: drh branch: trunk, size: 16984
2013-06-12
17:08
"make test" now passing. file: [8ef4d89d] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 16952
2013-06-11
01:50
Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. file: [68dd66c8] check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 16952
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: [ac506be9] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 16976
2012-09-17
20:44
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. file: [46aa946d] check-in: [ccb8ecc3] user: drh branch: fullscan-covering-index, size: 18859
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: [103243f8] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 18859
2012-02-13
10:00
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [6a389bba] check-in: [76bb649e] user: dan branch: trunk, size: 18661
2011-02-21
17:49
Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl". file: [f14fadd7] check-in: [9f9f3288] user: dan branch: trunk, size: 18613
2011-01-28
01:57
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. file: [8f535d90] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 17596
2010-11-16
02:49
Use the estimated number of rows computed for subqueries in the cost computations for outer queries. file: [69670e79] check-in: [56bbc539] user: drh branch: trunk, size: 17596
2010-11-15
21:50
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. file: [7cc9b11f] check-in: [d52b5939] user: drh branch: trunk, size: 16447
16:12
Change some test cases to account for the new EXPLAIN QUERY PLAN output. file: [0a76679d] check-in: [88a854e1] user: dan branch: trunk, size: 16444
14:51
Test some example code from documentation page eqp.html. file: [32567e06] check-in: [547bc2c2] user: dan branch: trunk, size: 16557
2010-11-13
16:42
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. file: [8f8e8ca5] check-in: [6611b76b] user: dan branch: experimental, size: 15482
2010-11-12
17:41
Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. file: [4ca41a9f] check-in: [85fdad85] user: dan branch: experimental, size: 15317
2010-11-11
17:48
Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. file: [13c875a9] check-in: [28643b85] user: dan branch: experimental, size: 9761
16:46
Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. file: [d4a411b2] check-in: [00fb8468] user: dan branch: experimental, size: 9775
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [b5737656] check-in: [30904ef8] user: dan branch: experimental, size: 8512
2010-11-09
14:49
Further enhancements and fixes for explain query plan. file: [a63c03a3] check-in: [73c93f5a] user: dan branch: experimental, size: 7907
2010-11-08
19:01
Experimental changes to EXPLAIN QUERY PLAN. file: [d8ad22f6] check-in: [f4747eb8] user: dan branch: experimental, size: 5217 Added