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

COMMITS

/ test/join5.test
autosetup
March 19, 2024
D
Update test scripts to account for [8fcea4cd].
dan committed
ffbe492
D
Update tests to work with SQLITE_ALLOW_ROWID_IN_VIEW.
dan committed
f891ef8
May 31, 2023
D
Improved detection of when the LEFT JOIN strength reduction optimization
drh committed
29e70da
February 5, 2023
D
Do not use a Bloom filter if any outer loop lacks STAT1 data, since without
drh committed
072f48e
May 3, 2022
D
Fix the Bloom filter pull-down optimization so that it jumps to the correct
drh committed
8aa7f4d
April 11, 2022
D
Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.
drh committed
c583719
March 25, 2022
D
Fix the Bloom-filter optimization so that it does not use IS NULL or
drh committed
be34150
March 2, 2022
D
Bloom filter pull-down optimization is incompatible with Skip-Scan.
drh committed
5694569
January 31, 2022
D
Do not attempt to limit the number of columns used in a table to a prefix
drh committed
87fb37e
December 9, 2021
D
Enable bloom filters for the right table of a LEFT JOIN. Fix unreachable
drh committed
a11c5e2
March 20, 2021
D
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
drh committed
8210233
May 18, 2019
D
Fix an assert() failure that could occur in a join query if the RHS of an IN() operator is a list containing correlated expressions. This problem was introduced by checkin [e130319317e7611938] which was part of the fix for ticket [787fa716be3a7f650c] - so this commit is part of that ticket's fix too.
dan committed
7ac0e56
February 8, 2019
D
Do not do the optimization that attempts to pull expression values from
drh committed
8851e10
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
April 24, 2018
D
Fix a problem with processing "LEFT JOIN tbl ON tbl.a = ? AND (tbl.b=? OR
dan committed
820fcd2
D
Do not attempt to read values from indexes-on-expressions if the index is on
dan committed
4da04f7
March 20, 2018
D
Fix incorrect testcase labels on two cases in join5.test. No changes to code.
drh committed
f6e6f02
December 1, 2016
D
Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening
dan committed
92ddb3b
August 22, 2015
D
Do not apply the WHERE-clause pushdown optimization to terms that originate
drh committed
38978dd
December 4, 2014
D
If a table is the right operand of a LEFT JOIN, then any column of that
drh committed
72673a2
June 8, 2007
D
Fix the query optimizer so that it correctly handles constant expressions
drh committed
0a16837
September 19, 2005
D
ON-clause terms in a LEFT JOIN that restrict only the left table, should not
drh committed
22d6a53