|
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 |
|
| #
4784a78d |
| 26-Jul-2022 |
dan <Dan Kennedy> |
Add test cases related to fix [e717e029].
FossilOrigin-Name: 2909f36bfba8f34b818e5d9ecd8c759f05bbe25765089e78bb022de2b77a4f0f
|
| #
6b6d6c6b |
| 25-Jul-2022 |
drh <> |
TK_IF_NULL_ROW expressions must be accumulated in the same way as TK_COLUMN
expressions in an aggregate query. Proposed fix for the problem identifyed by
dbsqlfuzz 8e17857db2c5a9294c975123ac807156a6
TK_IF_NULL_ROW expressions must be accumulated in the same way as TK_COLUMN
expressions in an aggregate query. Proposed fix for the problem identifyed by
dbsqlfuzz 8e17857db2c5a9294c975123ac807156a6559f13.
FossilOrigin-Name: 40d08807209638aad728be2cedbc904e342e76c8e486c364bd571b55dd2e1e87
show more ...
|
|
Revision tags: version-3.39.2, version-3.39.1 |
|
| #
2c1b1ddc |
| 01-Jul-2022 |
dan <Dan Kennedy> |
Do not attempt the OP_Count optimization on queries with HAVING clauses.
FossilOrigin-Name: 566b7842ee286ed8620a87b06de65bc173ad0d208df4157292238fcb059cb484
|
|
Revision tags: version-3.39.0 |
|
| #
b9294de1 |
| 21-Jun-2022 |
drh <> |
Allow a HAVING clause on any aggregate query, even if there is no GROUP BY
clause. This brings SQLite into closer agreement with PostgreSQL and fixes
the concern raised by
[forum:/forumpost/1a7fea4
Allow a HAVING clause on any aggregate query, even if there is no GROUP BY
clause. This brings SQLite into closer agreement with PostgreSQL and fixes
the concern raised by
[forum:/forumpost/1a7fea4651|forum post 1a7fea4651].
FossilOrigin-Name: 9322a7c21f1c22ba00e9b889223e89bc1591db6e561ce05091e905e98c1bf2b3
show more ...
|
|
Revision tags: 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 |
|
| #
cd653a32 |
| 13-Jun-2020 |
dan <[email protected]> |
Avoid deleting expression nodes in the flattener code, as they may be referenced by AggInfo objects further up the stack.
FossilOrigin-Name: cc1fffdeddf422404170fa163ab80372ae58b444d7012b2c164021b22
Avoid deleting expression nodes in the flattener code, as they may be referenced by AggInfo objects further up the stack.
FossilOrigin-Name: cc1fffdeddf422404170fa163ab80372ae58b444d7012b2c164021b221709b3e
show more ...
|
|
Revision tags: version-3.32.2, version-3.32.1, version-3.32.0 |
|
| #
0c76e892 |
| 10-Mar-2020 |
drh <[email protected]> |
Apply the correct affinity transformations when pulling values off of the
sorter index used for GROUP BY. Ticket [e0c2ad1aa8a9c691]
FossilOrigin-Name: 101f7dea75a203f1f3aa422a607ef701eb0901ba4d5e8d
Apply the correct affinity transformations when pulling values off of the
sorter index used for GROUP BY. Ticket [e0c2ad1aa8a9c691]
FossilOrigin-Name: 101f7dea75a203f1f3aa422a607ef701eb0901ba4d5e8d1075cd350454a61956
show more ...
|
|
Revision tags: version-3.31.1, version-3.31.0, version-3.30.1, version-3.30.0, version-3.29.0 |
|
| #
6bab6f2b |
| 09-May-2019 |
drh <[email protected]> |
Disable the optimization where a REAL value with no fractional part
is stored as an INTEGER when the integer uses as much space as the real
value it proposes to stand in for (8 bytes). This avoids c
Disable the optimization where a REAL value with no fractional part
is stored as an INTEGER when the integer uses as much space as the real
value it proposes to stand in for (8 bytes). This avoids corner cases
of comparing integers against real values that are beyond the resolution
of an IEEE 754 double. Fix for ticket [6c1d3febc00b22d457c78c2]
FossilOrigin-Name: 9b0915272f4d4052aa31e9297424a7db9a0234b676e8e2a44c3f2dc54236705a
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, 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, 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, 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, fts3-refactor, cvs-to-fossil-cutover, version-3.6.15, version-3.6.10 |
|
| #
24acd8f9 |
| 16-Jan-2008 |
danielk1977 <[email protected]> |
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)
FossilOrigin-Name: 3a289b6d28bcf399845586b15f100d7c3a78b550
|
| #
01874bfc |
| 13-Dec-2007 |
danielk1977 <[email protected]> |
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622)
FossilOrigin-Name: 2f88b9b3e3c9abc3ae4a5dcef82707dd
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622)
FossilOrigin-Name: 2f88b9b3e3c9abc3ae4a5dcef82707dd74f8aace
show more ...
|
| #
9245c243 |
| 20-Jun-2007 |
drh <[email protected]> |
Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099)
FossilOrigin-Name: 9581e7a4a4d74b08ce5380b49862957c804e46bb
|
| #
945498f3 |
| 24-Feb-2007 |
drh <[email protected]> |
Make sure that integer values are converted to real when pulled from
a REAL table column by GROUP BY. Ticket #2251. Also make sure default
values are correctly expanded. There may be other places
Make sure that integer values are converted to real when pulled from
a REAL table column by GROUP BY. Ticket #2251. Also make sure default
values are correctly expanded. There may be other places in the code
where this issue comes up - we need to look further. (CVS 3659)
FossilOrigin-Name: e11bbf174c5a2fa75e3d1dd450c8b2a18f40e4da
show more ...
|
| #
18e87cff |
| 11-Apr-2006 |
drh <[email protected]> |
Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173)
FossilOrigin-Name: d83e0230c0c4909cb035e266beffc0967526d9c1
|
| #
8a51256c |
| 14-Nov-2005 |
drh <[email protected]> |
Create separate affinities for INTEGER and REAL. (CVS 2766)
FossilOrigin-Name: ce06c123d0c5663dbaf263c2e0aaf5d9cdeb2ccd
|
| #
8df447f0 |
| 01-Nov-2005 |
drh <[email protected]> |
Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now
of type real, though an integer representation is still sometimes used
internally for efficiency. (CVS 2753)
FossilOrigin-Name:
Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now
of type real, though an integer representation is still sometimes used
internally for efficiency. (CVS 2753)
FossilOrigin-Name: e0d6f61c7de2c03b8fd17ef37cf1a0add36ee618
show more ...
|
| #
c2bd913a |
| 08-Sep-2005 |
drh <[email protected]> |
SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)
FossilOrigin-Name: 6281859425d39c11d82875301fefafad1f08416d
|
| #
97571957 |
| 08-Sep-2005 |
drh <[email protected]> |
Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674)
FossilOrigin-Name: 0c3e368d4766685b94a44f2c514e2dea806c297c
|
| #
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 ...
|
| #
495c09a4 |
| 01-Apr-2005 |
drh <[email protected]> |
Make the ORDER BY clause return equal elements in the same order they were
seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439)
FossilOrigin-Name: e8391491a68018406e
Make the ORDER BY clause return equal elements in the same order they were
seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439)
FossilOrigin-Name: e8391491a68018406e30c2a699a4cab9e0de092c
show more ...
|
| #
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
|
| #
ce2663cc |
| 11-Jun-2004 |
danielk1977 <[email protected]> |
Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569)
FossilOrigin-Name: 8d56118f64dbaf8c8006266fa7026f900a4a16bd
|
| #
5f3b4ab5 |
| 27-May-2004 |
drh <[email protected]> |
Remove the COPY command. (CVS 1477)
FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43
|
| #
736c22b8 |
| 21-May-2004 |
drh <[email protected]> |
Most sorting problems are fixed. Dead code has been removed. 3 test failures
remain but will be fixed by the new function API once it gets implemented. (CVS 1425)
FossilOrigin-Name: 3b55095e036d68
Most sorting problems are fixed. Dead code has been removed. 3 test failures
remain but will be fixed by the new function API once it gets implemented. (CVS 1425)
FossilOrigin-Name: 3b55095e036d68886d007239333bbf90acd15692
show more ...
|
| #
88eee38a |
| 31-Jan-2003 |
drh <[email protected]> |
Allow double-quoted strings as string constants in the IN operator. As a
side-efffect, allow the GROUP BY clause to refer to columns by their integer
column number. Ticket #237. (CVS 856)
FossilOr
Allow double-quoted strings as string constants in the IN operator. As a
side-efffect, allow the GROUP BY clause to refer to columns by their integer
column number. Ticket #237. (CVS 856)
FossilOrigin-Name: 187d9c405891e543fc706f8ddb41f3966a842214
show more ...
|
| #
c66c5a26 |
| 03-Dec-2002 |
drh <[email protected]> |
Allow an aggregate function in the HAVING clause even if no aggregates appear
in the result set. Ticket #187. (CVS 793)
FossilOrigin-Name: 33c6fd6b3dc271fa1f2d4500b4f76c736accefce
|
| #
68d2e591 |
| 04-Aug-2002 |
drh <[email protected]> |
Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot
use an index for sorting. It has to sort as a separate operation after
the GROUP BY is complete. (CVS 702)
FossilOrigin-Name:
Fix for ticket #131: When a SELECT contains a GROUP BY clause it cannot
use an index for sorting. It has to sort as a separate operation after
the GROUP BY is complete. (CVS 702)
FossilOrigin-Name: 18745c67acdf7ebec378f5538174117970e9f5cc
show more ...
|