|
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 |
|
| #
b592d47a |
| 06-Jan-2020 |
drh <[email protected]> |
Do not attempt to use the skip-scan optimization if prior terms of the
index are already used for non-equality constraints.
Ticket [304017f5f04a0035]
FossilOrigin-Name: d7126a9ced86cb0934d5bde2bf535
Do not attempt to use the skip-scan optimization if prior terms of the
index are already used for non-equality constraints.
Ticket [304017f5f04a0035]
FossilOrigin-Name: d7126a9ced86cb0934d5bde2bf535e6b529c361444c99e723f29dd3eb36e7044
show more ...
|
|
Revision tags: version-3.30.1, version-3.30.0 |
|
| #
175b8f06 |
| 08-Aug-2019 |
drh <[email protected]> |
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
exist. STAT4 continues to work as it always has, and as it is a superset of
STAT3 is the recommended replacement.
FossilOrigi
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
exist. STAT4 continues to work as it always has, and as it is a superset of
STAT3 is the recommended replacement.
FossilOrigin-Name: 1e17ea2fd1df4ad49138c787c8fe3207dd0c25c93f9001d52a9b69f8c12e841c
show more ...
|
| #
2ad07d96 |
| 30-Jul-2019 |
drh <[email protected]> |
Improved fix for ticket [ced41c7c7d6b4d36] that keeps skip-scan enabled,
but avoids identifying a skip-scan as order-distinct (because it is not)
and thus forces a separate b-tree to implement the DI
Improved fix for ticket [ced41c7c7d6b4d36] that keeps skip-scan enabled,
but avoids identifying a skip-scan as order-distinct (because it is not)
and thus forces a separate b-tree to implement the DISTINCT clause of a
query. This undoes check-in [a871d69c6de65038] and substitutes a new fix.
FossilOrigin-Name: 89bf0399e87be76e7b264e0a35e8a6d3af0f9e71123a929c20754882b636ca70
show more ...
|
| #
822bc969 |
| 30-Jul-2019 |
drh <[email protected]> |
Disable the skip-scan optimization for DISTINCT queries.
Fix for ticket [ced41c7c7d6b4d36]
FossilOrigin-Name: a871d69c6de65038360aa6142fbad22689fb347e526cca56bb83e695c1441fbe
|
|
Revision tags: version-3.29.0, version-3.28.0 |
|
| #
6cf3009f |
| 05-Apr-2019 |
dan <[email protected]> |
Add further tests so that veryquick.test covers all vdbe branches.
FossilOrigin-Name: cbc67de5a3937fa65811ed7c13e870699c895660dc2132cf9d3cf5d83364e344
|
|
Revision tags: 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 |
|
| #
e8825519 |
| 12-Jul-2018 |
dan <[email protected]> |
Add a test-control to disable the skip-scan optimization.
FossilOrigin-Name: 650a3fe03d61068e06f3097878a777ca8ed713a769444cdb3f8be7d1e19a0b83
|
|
Revision tags: 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 |
|
| #
9a2e5169 |
| 19-Sep-2016 |
drh <[email protected]> |
Fix a segfault introduced by the row-value enhancement that comes up on
a skip-scan where the first term of the index is unconstrained and the
second term is of the form "columm IN (SELECT...)".
Fos
Fix a segfault introduced by the row-value enhancement that comes up on
a skip-scan where the first term of the index is unconstrained and the
second term is of the form "columm IN (SELECT...)".
FossilOrigin-Name: 2401ea5acfeee8042489d1db38036ff86e8a6916
show more ...
|
|
Revision tags: version-3.14.2, version-3.14.1, version-3.14.0 |
|
| #
99bbcc82 |
| 29-Jul-2016 |
drh <[email protected]> |
Undo some unhelpful changes to skip-scan scoring that were added
by the check-in [9e2b2681] that improved scoring of index scan.
FossilOrigin-Name: c7d51934a4f30d096bb79fc509fc9dd0df5d89a4
|
|
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 |
|
| #
d3e3f0b4 |
| 23-Jul-2015 |
drh <[email protected]> |
The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the
register requested. Fix the skip-scan code generator for WITHOUT ROWID
tables so that it always checks the register and cop
The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the
register requested. Fix the skip-scan code generator for WITHOUT ROWID
tables so that it always checks the register and copies the result if it
lands in the wrong register. Fix for ticket [8fd39115d8f46ece70e7d4b3].
FossilOrigin-Name: 793e206f9032d9205bdb3f447b136bed9a25fa22
show more ...
|
|
Revision tags: 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 |
|
| #
f9df2fbd |
| 15-Nov-2014 |
drh <[email protected]> |
Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an
index for being used with the skip-scan algorithm.
FossilOrigin-Name: 00fe09505792cd0d104b2da9d040f023e30fa871
|
|
Revision tags: version-3.8.7.1, version-3.8.6.1, version-3.8.7 |
|
| #
14f0e212 |
| 23-Sep-2014 |
drh <[email protected]> |
Adjust skip-scan cost estimates slightly so that a full table scan is
preferred over a skip-scan to a column with only two distinct values.
FossilOrigin-Name: ae9a42b268ad3f7d21a5813bb931e795c6917014
|
|
Revision tags: version-3.8.6, version-3.8.5 |
|
| #
e96f2df3 |
| 23-May-2014 |
dan <[email protected]> |
Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table.
FossilOrigin-Name: 9268df305b90ac11e44b3107bbab5becf38860b7
|
|
Revision tags: version-3.8.4.3, version-3.8.4.2, version-3.8.4.1 |
|
| #
89212fb9 |
| 10-Mar-2014 |
drh <[email protected]> |
Adjustments to the cost computation for the skip-scan query plan, to take
into account the fact that a seek has to occur on each skip.
FossilOrigin-Name: 0769eebd028ce31375cf93509a1d3687f7b117eb
|
|
Revision tags: version-3.8.4, version-3.8.3.1, version-3.8.3 |
|
| #
6c1de308 |
| 22-Dec-2013 |
drh <[email protected]> |
Make sure the WhereLoop.aLTerm[] array is large enough when processing
the skip-scan optimization. Fix for ticket [520070ec7fbaac].
FossilOrigin-Name: 46d040591f27be01b1860344f8a268797fe344f4
|
|
Revision tags: version-3.8.2 |
|
| #
2e5ef4ed |
| 13-Nov-2013 |
drh <[email protected]> |
Improve the way that skip-scan loops are constructued. Add test cases.
Improved the scoring of skip-scan loops.
FossilOrigin-Name: 5e75ab93881b85801cb4ebf70f2063ff7c51ac19
|
| #
c2b23e7a |
| 13-Nov-2013 |
drh <[email protected]> |
Add test cases for skip-scan. Enhance "do_test" so that if the expected result
is of the form "/*..*/" or "~/*..*/" it treats the expected result as a glob
pattern rather than as a regular expressio
Add test cases for skip-scan. Enhance "do_test" so that if the expected result
is of the form "/*..*/" or "~/*..*/" it treats the expected result as a glob
pattern rather than as a regular expression. Fix a bug in ANALYZE result
loading associated with WITHOUT ROWID tables.
FossilOrigin-Name: d3e6e9b2a74074c05429d3c341c23525504351ab
show more ...
|