SQLite

All files named ”test/select3.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/select3.test

2025-04-10
10:18
[152ce3978c] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 10912)
2023-10-20
20:19
[180223af31] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 10916)
2023-06-09
13:08
[398ba6069f] part of check-in [f587891134] Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: [f587891134] user: drh branch: newbie-safe-aggregates, size: 11592)
2022-07-26
15:39
[8d04b66df7] part of check-in [2909f36bfb] Add test cases related to fix [e717e029]. (check-in: [2909f36bfb] user: dan branch: flatten-left-join, size: 10917)
2022-07-25
14:05
[054b155a4b] part of check-in [40d0880720] 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. (check-in: [40d0880720] user: drh branch: flatten-left-join, size: 9676)
11:19
[9f7910cbaa] part of check-in [dbe522b011] If the LHS of a LEFT JOIN is flattened into an aggregate parent query, avoid executing OP_IfNullRow on an unopened cursor by disallowing the index-only optimization. (Later:) Does not work if automatic indexes are disabled. (check-in: [dbe522b011] user: dan branch: nonworking-flatten-left-join, size: 9462)
2022-07-01
21:03
[ce4f78bbc8] part of check-in [566b7842ee] Do not attempt the OP_Count optimization on queries with HAVING clauses. This fixes a problem exposed by [2cf373b10c9bc4cb]. (check-in: [566b7842ee] user: dan branch: trunk, size: 8496)
2022-06-21
13:41
[399a0b23f8] part of check-in [9322a7c21f] 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 post 1a7fea4651. (check-in: [9322a7c21f] user: drh branch: trunk, size: 8306)
2020-06-13
21:24
[c49fbb7589] part of check-in [cc1fffdedd] Avoid deleting expression nodes in the flattener code, as they may be referenced by AggInfo objects further up the stack. Ticket [e367f31901ea8700] (check-in: [cc1fffdedd] user: dan branch: trunk, size: 8392)
2020-03-10
11:50
[ddd1bc6d0c] part of check-in [101f7dea75] Apply the correct affinity transformations when pulling values off of the sorter index used for GROUP BY. Ticket [e0c2ad1aa8a9c691] (check-in: [101f7dea75] user: drh branch: trunk, size: 8187)
2019-05-09
17:10
[3905450067] part of check-in [9b0915272f] 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] (check-in: [9b0915272f] user: drh branch: trunk, size: 7969)
2008-01-16
18:20
[2ce595f8fb] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 6990)
2007-12-13
07:58
[7f99c0d406] part of check-in [2f88b9b3e3] Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) (check-in: [2f88b9b3e3] user: danielk1977 branch: trunk, size: 6992)
2007-06-20
12:18
[47439f2886] part of check-in [9581e7a4a4] Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099) (check-in: [9581e7a4a4] user: drh branch: trunk, size: 6998)
2007-02-24
11:52
[2d473f45c5] part of check-in [e11bbf174c] 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) (check-in: [e11bbf174c] user: drh branch: trunk, size: 6999)
2006-04-11
14:16
[33c78663e6] part of check-in [d83e0230c0] Allow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173) (check-in: [d83e0230c0] user: drh branch: trunk, size: 6337)
2005-11-14
22:29
[8fece41cd8] part of check-in [ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123d0] user: drh branch: trunk, size: 6332)
2005-11-01
15:48
[3cb5f742d6] part of check-in [e0d6f61c7d] 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) (check-in: [e0d6f61c7d] user: drh branch: trunk, size: 6314)
2005-09-08
20:37
[576df1a5cc] part of check-in [6281859425] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [6281859425] user: drh branch: trunk, size: 6328)
12:57
[551e25e97b] part of check-in [0c3e368d47] Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) (check-in: [0c3e368d47] user: drh branch: trunk, size: 6327)
10:37
[f8372ca3e9] part of check-in [21adf4bd99] 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) (check-in: [21adf4bd99] user: drh branch: trunk, size: 6028)
2005-04-01
10:47
[44dccad96a] part of check-in [e8391491a6] 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) (check-in: [e8391491a6] user: drh branch: trunk, size: 6032)
2004-08-20
18:34
[9de435aa84] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 6029)
2004-06-11
13:19
[ab2e583154] part of check-in [8d56118f64] Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569) (check-in: [8d56118f64] user: danielk1977 branch: trunk, size: 5993)
2004-05-27
17:22
[f8ff60d98c] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 5985)
2004-05-21
02:14
[9779f01f68] part of check-in [3b55095e03] 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) (check-in: [3b55095e03] user: drh branch: trunk, size: 6018)
2003-01-31
17:16
[445a1a3dde] part of check-in [187d9c4058] 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) (check-in: [187d9c4058] user: drh branch: trunk, size: 6004)
2002-12-03
02:34
[ba35d6611e] part of check-in [33c6fd6b3d] Allow an aggregate function in the HAVING clause even if no aggregates appear in the result set. Ticket #187. (CVS 793) (check-in: [33c6fd6b3d] user: drh branch: trunk, size: 5243)
2002-08-04
00:52
[3e98cec10e] part of check-in [18745c67ac] 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) (check-in: [18745c67ac] user: drh branch: trunk, size: 5107)
2002-01-22
14:11
[9469c33225] part of check-in [035984a5b0] Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) (check-in: [035984a5b0] user: drh branch: trunk, size: 3969)
03:13
[3a053d8fd2] part of check-in [3684beab0f] The right-hand side of an AS in a SELECT can be used within expressions of the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350) (check-in: [3684beab0f] user: drh branch: trunk, size: 3820)
2001-09-16
00:13
[5e1fe8e5a4] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 3256)
2000-06-08
15:10
[a9234b8424] part of check-in [61c381e7e6] :-) (CVS 81) (check-in: [61c381e7e6] user: drh branch: trunk, size: 3799)
2000-06-06
18:00
Added: [73ae8c7b80] part of check-in [a8fa6719d5] :-) (CVS 59) (check-in: [a8fa6719d5] user: drh branch: trunk, size: 3369)