|
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 |
|
| #
a9cdb904 |
| 25-Apr-2022 |
drh <> |
Fix a problem with automatic indexes introduced by
check-in [664b461bb5063d980] and reported by
[forum:/forumpost/0d3200f4f3bcd3a3|forum post 0d3200f4f3bcd3a3].
FossilOrigin-Name: 7ca3456c00998a4294
Fix a problem with automatic indexes introduced by
check-in [664b461bb5063d980] and reported by
[forum:/forumpost/0d3200f4f3bcd3a3|forum post 0d3200f4f3bcd3a3].
FossilOrigin-Name: 7ca3456c00998a429418ff29cf251b381586b330b88344c94a40c5df0b71da85
show more ...
|
| #
c583719b |
| 11-Apr-2022 |
drh <> |
Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.
FossilOrigin-Name: d91faeffea5cf0585fb71e5311fdcc6b8be85c7e9c732050b4448e617c970101
|
|
Revision tags: 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 |
|
| #
bd462bcc |
| 24-Dec-2018 |
drh <[email protected]> |
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
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.
FossilOrigin-Name: 7153552bac51295c56a1c42ca79d57195851e232509f9e9610375692f48c7e86
show more ...
|
| #
5198ff57 |
| 24-Dec-2018 |
drh <[email protected]> |
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.
FossilOrigin-Name: 06de44ec9e173992ca9
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.
FossilOrigin-Name: 06de44ec9e173992ca9afb89dd2b4e40d2a7e35512c7959603cdceb606f5dfbd
show more ...
|
|
Revision tags: 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 |
|
| #
bbccd521 |
| 18-Jul-2017 |
dan <[email protected]> |
Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS
term. Fix for [ce68383b].
FossilOrigin-Name: d2f0b2e859a8a413ee4e4bd7040e450ccd604069e4ea8dbc9ff924718c2b14d7
|
|
Revision tags: 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, 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 |
|
| #
29031837 |
| 15-Apr-2015 |
drh <[email protected]> |
Remove an incorrect ALWAYS() from the automatic index generator.
FossilOrigin-Name: eeb4bd06bf69e411736cc6077d1d64af6bd8fb09
|
|
Revision tags: version-3.8.9 |
|
| #
9d356fbe |
| 27-Feb-2015 |
drh <[email protected]> |
New requirements marks and a few new test cases to go with them. No changes
to code.
FossilOrigin-Name: 8c2b29d9acb92d47f4deec21a7c2dca52db63345
|
|
Revision tags: 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 |
|
| #
7e07433f |
| 22-Sep-2014 |
drh <[email protected]> |
Tune the query planner to be more aggressive about using automatic indexes
on views and subqueries for which there is not opportunity to declare a
persistent schema index.
FossilOrigin-Name: 41de164
Tune the query planner to be more aggressive about using automatic indexes
on views and subqueries for which there is not opportunity to declare a
persistent schema index.
FossilOrigin-Name: 41de1643bfc9ae25e20790d707e2789b665baa2b
show more ...
|
|
Revision tags: 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 |
|
| #
c1f19f95 |
| 05-Jul-2013 |
dan <[email protected]> |
Fix two test script problems revealed by permutations.test.
FossilOrigin-Name: 60cf7e44871ca8d2136ddad02188f0b9f9c380c1
|
| #
8d56e205 |
| 28-Jun-2013 |
drh <[email protected]> |
Issue the new SQLITE_WARNING_AUTOINDEX warning on the SQLite log whenever
an automatic index is created.
FossilOrigin-Name: 338826ef3f8a209b14f8d42370855cab9ac9ed45
|
| #
986b3879 |
| 28-Jun-2013 |
drh <[email protected]> |
Add the SQLITE_DEFAULT_AUTOMATIC_INDEX compile-time option, which if set to
zero turns automatic indices off by default. Increase the estimated cost
of an automatic index. Additional minor refactor
Add the SQLITE_DEFAULT_AUTOMATIC_INDEX compile-time option, which if set to
zero turns automatic indices off by default. Increase the estimated cost
of an automatic index. Additional minor refactoring of the automatic
index code.
FossilOrigin-Name: 459b3179023c2c45994ea4acbf34ed5f87cf3c18
show more ...
|
| #
75bf6b98 |
| 17-Jun-2013 |
drh <[email protected]> |
Use automatic indices on subqueries of the FROM clause when appropriate.
FossilOrigin-Name: e8f124284ee0d0e373dc4431668630f1e17015c1
|
| #
e1e2e9ac |
| 13-Jun-2013 |
drh <[email protected]> |
Make the MIN() and MAX() macros available in sqliteInt.h. Add TUNING
comments to the NGQP and adjust costs slightly.
FossilOrigin-Name: 3a72af2a95b04b8e195ef17cb3e9d9021a4f0915
|
| #
4fe425ad |
| 12-Jun-2013 |
drh <[email protected]> |
"make test" now passing.
FossilOrigin-Name: addd7f466d6ff55f82d907286650c26b06e9397b
|
| #
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
|
|
Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16 |
|
| #
738fc79d |
| 17-Jan-2013 |
drh <[email protected]> |
Make more aggressive use of transitivity in optimizing queries. Add a test
case.
FossilOrigin-Name: d96762841a461e192fb2f317d684d000376350dd
|
|
Revision tags: 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, version-3.7.8 |
|
| #
969e5595 |
| 02-Jul-2011 |
dan <[email protected]> |
Ensure that automatic indexes are only created in scenarios where they may be used more than once.
FossilOrigin-Name: 27c65d4d9c58bfc4ea8f9337fa15090459fb26c5
|
|
Revision tags: 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, version-3.7.5, version-3.7.4 |
|
| #
95aa47b1 |
| 16-Nov-2010 |
drh <[email protected]> |
Use the estimated number of rows computed for subqueries in the cost
computations for outer queries.
FossilOrigin-Name: 56bbc539246a6dc9f1ae1edb898db7a4f6f6d322
|
| #
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 ...
|
| #
acf1987d |
| 11-Nov-2010 |
dan <[email protected]> |
Fix a bug in the EXPLAIN QUERY PLAN code.
FossilOrigin-Name: 7ae068952fba4395b4aa437613a5ed2bd9ddf941
|
| #
47eb16d4 |
| 11-Nov-2010 |
dan <[email protected]> |
Modifications to test cases to account for new EXPLAIN QUERY PLAN output.
FossilOrigin-Name: 30904ef8412348464e893e9e1551ef22cad24a3e
|
| #
1ea87012 |
| 21-Oct-2010 |
drh <[email protected]> |
Make sure the estimated row count for ephemeral tables is initialized so that
automatic indices can be used on those tables.
FossilOrigin-Name: d30f7b2deffdba373a2e0988f433c631c790a7b5
|