Morph MORPH
SIGN IN SIGN UP
dhruvhead / sqlite UNCLAIMED
0 0 244 C

COMMITS

/ test/aggnested.test
autosetup
December 16, 2023
D
New test case based on Chromium bug report 1511689.
drh committed
5f3dd86
November 14, 2023
D
Fix another obscure problem with nested aggregates. dbsqlfuzz 04408efc51.
dan committed
d928e78
November 2, 2023
D
Fix a spurious "misuse of aggregate function" error that could occur when an aggregate function was used within the FROM clause of a sub-select of the select that owns the aggregate. e.g. "SELECT (SELECT x FROM (SELECT sum(t1.a) AS x)) FROM t1". [forum:/forumpost/c9970a37ed | Forum post c9970a37ed].
dan committed
5e4233a
October 20, 2023
D
Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility
drh committed
d5e040b
April 11, 2022
D
New test cases added.
drh committed
ec27077
July 20, 2021
D
Avoid a malfunction that could occur if the same correlated column reference appears in both the GROUP BY and the HAVING clause of a sub-select. dbsqlfuzz a779227f721a834df95f4f42d0c31550a1f8b8a2.
dan committed
d59f983
June 9, 2020
D
Ensure that aggregate functions that (a) are part of SELECT statements with no FROM clause and (b) have one or more scalar sub-selects as arguments are assigned to the correct aggregate context.
dan committed
ed41a96
August 31, 2019
D
Improvements to the algorithm that determines which SELECT in a sequence
drh committed
80f6bfc
June 5, 2018
D
Calculate non-aggregate expressions in the SELECT list of an aggregate query
dan committed
280c894
September 15, 2014
D
Do not flatten aggregate subqueries that contain min() or max() functions
drh committed
9588ad9
November 2, 2012
D
Adding test cases for ticket [bfbf38e5e9956a]
drh committed
e0b2d5d
August 23, 2012
D
Add test cases and fix bugs associated with the previous check-in
drh committed
ed551b9
D
Further improvements to the processing of nested aggregate queries.
drh committed
030796d