|
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 |
|
| #
247d0946 |
| 16-Mar-2022 |
dan <Dan Kennedy> |
Add extra test cases.
FossilOrigin-Name: 0a922d141749cf3ef672f56449001e03f1a7e31822b66dcaf8550bb6e1b88cd3
|
|
Revision tags: 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 |
|
| #
6e5020e8 |
| 07-Apr-2021 |
drh <> |
Also prohibit the use of rowid from a subquery. Add the
SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior
in case somebody actually needs it.
FossilOrigin-Name: 14b1d56ef84b
Also prohibit the use of rowid from a subquery. Add the
SQLITE_ALLOW_ROWID_IN_VIEW compile-time option to restore legacy behavior
in case somebody actually needs it.
FossilOrigin-Name: 14b1d56ef84b0e62b7f9c4e5f7f985ca10e770c8db59f54004ad892c2a2dcbfb
show more ...
|
| #
204b6342 |
| 06-Apr-2021 |
drh <> |
Do not apply the optimization that omits DISTINCT if all result terms are
part of a UNIQUE index if the index is also a partial index.
Fix for the bug reported by
[forum:/forumpost/66954e9ece|forum p
Do not apply the optimization that omits DISTINCT if all result terms are
part of a UNIQUE index if the index is also a partial index.
Fix for the bug reported by
[forum:/forumpost/66954e9ece|forum post 66954e9ece].
FossilOrigin-Name: c2f940b02883e165172a4ca21c7095ffbef84ddc5367853dfeca93fda20d6056
show more ...
|
|
Revision tags: version-3.35.4, version-3.35.3 |
|
| #
9be1339f |
| 24-Mar-2021 |
drh <> |
Comment improvements to on the distinct-agg optimization. Show a line in
the EQP output when using an ephemeral table to implement DISTINCT on an
aggregate.
FossilOrigin-Name: 037ca79e6032ca962b4f6
Comment improvements to on the distinct-agg optimization. Show a line in
the EQP output when using an ephemeral table to implement DISTINCT on an
aggregate.
FossilOrigin-Name: 037ca79e6032ca962b4f6182187bc12a7d91170d73630c8cd6fb191d2c183ee4
show more ...
|
|
Revision tags: 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 |
|
| #
cb49f546 |
| 23-Mar-2020 |
drh <[email protected]> |
Further simplification and modularization of the EXPLAIN logic.
FossilOrigin-Name: aee1c12f4227cea9e8c6295cee3ec11797422c31b48c9468f176eb52f8261fe8
|
|
Revision tags: version-3.31.1, version-3.31.0 |
|
| #
9e10f9ab |
| 06-Jan-2020 |
dan <[email protected]> |
Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882].
FossilOrigin-Name: 1409758f72c0206cc48f9f7e789382472949523b7056ea46f8dcb93fd3
Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882].
FossilOrigin-Name: 1409758f72c0206cc48f9f7e789382472949523b7056ea46f8dcb93fd3ea60c6
show more ...
|
|
Revision tags: 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 |
|
| #
4e8b9925 |
| 18-Apr-2018 |
drh <[email protected]> |
Fix a test case inside distinct.test.
FossilOrigin-Name: 61cb8a391a0c709340ac60ffd0c58f950567892a8404c2bec7b9b1f64b3cc5cf
|
| #
5015c9b5 |
| 17-Apr-2018 |
drh <[email protected]> |
New test cases for upsert.
FossilOrigin-Name: 907b5a37c539ea67c285c87399b494c7fe15014389a2ea3d49e90640b58946ae
|
|
Revision tags: 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 |
|
| #
2edc5fd7 |
| 24-Nov-2015 |
drh <[email protected]> |
Remove an incorrect ALWAYS() macro. Fix for ticket [e5c6268dd807fa8950] -
a problem introduced in SQLite 3.9.0 and found by libFuzzer.
FossilOrigin-Name: 824ad96f72cb0c948ec98aca9d17a7e6790c575f
|
|
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, 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 |
|
| #
dea7d70d |
| 04-Dec-2014 |
drh <[email protected]> |
Make sure that a DISTINCT query with an ORDER BY works correctly even if
it uses a descending index. Fix for ticket [c5ea805691bfc4204b1cb9e].
FossilOrigin-Name: 0d3aef97ebddf422b8bdcbc5878970c6129
Make sure that a DISTINCT query with an ORDER BY works correctly even if
it uses a descending index. Fix for ticket [c5ea805691bfc4204b1cb9e].
FossilOrigin-Name: 0d3aef97ebddf422b8bdcbc5878970c6129e3f54
show more ...
|
|
Revision tags: 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 |
|
| #
6284db90 |
| 19-Mar-2014 |
drh <[email protected]> |
Fix query planner weights associated with choosing block-sorting. Fix
block sorting of tables with collating functions. Fix various test cases.
All "veryquick" tests are now passing, though more te
Fix query planner weights associated with choosing block-sorting. Fix
block sorting of tables with collating functions. Fix various test cases.
All "veryquick" tests are now passing, though more tests need to be added.
FossilOrigin-Name: 01afbf97c0ff29667806e9a7c4d74ca717819de5
show more ...
|
|
Revision tags: version-3.8.4.1, version-3.8.4, version-3.8.3.1 |
|
| #
826af378 |
| 08-Feb-2014 |
drh <[email protected]> |
Change the OP_Found opcode so that it expands zero-blobs prior to comparing
them. Fix for ticket [fccbde530a6583b]
FossilOrigin-Name: e2303d1b0c17b6e7494fb7db8264f4c2ac193723
|
|
Revision tags: 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 |
|
| #
4fe425ad |
| 12-Jun-2013 |
drh <[email protected]> |
"make test" now passing.
FossilOrigin-Name: addd7f466d6ff55f82d907286650c26b06e9397b
|
|
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 |
|
| #
580c8c18 |
| 08-Dec-2012 |
drh <[email protected]> |
Veryquick passes all tests now.
FossilOrigin-Name: 7b96115e81deab0aa0472839cf787ba3f2fc64a7
|
|
Revision tags: version-3.7.14.1 |
|
| #
053a128f |
| 19-Sep-2012 |
drh <[email protected]> |
Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword
handling.
FossilOrigin-Name: 94b48064db3cbb43e911fdf7183218b08146ec10
|
| #
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 |
|
| #
6a36f435 |
| 20-Apr-2012 |
dan <[email protected]> |
Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (eith
Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9].
FossilOrigin-Name: 7b8548b1872cc1225355ba8311e93dd08d6526e2
show more ...
|
|
Revision tags: mountain-lion, version-3.7.11 |
|
| #
2f56da3f |
| 13-Feb-2012 |
dan <[email protected]> |
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.
FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769
|
| #
33f111dc |
| 17-Jan-2012 |
drh <[email protected]> |
Remove the undocumented PRAGMA omit_readlock hack.
FossilOrigin-Name: 96900c47e4fc6ed55cefc10d55d3d8d16bcb1d31
|
|
Revision tags: version-3.7.10, version-3.7.9, version-3.7.8 |
|
| #
1c9d835d |
| 01-Sep-2011 |
drh <[email protected]> |
Use OP_SorterOpen instead of OP_OpenEphemeral to implement GROUP BY.
FossilOrigin-Name: ebf819aaa555bd79fddfc0a6f9827a2539095d6c
|
| #
94e08d92 |
| 02-Jul-2011 |
dan <[email protected]> |
Fix a broken assert() in where.c.
FossilOrigin-Name: 090b29177fbc9faa83b560d92ddc3710d291776e
|
| #
6f343969 |
| 01-Jul-2011 |
dan <[email protected]> |
Improve use of indexes to optimize DISTINCT queries.
FossilOrigin-Name: 6c202ea0247ff509f696eee3839975a88ed26cf2
|
| #
50118cdf |
| 01-Jul-2011 |
dan <[email protected]> |
Improvements and tests for detection of redundant DISTINCT qualifiers.
FossilOrigin-Name: 7337293c87fb563604dd6ad284f2d1e30c938b4c
|