|
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 |
|
| #
f5576936 |
| 17-Apr-2021 |
larrybr <[email protected]> |
Allow more time for perf tests when instrumented. Condition another on feature it needs.
FossilOrigin-Name: f0dd9cf2d7045d3634294bcf2722d3d7b0a6c4c3ef713b0f7f54fbe31432027f
|
|
Revision tags: 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 |
|
| #
33941691 |
| 15-Feb-2021 |
drh <> |
Fix an issue with the LIKE operator when it includes the "ESCAPE '_'" clause.
Ticket [c0aeea67d58ae0fd].
FossilOrigin-Name: 27d4117980d125975b5e70eeea58a6ab07bcf066e71b5fcb81b822e05afdbab0
|
|
Revision tags: 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 |
|
| #
589c7876 |
| 19-Mar-2020 |
drh <[email protected]> |
Chagnes the ESCAPE clause on the LIKE operator to overwrite wildcard
characters, in order ot match the behavior of PosgreSQL.
FossilOrigin-Name: 11e0844f71e8f2d27ce9363fb505e02fd7795c61dae0b3886cf0d
Chagnes the ESCAPE clause on the LIKE operator to overwrite wildcard
characters, in order ot match the behavior of PosgreSQL.
FossilOrigin-Name: 11e0844f71e8f2d27ce9363fb505e02fd7795c61dae0b3886cf0d8df4484dd97
show more ...
|
|
Revision tags: version-3.31.1, version-3.31.0, 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 ...
|
|
Revision tags: version-3.29.0 |
|
| #
32d0f64e |
| 10-Jun-2019 |
dan <[email protected]> |
Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e].
FossilOrigin-Name: 94b58ab059cba9771e75f16d1460
Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e].
FossilOrigin-Name: 94b58ab059cba9771e75f16d1460f313104a8fb879f9f8805725d362aa58cbcd
show more ...
|
|
Revision tags: 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 |
|
| #
9325c87c |
| 27-Sep-2017 |
drh <[email protected]> |
Disable tests for the LIKE optimization when ICU is enabled, since the
LIKE optimization only works for the built-in LIKE operator and ICU overrides
the built-in.
FossilOrigin-Name: f5ef2e1bcd2790f9
Disable tests for the LIKE optimization when ICU is enabled, since the
LIKE optimization only works for the built-in LIKE operator and ICU overrides
the built-in.
FossilOrigin-Name: f5ef2e1bcd2790f960c15947f87cda19bd6a6a384ad09b25f6d07d5244cfecbd
show more ...
|
|
Revision tags: version-3.20.1, version-3.19.4, version-3.20.0 |
|
| #
1d42ea71 |
| 27-Jul-2017 |
drh <[email protected]> |
Enhance the like optimization so that it works with an ESCAPE clause.
FossilOrigin-Name: f5d330f495d07a704e115595bbdf5422ddb68fd8191114c5a12c9c873d983f7c
|
| #
cb0d3ba8 |
| 15-Jul-2017 |
dan <[email protected]> |
Fix another minor problem in test file like.test.
FossilOrigin-Name: 0953e74612358f48a9c9e3772876b514bc79784f277497121c59302a3106110c
|
| #
a50b3091 |
| 15-Jul-2017 |
dan <[email protected]> |
Fix test problems causing the "prepare" permutation test to fail.
FossilOrigin-Name: b61cc5a0f9f2c2d2175ad30fc3fa4cb2086dbb948d5a5cc538ac43b871bb5221
|
| #
169dd928 |
| 26-Jun-2017 |
drh <[email protected]> |
Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner
stability guarantee. This involves refactoring the sqlite3.flags bitvector
to carve out a free bit to use.
FossilOrigin-Name
Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner
stability guarantee. This involves refactoring the sqlite3.flags bitvector
to carve out a free bit to use.
FossilOrigin-Name: 7076e8283ebae1b45a5d85d9538b49b6da399d38c3c6935de100f948f814f6a9
show more ...
|
|
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 |
|
| #
7a40707b |
| 02-Dec-2016 |
drh <[email protected]> |
Test cases for the improved LIKE/GLOB matcher.
FossilOrigin-Name: 0bdb7ae126d3909344640813489ee68ecad041c4
|
|
Revision tags: 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 |
|
| #
fb397260 |
| 20-Jan-2016 |
drh <[email protected]> |
Case folding in the LIKE operator should look at all bits of the character,
not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a
back-out of check-in [0a99a8c4facf] with a testcase
Case folding in the LIKE operator should look at all bits of the character,
not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a
back-out of check-in [0a99a8c4facf] with a testcase added.
FossilOrigin-Name: 204432ee72fda8e82d244c4aa18de7ec4811b8e1
show more ...
|
|
Revision tags: version-3.10.1, version-3.10.0 |
|
| #
41d2e66e |
| 01-Dec-2015 |
drh <[email protected]> |
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
FossilOrigin-Name: 9e1d6d4c391ff90077f0d1cdeb567969fee9f747
|
|
Revision tags: 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 |
|
| #
a9c18a90 |
| 06-Mar-2015 |
drh <[email protected]> |
Test cases added. Comments fixed. Proposed solution for
ticket [05f43be8fdda9fbd9].
FossilOrigin-Name: 6b993bd54035b67f4d84941e3f444ca79b7feee1
|
|
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, version-3.8.6, version-3.8.5, 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 |
|
| #
6ade453c |
| 16-Jan-2014 |
drh <[email protected]> |
Always use available indices to optimize LIKE operators even if the pattern
of the LIKE operator has a COLLATE modifier. This fixes an ineffiency that
was introduced into 3.7.15 by check-in [8542e61
Always use available indices to optimize LIKE operators even if the pattern
of the LIKE operator has a COLLATE modifier. This fixes an ineffiency that
was introduced into 3.7.15 by check-in [8542e6180d4] on 2012-12-08.
FossilOrigin-Name: 16bd54783a3f5531c55564ddefdada657c078eb0
show more ...
|
|
Revision tags: version-3.8.2, version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0 |
|
| #
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
|
|
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 |
|
| #
3f4d1d1b |
| 15-Sep-2012 |
drh <[email protected]> |
Attempt to use a covering index even on a full table scan, under the theory
that the index will be smaller and require less disk I/O and thus be faster.
FossilOrigin-Name: cfaa7bc12847a7006ccc93815f
Attempt to use a covering index even on a full table scan, under the theory
that the index will be smaller and require less disk I/O and thus be faster.
FossilOrigin-Name: cfaa7bc12847a7006ccc93815f2395ad5259744a
show more ...
|
|
Revision tags: 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 |
|
| #
9da058bb |
| 17-Aug-2011 |
drh <[email protected]> |
Use OP_Sort rather than OP_Rewind in order to sort the content of a new
index on the CREATE INDEX statement. Add an ALWAYS() to the merge sort
logic to document an unreachable branch.
FossilOrigin-
Use OP_Sort rather than OP_Rewind in order to sort the content of a new
index on the CREATE INDEX statement. Add an ALWAYS() to the merge sort
logic to document an unreachable branch.
FossilOrigin-Name: f01766f42342f043bf0cbe1e07224963011f01b7
show more ...
|
|
Revision tags: version-3.7.7.1 |
|
| #
c7060c4d |
| 26-Jun-2011 |
drh <[email protected]> |
Modifications to the "like.test" script in order to expose the problem
reported by ticket [25ee81271091ec27a8c5].
FossilOrigin-Name: c4db5b640638a211b096454ba90b58faf595392b
|
|
Revision tags: 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 |
|
| #
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 |
|
| #
6bd2c735 |
| 01-Nov-2010 |
dan <[email protected]> |
Changes to test scripts so that they work with SQLITE_ENABLE_ICU.
FossilOrigin-Name: 465c819fdb601961eddb7304642c823d78111992
|
|
Revision tags: experimental, version-3.7.2 |
|
| #
8342e49f |
| 22-Jul-2010 |
drh <[email protected]> |
Enhance the LIKE/GLOB query optimization so that it works as long as there
is an index with the appropriate collating sequence and even if the default
collating sequence of the column is different.
T
Enhance the LIKE/GLOB query optimization so that it works as long as there
is an index with the appropriate collating sequence and even if the default
collating sequence of the column is different.
Ticket [4711020446da7d93d99].
FossilOrigin-Name: 9f932655f9eb9fdab16d7deed98b7cad414e0ca6
show more ...
|
| #
93ee23cc |
| 22-Jul-2010 |
drh <[email protected]> |
Try to optimize LIKE and GLOB operators when RHS contains no wildcard.
Ticket [e090183531fc274747]
FossilOrigin-Name: 613a87d62fd1f8526d53136efae5adae91824bcf
|