Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/eqp.test
2025-07-02
| ||
20:46 | [800fb69fae] part of check-in [1c1aef2b7f] Merge in the exists-to-join optimization that has been modified to relax the requirement of having an indexed join constraint. (check-in: [1c1aef2b7f] user: drh branch: empty-table-optimizations, size: 22480) | |
2024-08-15
| ||
23:38 | [82f221e8cd] part of check-in [2fbb4dc232] If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort. (check-in: [2fbb4dc232] user: drh branch: order-by-subquery, size: 22517) | |
2024-07-03
| ||
20:30 | [9219ca234b] part of check-in [0bb306eb70] When constructing an ephermeral table to use as the right-hand side of an IN operator, also construct a Bloom filter to speed membership testing. (check-in: [0bb306eb70] user: dan branch: bedrock-3.45-in-bloom, size: 20977) | |
20:10 | [815418b69f] part of check-in [c10a1b99d4] Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output. (check-in: [c10a1b99d4] user: drh branch: in-bloom, size: 20983) | |
2024-03-20
| ||
16:27 | [3302598f61] part of check-in [cd547c5004] Change EXPLAIN QUERY PLAN output to say "USE TEMP B-TREE FOR LAST TERM OF ORDER BY", or "LAST N TERMS OF ORDER BY", instead of "RIGHT PART OF ORDER BY". (check-in: [cd547c5004] user: dan branch: eqp-orderby, size: 20955) | |
2022-12-08
| ||
16:47 | [f3f7548d2f] part of check-in [9243e850ae] Improved comments on the new co-routine logic. Fix a C++-ism in the code. Update test cases to accommodate the more aggressive use of co-routines. (check-in: [9243e850ae] user: drh branch: coroutines-exp2, size: 20949) | |
2022-04-22
| ||
17:36 | [473aea9599] part of check-in [a2d3ee9242] Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by distinguishing between "subquery" and "join" and using consistent names across EQP and bytecode. (check-in: [a2d3ee9242] user: drh branch: trunk, size: 20958) | |
2021-03-20
| ||
15:11 | [bfe979eb1f] 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: 20946) | |
2018-12-24
| ||
20:21 | [84879b63e3] part of check-in [7153552bac] 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: [7153552bac] user: drh branch: reuse-subqueries, size: 21516) | |
12:09 | [5e8b1b2d8c] part of check-in [06de44ec9e] 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: [06de44ec9e] user: drh branch: reuse-subqueries, size: 21398) | |
2018-08-16
| ||
15:29 | [fc00ad1a7f] part of check-in [60045fbf52] Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using a ROWID lookup. (check-in: [60045fbf52] user: drh branch: trunk, size: 21384) | |
2018-05-04
| ||
00:39 | [4fd69d25f2] part of check-in [75ac7b4e4f] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e4f] user: drh branch: trunk, size: 19123) | |
2018-05-03
| ||
01:37 | [2ac18a1d6a] part of check-in [c75eee69fa] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69fa] user: drh branch: rework-EQP, size: 19071) | |
2018-05-02
| ||
14:24 | [0d06518e01] part of check-in [82ca44b82f] 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: [82ca44b82f] user: drh branch: rework-EQP, size: 18885) | |
2017-06-22
| ||
16:51 | [3f9ba0b259] part of check-in [e4a022be4b] 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: [e4a022be4b] user: dan branch: or-optimization, size: 18285) | |
2016-03-14
| ||
17:05 | [3fe051af50] part of check-in [d866fffb8b] Many test cases fixed to work with encryption. (check-in: [d866fffb8b] user: drh branch: see-testing, size: 18285) | |
2015-06-10
| ||
17:20 | [bd139ceea2] part of check-in [a1eaf1718e] 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: [a1eaf1718e] user: drh branch: view-optimization, size: 18182) | |
2014-05-23
| ||
17:17 | [85873fa581] part of check-in [9268df305b] 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: [9268df305b] user: dan branch: trunk, size: 18182) | |
2014-04-30
| ||
14:53 | [90b56d03a9] part of check-in [9b975bf33c] 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: [9b975bf33c] user: dan branch: experimental-costs, size: 17284) | |
2013-10-04
| ||
15:58 | [57c6c604c2] part of check-in [2f394de88f] 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: [2f394de88f] user: drh branch: index-scan-rate, size: 17191) | |
02:36 | [d4386348af] part of check-in [6c352edbba] Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: [6c352edbba] user: drh branch: index-scan-rate, size: 17143) | |
2013-08-02
| ||
23:40 | [d9e7ad4e7b] part of check-in [213020769f] Updates to requirements marks. No code changes. (check-in: [213020769f] user: drh branch: trunk, size: 16984) | |
2013-06-12
| ||
17:08 | [8ef4d89dc4] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 16952) | |
2013-06-11
| ||
01:50 | [68dd66c8fa] part of check-in [e612664aa2] Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. (check-in: [e612664aa2] user: drh branch: nextgen-query-plan-logcost, size: 16952) | |
2013-06-10
| ||
23:30 | [ac506be979] 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: 16976) | |
2012-09-17
| ||
20:44 | [46aa946dd5] part of check-in [ccb8ecc30c] 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: [ccb8ecc30c] user: drh branch: fullscan-covering-index, size: 18859) | |
2012-09-15
| ||
18:45 | [103243f86c] 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: 18859) | |
2012-02-13
| ||
10:00 | [6a389bba6e] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 18661) | |
2011-02-21
| ||
17:49 | [f14fadd76d] part of check-in [9f9f328825] Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl". (check-in: [9f9f328825] user: dan branch: trunk, size: 18613) | |
2011-01-28
| ||
01:57 | [8f535d902b] part of check-in [4847c6cb71] 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: [4847c6cb71] user: drh branch: stat2-enhancement, size: 17596) | |
2010-11-16
| ||
02:49 | [69670e7919] part of check-in [56bbc53924] Use the estimated number of rows computed for subqueries in the cost computations for outer queries. (check-in: [56bbc53924] user: drh branch: trunk, size: 17596) | |
2010-11-15
| ||
21:50 | [7cc9b11f92] part of check-in [d52b593978] 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: [d52b593978] user: drh branch: trunk, size: 16447) | |
16:12 | [0a76679df5] part of check-in [88a854e18f] Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: [88a854e18f] user: dan branch: trunk, size: 16444) | |
14:51 | [32567e06a0] part of check-in [547bc2c232] Test some example code from documentation page eqp.html. (check-in: [547bc2c232] user: dan branch: trunk, size: 16557) | |
2010-11-13
| ||
16:42 | [8f8e8ca502] part of check-in [6611b76b02] 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: [6611b76b02] user: dan branch: experimental, size: 15482) | |
2010-11-12
| ||
17:41 | [4ca41a9fc3] part of check-in [85fdad850a] Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. (check-in: [85fdad850a] user: dan branch: experimental, size: 15317) | |
2010-11-11
| ||
17:48 | [13c875a9a6] part of check-in [28643b85d9] Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: [28643b85d9] user: dan branch: experimental, size: 9761) | |
16:46 | [d4a411b212] part of check-in [00fb8468b5] Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: [00fb8468b5] user: dan branch: experimental, size: 9775) | |
10:36 | [b573765656] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 8512) | |
2010-11-09
| ||
14:49 | [a63c03a35c] part of check-in [73c93f5a2a] Further enhancements and fixes for explain query plan. (check-in: [73c93f5a2a] user: dan branch: experimental, size: 7907) | |
2010-11-08
| ||
19:01 | Added: [d8ad22f65a] part of check-in [f4747eb83d] Experimental changes to EXPLAIN QUERY PLAN. (check-in: [f4747eb83d] user: dan branch: experimental, size: 5217) | |