Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/eqp.test
autosetup
August 15, 2024
D
If a subquery is materialized due to an ORDER BY and that ordering is useful
drh committed
235b5d0
July 3, 2024
D
Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output.
drh committed
5b070cf
March 20, 2024
D
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".
dan committed
e555bd4
December 8, 2022
D
Improved comments on the new co-routine logic. Fix a C++-ism in the code.
drh committed
a60d61b
April 22, 2022
D
Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by
drh committed
da653b8
March 20, 2021
D
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh committed
8210233
December 24, 2018
D
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows
drh committed
bd462bc
D
Do not generate subroutines for non-static SELECT and EXISTS expressions.
drh committed
5198ff5
August 16, 2018
D
Fix EXPLAIN QUERY PLAN so that it describes IN operators implemented using
drh committed
d885209
May 4, 2018
D
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines
drh committed
5d72d92
May 3, 2018
D
Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using
drh committed
fa16f5d
May 2, 2018
D
Fix a dangling-else problem that was causing recursive CTEs to malfunction.
drh committed
03c3905
September 4, 2017
D
Proposed fix for ticket [b899b6042f97f5]
drh committed
7e6f980
June 22, 2017
D
When generating individual loops for each ORed term of an OR scan, move any
dan committed
c456a76
March 14, 2016
D
Many test cases fixed to work with encryption.
drh committed
af3906a
May 23, 2014
D
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.
dan committed
e96f2df
April 30, 2014
D
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.
dan committed
75525cb
October 4, 2013
D
Fix test cases so that they work when the query planner uses index size
drh committed
165674d
D
Progress toward using the iScanRatio information on indices. Many tests
drh committed
d9e3cad
August 2, 2013
D
Updates to requirements marks. No code changes.
drh committed
3975974
June 12, 2013
D
"make test" now passing.
drh committed
4fe425a
June 11, 2013
D
Handle virtual tables correctly when using logarithmic costs. Fixes
drh committed
8636e9c
June 10, 2013
D
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the
drh committed
5822d6f
September 17, 2012
D
Add the ability to disable the covering-index-scan optimization at compile-time,
drh committed
de9a7b8
September 15, 2012
D
Attempt to use a covering index even on a full table scan, under the theory
drh committed
3f4d1d1
February 13, 2012
D
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.
dan committed
2f56da3
February 21, 2011
D
Fix a problem with "EXPLAIN QUERY PLAN SELECT count(*) FROM tbl".
dan committed
ef7075d
January 28, 2011
D
Change the weighting of binary searches on tables to 1/10th the cost of a
drh committed
083310d
November 16, 2010
D
Use the estimated number of rows computed for subqueries in the cost
drh committed
95aa47b
November 15, 2010
D
Change the EQP output for the min/max optimization from "SCAN" to "SEARCH".
drh committed
04098e6
D
Change some test cases to account for the new EXPLAIN QUERY PLAN output.
dan committed
3985479
D
Test some example code from documentation page eqp.html.
dan committed
91da6b8
November 13, 2010
D
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.
dan committed
4bc39fa
November 12, 2010
D
Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work.
dan committed
fa00aa2
November 11, 2010
D
Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations.
dan committed
30969d3
D
Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query.
dan committed
7f61e92
D
Modifications to test cases to account for new EXPLAIN QUERY PLAN output.
dan committed
47eb16d
November 9, 2010
D
Further enhancements and fixes for explain query plan.
dan committed
4a07e3d
November 8, 2010
D
Experimental changes to EXPLAIN QUERY PLAN.
dan committed
2ce2245