|
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, 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, version-3.11.1, version-3.11.0, version-3.10.2, 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 |
|
| #
cfc6ca41 |
| 14-Feb-2014 |
drh <[email protected]> |
Seek past NULLs in a top-constrained search. Avoid checking for NULLs in
the body of the search.
FossilOrigin-Name: e07a32f30862acf3b322d4d8deb015846d6f8f5f
|
|
Revision tags: version-3.8.3.1 |
|
| #
7c328064 |
| 11-Feb-2014 |
drh <[email protected]> |
Make sure that virtual WHERE-clause terms do not get transformed into real
terms when processing set of OR-connected terms.
Fix for ticket [4c86b126f22ad].
FossilOrigin-Name: c950d6c4117d076f871518e
Make sure that virtual WHERE-clause terms do not get transformed into real
terms when processing set of OR-connected terms.
Fix for ticket [4c86b126f22ad].
FossilOrigin-Name: c950d6c4117d076f871518e738cdf9e8c46a19fc
show more ...
|
|
Revision tags: version-3.8.3, version-3.8.2 |
|
| #
d4ddae98 |
| 06-Nov-2013 |
drh <[email protected]> |
Disable the OR optimization for WITHOUT ROWID tables, since it relies on
the use of rowids.
FossilOrigin-Name: 6055dad2ba2f9256b1f2d0a9e32ca00f1b81b0cf
|
|
Revision tags: version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0 |
|
| #
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
|
| #
fd5874d2 |
| 12-Jun-2013 |
drh <[email protected]> |
Add the "queryplanner" test permutation. Continuing refinements to NGQP.
FossilOrigin-Name: 25e2cde105a19293bdb9c001b48624e5d7f8c4e5
|
|
Revision tags: version-3.7.17 |
|
| #
4c5aeecc |
| 16-May-2013 |
dan <[email protected]> |
Fix minor test script issues causing releasetest.tcl to fail.
FossilOrigin-Name: d8ded9d8a1052885ce223c70efa55c0dd8b9920e
|
| #
3c449c6b |
| 30-Apr-2013 |
drh <[email protected]> |
Make sure extra parentheses around subqueries in the FROM clause are harmless.
Ticket [28c6e830f239ea5].
FossilOrigin-Name: 1c79569226db3d5a73e65a35877635ea8b478866
|
|
Revision tags: version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1 |
|
| #
832ee3d4 |
| 18-Dec-2012 |
drh <[email protected]> |
Optimize the degenerate case of a FROM clause table name enclosed all by
itself inside parentheses. Generate code as if the parentheses did not
exist, rather than the old behavior of manifesting the
Optimize the degenerate case of a FROM clause table name enclosed all by
itself inside parentheses. Generate code as if the parentheses did not
exist, rather than the old behavior of manifesting the parenthesized table
into a transient table. Also, tag every FROM-clause SELECT subquery that is
generated by a parenthesized FROM-clause expression using the SF_NestedFrom
flag. The new SF_NestedFrom flag is not yet used for anything.
FossilOrigin-Name: 7fecced466d86a66b0b751c5b5608141e134fe2d
show more ...
|
|
Revision tags: 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 |
|
| #
ed754ce2 |
| 15-Apr-2010 |
drh <[email protected]> |
Further refinements to table order selection on join query planning.
FossilOrigin-Name: defaf0d99a807027f8883bf821b6482025f9f54e
|
| #
c01a3c17 |
| 16-Dec-2009 |
drh <[email protected]> |
Ensure WHERE clause terms involving tables on the right end of a join
are not prematurely evaluated when tables on the left end of the join
make use of the OR-clause optimization.
Fix for ticket [3
Ensure WHERE clause terms involving tables on the right end of a join
are not prematurely evaluated when tables on the left end of the join
make use of the OR-clause optimization.
Fix for ticket [31338dca7e].
FossilOrigin-Name: 2c2de252666662f5459904fc33a9f2956cbff23c
show more ...
|
| #
9f3962e7 |
| 02-Dec-2009 |
drh <[email protected]> |
Make sure a variable is cleared before use in the where8.test script.
FossilOrigin-Name: b34365296d65310bb015901d18ed463e73d47cbe
|
|
Revision tags: fts3-refactor |
|
| #
5236ac1d |
| 13-Aug-2009 |
dan <[email protected]> |
Changes to the query planner that improve the order in which tables/indexes are scanned in join queries.
FossilOrigin-Name: 19f799b32f9d1be25d4185ce18b13f4dd502e199
|
|
Revision tags: cvs-to-fossil-cutover |
|
| #
f51d1bd6 |
| 31-Jul-2009 |
danielk1977 <[email protected]> |
Fix a bug in where.c that could cause SQLite to write to freed memory while compiling a query with many terms in the WHERE clause. (CVS 6952)
FossilOrigin-Name: 8161af840e8fd2b06457e75023f934e1b8fe5
Fix a bug in where.c that could cause SQLite to write to freed memory while compiling a query with many terms in the WHERE clause. (CVS 6952)
FossilOrigin-Name: 8161af840e8fd2b06457e75023f934e1b8fe5fd6
show more ...
|
|
Revision tags: version-3.6.15 |
|
| #
c4ac22e9 |
| 07-Jun-2009 |
drh <[email protected]> |
Disable the LIKE optimization if the affinity of the LHS column is
not TEXT. Ticket #3901. (CVS 6727)
FossilOrigin-Name: a255c645c46ae03b65f862858fe57e462076e1fc
|
| #
dda70fe3 |
| 05-Jun-2009 |
drh <[email protected]> |
Remove leftover "breakpoint" commands from test scripts. Also remove blank
lines at the end of scripts. (CVS 6721)
FossilOrigin-Name: 1fef16ec2b89981770cf44f606a420fbe031a7a4
|
| #
1d46146b |
| 21-Apr-2009 |
danielk1977 <[email protected]> |
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527)
FossilOrigin-Name: f61e4cd93682fd98bea2a71d346f9eaa68454390
|
|
Revision tags: version-3.6.10 |
|
| #
13da67e5 |
| 30-Dec-2008 |
danielk1977 <[email protected]> |
Add further pseudo-randomly generated test cases to where8.test. (CVS 6083)
FossilOrigin-Name: e01f6ef9d981d50a70c05edc4ef8135dbc473ba1
|
| #
c1071e53 |
| 30-Dec-2008 |
danielk1977 <[email protected]> |
Fix a bug in where8.test causing a tcl exception. (CVS 6082)
FossilOrigin-Name: 495b569a3921042c36667a415c1353201760fa17
|
| #
9357416a |
| 30-Dec-2008 |
danielk1977 <[email protected]> |
Add a few more tests to where8.test. (CVS 6081)
FossilOrigin-Name: ac28aa8b618d59628c5b8fc6fe649ec14f554b11
|
| #
5f0ff5d5 |
| 30-Dec-2008 |
danielk1977 <[email protected]> |
Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077)
FossilOrigin-Name: 35c87585b81866e73a58adffe6af79ddcac57cf6
|
| #
fdc4019b |
| 29-Dec-2008 |
danielk1977 <[email protected]> |
Add test file where8.test. (CVS 6072)
FossilOrigin-Name: bff460ec2c3e250de034a6b34312b897bb2f3749
|