|
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, 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, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0 |
|
| #
90730c9e |
| 09-Mar-2016 |
drh <[email protected]> |
When optimizing expressions of the form "x IN (SELECT ...)" make sure that
the subquery is not correlated. Fix for ticket [5e3c886796e5512].
FossilOrigin-Name: 1ed6b06ea3c432f920fb2b66b6042be906c5d
When optimizing expressions of the form "x IN (SELECT ...)" make sure that
the subquery is not correlated. Fix for ticket [5e3c886796e5512].
FossilOrigin-Name: 1ed6b06ea3c432f920fb2b66b6042be906c5d21c
show more ...
|
|
Revision tags: 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 |
|
| #
2dc29293 |
| 27-Aug-2015 |
drh <[email protected]> |
Fix the OR-optimization so that it always ignores subplans that do not
use an index.
FossilOrigin-Name: 66f92a16866e5825363636b9cc4b8f9b29d9e84d
|
|
Revision tags: 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 |
|
| #
a45fdc7b |
| 22-Jul-2014 |
drh <[email protected]> |
The optimization of check-in [b67a6e33f2] does not work (it generates
incorrect VDBE code) if an OR term is AND-ed with a constant expression.
So back that optimization out and add a test case to mak
The optimization of check-in [b67a6e33f2] does not work (it generates
incorrect VDBE code) if an OR term is AND-ed with a constant expression.
So back that optimization out and add a test case to make sure it does not
get added back in.
FossilOrigin-Name: eed754fe93644f4df082eac0c0a7ffc5c78ccd10
show more ...
|
|
Revision tags: version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4 |
|
| #
434a9314 |
| 26-Feb-2014 |
drh <[email protected]> |
Improved handling of constants and especially constant functions in the
ORDER BY clause of a query. Do not optimize out "ORDER BY random()".
Fix for ticket [65bdeb9739605cc2296].
FossilOrigin-Name:
Improved handling of constants and especially constant functions in the
ORDER BY clause of a query. Do not optimize out "ORDER BY random()".
Fix for ticket [65bdeb9739605cc2296].
FossilOrigin-Name: dca1945aeb3fb005263f9be00ee8e72b966ae303
show more ...
|
|
Revision tags: version-3.8.3.1, version-3.8.3, version-3.8.2, version-3.8.1 |
|
| #
165674d8 |
| 04-Oct-2013 |
drh <[email protected]> |
Fix test cases so that they work when the query planner uses index size
estimates to determine whether or not to try an covering index scan.
FossilOrigin-Name: 2f394de88f23dacd3c61e586a4214ffc6f927d
Fix test cases so that they work when the query planner uses index size
estimates to determine whether or not to try an covering index scan.
FossilOrigin-Name: 2f394de88f23dacd3c61e586a4214ffc6f927d97
show more ...
|
|
Revision tags: version-3.8.0.2, version-3.8.0.1, version-3.8.0 |
|
| #
c63e880b |
| 21-Aug-2013 |
dan <[email protected]> |
Minor fixes for test cases. No code changes.
FossilOrigin-Name: ef2a6a37366f91889dc2f1ba9cb6d1257d9b05db
|
| #
aa32e3c6 |
| 16-Jul-2013 |
drh <[email protected]> |
Enhance the query planner so that it looks at multiple solutions to OR
expressions in the WHERE clause.
FossilOrigin-Name: 5e19d054105fb16ff52d265d48cc87a418603f6f
|
| #
c1f19f95 |
| 05-Jul-2013 |
dan <[email protected]> |
Fix two test script problems revealed by permutations.test.
FossilOrigin-Name: 60cf7e44871ca8d2136ddad02188f0b9f9c380c1
|
| #
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
|
| #
7c171098 |
| 03-Jun-2013 |
drh <[email protected]> |
Remove more vestiges of sqlite_query_plan from the test cases.
FossilOrigin-Name: eb27086e8a8a4d5fcb2ea358256a555e34339423
|
| #
ae70cf18 |
| 31-May-2013 |
drh <[email protected]> |
Allow tracing of whereLoopInsert() when the 0x8 bit is set on ".wheretrace".
Remove the use of sqlite_query_plan from where2.test. Fix a bug in the
code generator for OR clause optimizations.
Fossi
Allow tracing of whereLoopInsert() when the 0x8 bit is set on ".wheretrace".
Remove the use of sqlite_query_plan from where2.test. Fix a bug in the
code generator for OR clause optimizations.
FossilOrigin-Name: 707f0323264c35be14847a6adc49a0dc5eaf4ad2
show more ...
|
|
Revision tags: version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16 |
|
| #
2d96b934 |
| 08-Feb-2013 |
drh <[email protected]> |
Loop through the elements on the RHS of an IN operator in reverse order when
the ORDER BY clauses specifies DESC.
FossilOrigin-Name: f78395c8896666bb1359b83fbcd58d5e3dbc39d3
|
| #
1b8fc65b |
| 07-Feb-2013 |
drh <[email protected]> |
Allow an index to be used for sorting even if prior terms of the index
are constrained by IN operators.
FossilOrigin-Name: 98bf668ab1a8683b46ee8c94cb60f8215aabc517
|
|
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, 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, experimental, version-3.7.2 |
|
| #
be837bdd |
| 30-Apr-2010 |
drh <[email protected]> |
Avoid assertion faults in queries using indices with redundant columns.
Ticket [3dbdcdb14e7f41].
FossilOrigin-Name: 946e06cd2a2cc209b0786b7e9d28c0746320d646
|
|
Revision tags: fts3-refactor, cvs-to-fossil-cutover, version-3.6.15 |
|
| #
9373b018 |
| 02-Feb-2009 |
drh <[email protected]> |
Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229)
FossilOrigin-Name: b8b546b6ed799dc1621ef7b06273249af1042fb2
|
|
Revision tags: version-3.6.10 |
|
| #
d1d38488 |
| 07-Oct-2008 |
drh <[email protected]> |
Add the experimental sqlite3_stmt_status() interface. (CVS 5781)
FossilOrigin-Name: de473efb35ffdf9a8222a70a84dfd7d3198c87c1
|
| #
284f4aca |
| 10-Dec-2007 |
danielk1977 <[email protected]> |
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)
FossilOrigin-Name: 0b34a18651764e650faba983be8593992ab2f4a9
|
| #
4152e677 |
| 12-Sep-2007 |
danielk1977 <[email protected]> |
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)
FossilOrigin-Name: c8405b15c074c94dab5e33272cf1471f458d11df
|
| #
3e355807 |
| 23-Feb-2007 |
drh <[email protected]> |
Disable the OR optimization if it would conflict with column
affinity coercions. Ticket #2249. Additional cleanup and testing
of the OR optimization. (CVS 3658)
FossilOrigin-Name: 908daaa9ab86e0bd
Disable the OR optimization if it would conflict with column
affinity coercions. Ticket #2249. Additional cleanup and testing
of the OR optimization. (CVS 3658)
FossilOrigin-Name: 908daaa9ab86e0bd1da6d0807d6aaba240c3cee0
show more ...
|
| #
38276586 |
| 06-Nov-2006 |
drh <[email protected]> |
Fix a bug in the optimizer that was causing it to miss an OR optimization
opportunity. (CVS 3502)
FossilOrigin-Name: 9bf153b54c6e9ba16914dedd9e2949f32d7550ea
|
| #
ffe0f890 |
| 11-May-2006 |
drh <[email protected]> |
Correctly handle multi-column indices where multiple columns are constrained
by IN operators with subqueries on the right-hand side. Ticket #1807. (CVS 3184)
FossilOrigin-Name: b16541ba5e6a9514f9f3
Correctly handle multi-column indices where multiple columns are constrained
by IN operators with subqueries on the right-hand side. Ticket #1807. (CVS 3184)
FossilOrigin-Name: b16541ba5e6a9514f9f317888117c68b6818f9cb
show more ...
|
| #
3bdca9c9 |
| 17-Jan-2006 |
danielk1977 <[email protected]> |
Test suite fixes for builds that define OMIT symbols. (CVS 2962)
FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9
|
| #
ff890793 |
| 16-Jan-2006 |
danielk1977 <[email protected]> |
Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961)
FossilOrigin-Name: c058f483a52c8043178b6329aa5e58bedf0c8277
|