|
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 |
|
| #
ce68b6bf |
| 21-Aug-2021 |
drh <> |
Defer deleting subqueries in the compound-SELECT code generator until the
end of code generation, in order to avoid deleting expressions out from under
the aggregation function sanity checking assert
Defer deleting subqueries in the compound-SELECT code generator until the
end of code generation, in order to avoid deleting expressions out from under
the aggregation function sanity checking assert()s that occur near the
end of SELECT code generation. This fixes the assertion fault described by
[forum:/forumpost/cfcb4b461d|forum post cfcb4b461d].
FossilOrigin-Name: 600f1991e5c0a5d89cd8776a157b6fd72c7489791085876925e8dd7ab146fe1f
show more ...
|
|
Revision tags: 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 ...
|
|
Revision tags: 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 |
|
| #
426f4ab0 |
| 26-Jul-2016 |
drh <[email protected]> |
Make sure affinity is applied correctly on lower-bound range constraints
in the min() optimization. Fix for ticket [a0bac8b3c3d1bb].
FossilOrigin-Name: b819bace9c2a0b0159122b26db96a8f50a6f0eac
|
|
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, 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, 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, version-3.8.2, version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0, 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 |
|
| #
4ac391fc |
| 13-Dec-2012 |
dan <[email protected]> |
Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or
Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause.
FossilOrigin-Name: 7280e14cd8f55896451847b432171e8750a07c81
show more ...
|
|
Revision tags: version-3.7.15 |
|
| #
21172c4c |
| 30-Oct-2012 |
drh <[email protected]> |
Add an optimization that attempts to run a subquery as a coroutine rather
than manifesting it into a temporary table.
FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd
|
|
Revision tags: 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, fts3-refactor, cvs-to-fossil-cutover, version-3.6.15, version-3.6.10 |
|
| #
0880a746 |
| 08-Jul-2008 |
drh <[email protected]> |
Improved testing of the min/max optimization. (CVS 5373)
FossilOrigin-Name: fa07c360b708324c47c8e9931f1e2b1b24e4faf8
|
| #
a9d1ccb9 |
| 05-Jan-2008 |
danielk1977 <[email protected]> |
First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687)
FossilOrigin-Name: c449e04f1870b1ff726c95c0bf1c6c6a22ca588a
|
| #
92378253 |
| 26-Mar-2006 |
drh <[email protected]> |
SQLite now always chooses the column names for compound selects using
the left-most select. This makes SQLite work like other SQL database,
but it also is a change from historical behavior and may b
SQLite now always chooses the column names for compound selects using
the left-most select. This makes SQLite work like other SQL database,
but it also is a change from historical behavior and may break some
scripts. Ticket #1721. (CVS 3153)
FossilOrigin-Name: 80cda9f7ce83f2de6cd2fdaf6150bbc35b670fee
show more ...
|
| #
3f219f46 |
| 08-Sep-2005 |
drh <[email protected]> |
A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.
A SUM() of a mixture of NULLs and numbers returns the sum of the
numbers. Ticket #1413. (CVS 2677)
FossilOrigin-Name: 2e6230edfd651b
A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.
A SUM() of a mixture of NULLs and numbers returns the sum of the
numbers. Ticket #1413. (CVS 2677)
FossilOrigin-Name: 2e6230edfd651b40481ebad8aa01a22ac92ce80c
show more ...
|
| #
3d1d95e6 |
| 08-Sep-2005 |
drh <[email protected]> |
The SUM() aggregate function returns an integer result if all inputs are
integers. Any single non-integer input causes the result to be a floating
point value. (CVS 2669)
FossilOrigin-Name: 21adf4b
The SUM() aggregate function returns an integer result if all inputs are
integers. Any single non-integer input causes the result to be a floating
point value. (CVS 2669)
FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654
show more ...
|
| #
e61b9f4f |
| 21-Jan-2005 |
danielk1977 <[email protected]> |
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252)
FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2
|
| #
3e8c37e7 |
| 21-Jan-2005 |
danielk1977 <[email protected]> |
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251)
FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
|
| #
27c77438 |
| 22-Nov-2004 |
danielk1977 <[email protected]> |
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)
FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3
|
| #
92febd92 |
| 20-Aug-2004 |
drh <[email protected]> |
Tcl interface transfers values directly between SQLite and Tcl_Objs, without
at translation to strings. (CVS 1898)
FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf
|
| #
1af3fdb4 |
| 18-Jul-2004 |
drh <[email protected]> |
An improved fix for the min() problem of ticket #800. (CVS 1804)
FossilOrigin-Name: b6e8b7a13cd9f90e2f7d963d9ddbe591571f3a27
|
| #
9eb516c0 |
| 18-Jul-2004 |
drh <[email protected]> |
min() ignores NULL values. Ticket #800. (CVS 1802)
FossilOrigin-Name: 166234a2b61e1d6a501e48dde1caec0a02bec90b
|
| #
3aeab9e4 |
| 24-Jun-2004 |
danielk1977 <[email protected]> |
Apply (1679) to version 3. Ticket #777. (CVS 1680)
FossilOrigin-Name: 0a26b9158095f0995fce2f0ccdfb383ab26c76a5
|
| #
6e17529e |
| 13-Mar-2004 |
drh <[email protected]> |
Fix the min/max optimizer so that it works when the FROM clause is a
subquery. Ticket #658. (CVS 1293)
FossilOrigin-Name: 31c94acc72d318b5dec0fef1485621943add45c8
|
| #
268380ca |
| 25-Feb-2004 |
drh <[email protected]> |
Min() and max() functions honor the distinction between TEXT and NUMERIC
data. Ticket #623. typeof() is now a user function. Some tests are
now failing due to ticket #521. (CVS 1272)
FossilOrigin
Min() and max() functions honor the distinction between TEXT and NUMERIC
data. Ticket #623. typeof() is now a user function. Some tests are
now failing due to ticket #521. (CVS 1272)
FossilOrigin-Name: adbe31adf1ad0ca723203ca3d7dc480324c60d43
show more ...
|
| #
0c37e630 |
| 30-Jan-2004 |
drh <[email protected]> |
Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201)
FossilOrigin-Name: af73fbca839f8cbe39c21f1f9e439fe9b79005c8
|
| #
e5f50722 |
| 19-Jul-2003 |
drh <[email protected]> |
Make sure the min() and max() optimizer works correctly when there
is a LIMIT clause. Ticket #396. (CVS 1057)
FossilOrigin-Name: c35e50717678703763c696e3e9b265add2ca6454
|
| #
d4d595f9 |
| 17-Apr-2003 |
drh <[email protected]> |
Make sure the min() and max() optimizations work on empty indexed tables.
Ticket #296. (CVS 914)
FossilOrigin-Name: 98ef6110068e5ed3cd77a14b004f890b79b731f7
|
| #
f570f011 |
| 31-May-2002 |
drh <[email protected]> |
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.
Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison
is considered false, not NULL. With these
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.
Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison
is considered false, not NULL. With these changes, NULLs in SQLite now work
the same as in PostgreSQL and in Oracle. (CVS 600)
FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f
show more ...
|
| #
739105c7 |
| 29-May-2002 |
drh <[email protected]> |
Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597)
FossilOrigin-Name: 19ae12bef210ae5fe171f10833faa38d640c129f
|
| #
bb113518 |
| 27-May-2002 |
drh <[email protected]> |
Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592)
FossilOrigin-Name: 0e268d0c0faa02c3f95e1567cf631b7a04bfbdf0
|