Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/aggnested.test
2024-02-29
| ||
13:44 | [4dfdbfab10] part of check-in [2266086cf0] Add the ability to DROP one or more objects of the same class in a single statement by listing the objects as multiple arguments to the DROP command. (check-in: [2266086cf0] user: drh branch: multi-drop, size: 12262) | |
2023-12-16
| ||
10:50 | [610b0ce2c3] part of check-in [2c7ef4b4d2] New test case based on Chromium bug report 1511689. (check-in: [2c7ef4b4d2] user: drh branch: trunk, size: 12406) | |
2023-12-15
| ||
21:39 | [e1977bdc0a] part of check-in [122cd0bada] 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. (check-in: [122cd0bada] user: drh branch: branch-3.43, size: 10758) | |
2023-11-14
| ||
14:50 | [ce85a6af7d] part of check-in [6f9eed826f] Fix another obscure problem with nested aggregates. dbsqlfuzz 04408efc51. This might be a better fix than the one at [4a587c3492faa994]. (check-in: [6f9eed826f] user: dan branch: trunk, size: 11909) | |
2023-11-02
| ||
21:02 | [7929208e17] part of check-in [4470f657d2] 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 post c9970a37ed. (check-in: [4470f657d2] user: dan branch: trunk, size: 10748) | |
2023-10-20
| ||
20:19 | [2e738bfe29] 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: 9585) | |
2022-04-11
| ||
18:54 | [7269d07ac8] part of check-in [bdd1499c0f] New test cases added. (check-in: [bdd1499c0f] user: drh branch: right-join, size: 9595) | |
2021-09-30
| ||
21:42 | [a755b9e42c] part of check-in [86f9c07a4f] Adjust 3 query result expectations to reflect changed group_concat() behavior with varying separator. (check-in: [86f9c07a4f] user: larrybr branch: group_concat_varsep, size: 9378) | |
2021-07-20
| ||
14:57 | [cc47afa5e1] part of check-in [1e35cc6d5c] 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. (check-in: [1e35cc6d5c] user: dan branch: trunk, size: 9378) | |
2020-06-09
| ||
17:45 | [2f65ec8132] part of check-in [16a41fa8c4] 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. (check-in: [16a41fa8c4] user: dan branch: agg-context-fix, size: 8445) | |
13:17 | [2c967760a9] part of check-in [04867cba97] Persist AggInfo expressions before deleting them when omitting the LIMIT clause in a subquery. One possible fix for ticket [7c6d876f84e6e7e2]. (check-in: [04867cba97] user: drh branch: tkt-7c6d876f84e6e7e2, size: 7687) | |
2019-08-31
| ||
20:13 | [12106f0748] part of check-in [d768007473] Improvements to the algorithm that determines which SELECT in a sequence of nested SELECT statements that an aggregate function belongs to. This resolves an issue identified by dbsqlfuzz. (check-in: [d768007473] user: drh branch: trunk, size: 7334) | |
2018-06-05
| ||
20:04 | [18b00de006] part of check-in [dce2dfbe15] Calculate non-aggregate expressions in the SELECT list of an aggregate query that does not use min() or max() once per group, instead of once per row visited. (check-in: [dce2dfbe15] user: dan branch: exp-agg-opt, size: 6555) | |
2016-04-14
| ||
19:29 | [116ab8359b] part of check-in [129083bd5e] Work toward improving analysis and code generation for DISTINCT and aggregate queries. (check-in: [129083bd5e] user: drh branch: better-distinct-agg, size: 6455) | |
2014-09-15
| ||
14:46 | [b35b4cd69f] part of check-in [0bdf1a086b] Do not flatten aggregate subqueries that contain min() or max() functions so that if the min()/max() are discarded by the outer query, they still function and cause non-aggregate expression to be evaluated on the minimal or maximal row. (check-in: [0bdf1a086b] user: drh branch: trunk, size: 6555) | |
2012-11-02
| ||
19:08 | [45c0201e28] part of check-in [62ebfa7476] Adding test cases for ticket [bfbf38e5e9956a] (check-in: [62ebfa7476] user: drh branch: ticket-bfbf38e5e9, size: 6413) | |
2012-08-23
| ||
19:46 | [0be144b453] part of check-in [00b1dc71be] Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. (check-in: [00b1dc71be] user: drh branch: nested-agg, size: 2106) | |
16:18 | Added: [6c1efa2ed9] part of check-in [3c3ffa901f] Further improvements to the processing of nested aggregate queries. (check-in: [3c3ffa901f] user: drh branch: nested-agg, size: 1096) | |