|
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 |
|
| #
e8c4f032 |
| 22-Feb-2020 |
drh <[email protected]> |
In the OP_Column opcode, if the cursor is marked NullRow (due to being the
right table of a LEFT JOIN that does not match) and the cursor is the table
cursor for an OR-optimization with a covering in
In the OP_Column opcode, if the cursor is marked NullRow (due to being the
right table of a LEFT JOIN that does not match) and the cursor is the table
cursor for an OR-optimization with a covering index, then do not substitute
the covering index cursor, since the covering index cursor does not have
the NullRow flag set. Ticket [aa4378693018aa99]
FossilOrigin-Name: f02030b3403d67734bba471a91ad5bfdb03ddf6fdc3ef14808a04495e43b0470
show more ...
|
|
Revision tags: 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 |
|
| #
b40897ab |
| 26-Oct-2016 |
dan <[email protected]> |
If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the
same index, set the index cursor to return NULL values if there are no matches
for a row on the lhs.
FossilOrigin-Name:
If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the
same index, set the index cursor to return NULL values if there are no matches
for a row on the lhs.
FossilOrigin-Name: e7b9bc678ecb75c594d9d3ade12a99a8d551cdc9
show more ...
|
|
Revision tags: 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 |
|
| #
eaa6cd87 |
| 29-Jan-2016 |
dan <[email protected]> |
Add tests for the change on this branch.
FossilOrigin-Name: 7cb697f82932a2581af69350117a29c9c8a2544f
|
| #
de892d96 |
| 29-Jan-2016 |
dan <[email protected]> |
Experimental attempt to make better use of covering indexes within OR queries.
FossilOrigin-Name: a323ac3a9d42bd5cb38d724c7e1180584b91054c
|
|
Revision tags: 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 |
|
| #
8aad8c48 |
| 11-Apr-2015 |
dan <[email protected]> |
Update tests in whereD.test to account for the change in the previous commit.
FossilOrigin-Name: da49700ca148d91e1b8863c2eb6ee79144e83ac9
|
|
Revision tags: 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, version-3.8.5 |
|
| #
d83cad23 |
| 10-Apr-2014 |
drh <[email protected]> |
Modify the OR-clause handling so that it can safely deal with OR-clause
with 17 or more terms. Fix for ticket [10fb063b1179be53ea0b53bb].
FossilOrigin-Name: a67b5312f63909737c052fe58ab5772d45530d49
|
|
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 |
|
| #
6186b309 |
| 03-Jun-2013 |
drh <[email protected]> |
Add test cases to verify that ticket [bc1aea7b725f2761] has been fixed in
the NGQP.
FossilOrigin-Name: 9b97af94ae7b1624ef1f5adee58010593fbb8b1c
|
|
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 |
|
| #
6292c016 |
| 10-Oct-2012 |
mistachkin <[email protected]> |
Fix duplicate test name in whereD.test.
FossilOrigin-Name: 1182b54af0fd43d5e6aa6399837e7915aa60a578
|
| #
90abfd08 |
| 09-Oct-2012 |
drh <[email protected]> |
Merge the fix for ticket [d02e1406a58ea02] into trunk.
FossilOrigin-Name: dd34bec389359845b86f4cc4906ab440f92dcab9
|
|
Revision tags: version-3.7.14.1, version-3.7.14 |
|
| #
606bb3a5 |
| 24-Aug-2012 |
dan <[email protected]> |
Another test for whereD.test.
FossilOrigin-Name: 29d586178dcfdb99eaf7ce768668ab0aa9898c83
|
| #
89933915 |
| 24-Aug-2012 |
dan <[email protected]> |
Add extra tests to whereD.test.
FossilOrigin-Name: 7e961eef6b7260dd8deb8b3812218a874c382885
|
| #
8fea5f3b |
| 24-Aug-2012 |
drh <[email protected]> |
More test cases for OR-optimization covering indices.
FossilOrigin-Name: e5c3190c27b69dc50f348c849a81b79031b2fb67
|
| #
2797c216 |
| 24-Aug-2012 |
drh <[email protected]> |
Additional test cases for OR-optimization with covering indices, including
one test case that currently fails.
FossilOrigin-Name: d8b7ab37120ac20e60b6a600cd0e5b34a09cf97a
|
| #
bfca6a40 |
| 24-Aug-2012 |
dan <[email protected]> |
Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once.
FossilOrigin-Name: 1dc8c7c741a82bb98a07f3fdb81
Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once.
FossilOrigin-Name: 1dc8c7c741a82bb98a07f3fdb8142d8bc8d8a98b
show more ...
|