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

COMMITS

/ test/where9.test
autosetup
April 11, 2022
D
Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.
drh committed
c583719
May 18, 2021
D
In the MULTI-INDEX OR query plan, code for sub-expressions can sometimes be
drh committed
93ffb50
March 20, 2021
D
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh committed
8210233
June 3, 2020
D
Improve the query planner so that it is better able to find full
drh committed
094afff
August 8, 2019
D
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
drh committed
175b8f0
December 24, 2018
D
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows
drh committed
bd462bc
May 4, 2018
D
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines
drh committed
5d72d92
May 2, 2018
D
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output
drh committed
b3f0276
August 12, 2014
D
Fix where9.test so that it works with the "no_optimization" permutation.
dan committed
299b246
August 28, 2013
D
In the query optimizer, when converting BETWEEN and LIKE/GLOB expressions
drh committed
d41d39f
August 12, 2013
D
If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4.
dan committed
8ad169a
August 3, 2013
D
Begin adding experimental sqlite_stat4 table. This commit is buggy.
dan committed
f52bb8d
June 19, 2013
D
Add in the cost of doing a table lookup on OR searches. Make test case
drh committed
74f91d4
June 12, 2013
D
Add the "queryplanner" test permutation. Continuing refinements to NGQP.
drh committed
fd5874d
June 10, 2013
D
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the
drh committed
5822d6f
May 9, 2013
D
Do not move WHERE clause terms inside OR expressions that are contained
drh committed
b3129fa
December 18, 2012
D
Optimize the degenerate case of a FROM clause table name enclosed all by
drh committed
832ee3d
September 15, 2012
D
Attempt to use a covering index even on a full table scan, under the theory
drh committed
3f4d1d1
March 9, 2012
D
Candidate fix for the optimizer problem described in ticket
drh committed
331b67c
February 13, 2012
D
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.
dan committed
2f56da3
October 7, 2011
D
More test cases for the OR optimization.
drh committed
85ae206
January 28, 2011
D
Change the weighting of binary searches on tables to 1/10th the cost of a
drh committed
083310d
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 11, 2010
D
Fix a bug in the EXPLAIN QUERY PLAN code.
dan committed
acf1987
D
Modifications to test cases to account for new EXPLAIN QUERY PLAN output.
dan committed
47eb16d
June 5, 2009
D
Remove leftover "breakpoint" commands from test scripts. Also remove blank
drh committed
dda70fe
April 21, 2009
D
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)
danielk1977 committed
1d46146
February 24, 2009
D
Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316)
danielk1977 committed
a553316
February 23, 2009
D
Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315)
danielk1977 committed
e2d7b24
January 8, 2009
D
Increased test coverage in where.c. (CVS 6146)
drh committed
103bd88
D
Increase test coverage of where.c. Make sure OR-optimization works on
drh committed
171256c
December 30, 2008
D
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"
drh committed
04bbcd5
D
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)
drh committed
eb9441e
D
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization.
drh committed
46129af