|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1, version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3 |
|
| #
8210233c |
| 20-Mar-2021 |
drh <> |
Revise tests cases to align with the new EXPLAIN QUERY PLAN output.
FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c
|
|
Revision tags: version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0, version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0, version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2 |
|
| #
cdf88760 |
| 02-May-2018 |
drh <[email protected]> |
More test case updates. Tests are all running now.
FossilOrigin-Name: dab5e5294813891469660cceb211ac1a1e526715bb57dcdbb1ab90321e6a4dad
|
|
Revision tags: version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0, version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0 |
|
| #
c4974414 |
| 17-Jun-2016 |
dan <[email protected]> |
Fix a duplicate test name in cursorhint2.test.
FossilOrigin-Name: fcd12b69cee1335224a65aa6d22c4e302b889398
|
|
Revision tags: version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10, version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5 |
|
| #
aa9933c1 |
| 24-Apr-2014 |
dan <[email protected]> |
Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing.
FossilOrigin-Name: c5a6ec0a880652dc8f4593d9f7acd58ddc3dc5f3
|
|
Revision tags: version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4, version-3.8.3.1, version-3.8.3, version-3.8.2, version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0 |
|
| #
d0aa2f3a |
| 20-Aug-2013 |
drh <[email protected]> |
Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns.
FossilOrigin-Name: e476408e3c5ba5f3ba5e98ff264167c163d72e3f
|
| #
9d5a579c |
| 28-Jun-2013 |
drh <[email protected]> |
Fix an issue with the OmitNoopJoin optimization and add test cases that
are specifically for that optimization.
FossilOrigin-Name: 5480d124b74c9adaacc4fa9cb81560865b44f3e1
|
| #
4fe425ad |
| 12-Jun-2013 |
drh <[email protected]> |
"make test" now passing.
FossilOrigin-Name: addd7f466d6ff55f82d907286650c26b06e9397b
|
| #
8a4380d7 |
| 11-Jun-2013 |
drh <[email protected]> |
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer
to what they are in legacy. More test case fixes.
FossilOrigin-Name: 36373b85f9a97840aa06e24ae31c12fcfbae084e
|
| #
5822d6fe |
| 10-Jun-2013 |
drh <[email protected]> |
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the
wherecosttest tool. Other fixes to logarithm cost.
FossilOrigin-Name: aa580e368e3c398b8377b80342dfdd906324c248
|
| #
e353ee38 |
| 04-Jun-2013 |
drh <[email protected]> |
Update some variable names and comments in the ORDER BY optimizer. Fix a
bug in the ORDER BY optimizer dealing with IS NULL constraints. Updates
to test cases.
FossilOrigin-Name: cf96eb5945a9bab71
Update some variable names and comments in the ORDER BY optimizer. Fix a
bug in the ORDER BY optimizer dealing with IS NULL constraints. Updates
to test cases.
FossilOrigin-Name: cf96eb5945a9bab71104cb1581ee13ab30022566
show more ...
|
| #
7c171098 |
| 03-Jun-2013 |
drh <[email protected]> |
Remove more vestiges of sqlite_query_plan from the test cases.
FossilOrigin-Name: eb27086e8a8a4d5fcb2ea358256a555e34339423
|
|
Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10, version-3.7.9 |
|
| #
e802c5da |
| 18-Oct-2011 |
drh <[email protected]> |
Improved handling of USING and NATURAL JOIN in 3-way and higher joins.
Ticket [3338b3fa19ac4ab]
FossilOrigin-Name: 551ce407bd77149865423511bd52eba2f404161a
|
|
Revision tags: version-3.7.8, version-3.7.7.1, version-3.7.7, version-3.7.6.3, version-3.7.6.2, version-3.7.6.1, version-3.7.6 |
|
| #
f6cf1ffb |
| 30-Mar-2011 |
drh <[email protected]> |
Do not generate sqlite_stat1 entries for empty tables when running
ANALYZE. Ticket [83ea97620bd31016451]
FossilOrigin-Name: 3a27af5b3c688c651ba1fae261026ef77b7ff5e3
|
|
Revision tags: version-3.7.5 |
|
| #
083310df |
| 28-Jan-2011 |
drh <[email protected]> |
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 no
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.
FossilOrigin-Name: 4847c6cb71423248b186ab7842b97c83e2f5fefd
show more ...
|
|
Revision tags: version-3.7.4 |
|
| #
4bc39fa1 |
| 13-Nov-2010 |
dan <[email protected]> |
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.
FossilOrigin-Name: 6611b76b0296875fb99
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.
FossilOrigin-Name: 6611b76b0296875fb9903b25dfaa783a9c12eaa1
show more ...
|
| #
47eb16d4 |
| 11-Nov-2010 |
dan <[email protected]> |
Modifications to test cases to account for new EXPLAIN QUERY PLAN output.
FossilOrigin-Name: 30904ef8412348464e893e9e1551ef22cad24a3e
|
| #
547caad4 |
| 04-Oct-2010 |
drh <[email protected]> |
Fix a performance regression (relative to version 3.6.23.1) caused by the
query planner taking into account non-indexable WHERE clause terms to select
the outermost join loops when it should be selec
Fix a performance regression (relative to version 3.6.23.1) caused by the
query planner taking into account non-indexable WHERE clause terms to select
the outermost join loops when it should be selecting tables for the outermost
loop that do not benefit from being in an inner loop.
FossilOrigin-Name: ece641eb8951c6314cedbdb3243f91cb199c3239
show more ...
|
|
Revision tags: experimental, version-3.7.2 |
|
| #
aa0ba434 |
| 05-Aug-2010 |
drh <[email protected]> |
Fix the query planner so that when it has a choice of full-scan tables to
move to the outer loop, it chooses the one that is likely to give the fewest
output rows.
FossilOrigin-Name: 309bbedf9648c75
Fix the query planner so that when it has a choice of full-scan tables to
move to the outer loop, it chooses the one that is likely to give the fewest
output rows.
FossilOrigin-Name: 309bbedf9648c750d7b8aedbc15d4fd68f846824
show more ...
|
| #
5e377d90 |
| 04-Aug-2010 |
drh <[email protected]> |
If the outer loop of a join must be a full table scan, make sure that an
incomplete ANALYZE does not trick the planner into use a table that might
be indexable in an inner loop. Ticket [13f033c865f8
If the outer loop of a join must be a full table scan, make sure that an
incomplete ANALYZE does not trick the planner into use a table that might
be indexable in an inner loop. Ticket [13f033c865f878]
FossilOrigin-Name: e7a714b52c45af096af74049826d32c647abfe3f
show more ...
|
| #
ed754ce2 |
| 15-Apr-2010 |
drh <[email protected]> |
Further refinements to table order selection on join query planning.
FossilOrigin-Name: defaf0d99a807027f8883bf821b6482025f9f54e
|
|
Revision tags: fts3-refactor, cvs-to-fossil-cutover, version-3.6.15, version-3.6.10 |
|
| #
dafc0ce8 |
| 17-Apr-2008 |
drh <[email protected]> |
Additional work on ticket #3015. The previous fix (check-in (4919)) did
not appear to work in all cases and it disabled indexing in some places
where it should not have. New test cases added to hel
Additional work on ticket #3015. The previous fix (check-in (4919)) did
not appear to work in all cases and it disabled indexing in some places
where it should not have. New test cases added to help insure that the
current fix is better. (CVS 5026)
FossilOrigin-Name: 0d2e258e1a3276e55903ba2ded987f8d8a18cacd
show more ...
|
| #
61dfc31d |
| 16-Dec-2006 |
drh <[email protected]> |
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table
to be reordered with A and B. This used to be the case but the capability
was removed by (3203) and (3052) in response to t
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table
to be reordered with A and B. This used to be the case but the capability
was removed by (3203) and (3052) in response to ticket #1652. This change
restores the capability. (CVS 3529)
FossilOrigin-Name: 7393c81b8cb9d4344ae744de9eabcb3af64f1db8
show more ...
|
| #
df26fd5e |
| 06-Jun-2006 |
drh <[email protected]> |
In joins of the form "A left B, C" make sure they are not transformed into
"A left C, B". Ticket #1830. See also #1652. (CVS 3203)
FossilOrigin-Name: 2baa983653796e16d36739e37b0be1672bf59a92
|
| #
570b935c |
| 01-Feb-2006 |
drh <[email protected]> |
In joins of the form: "A, B left C" make sure that the reordering optimization
does not put table A after table C. Ticket #1652. (CVS 3052)
FossilOrigin-Name: 248b9be93d9532e31c640432b75c3310e180ac
In joins of the form: "A, B left C" make sure that the reordering optimization
does not put table A after table C. Ticket #1652. (CVS 3052)
FossilOrigin-Name: 248b9be93d9532e31c640432b75c3310e180acb3
show more ...
|