SQLite

All files named ”test/aggnested.test”
Login

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)