/ History for test/aggnested.test
Login

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

History for test/aggnested.test

2020-06-09
17:45
[2f65ec81] part of check-in [16a41fa8] 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: [16a41fa8] user: dan branch: agg-context-fix, size: 8445)
13:17
[2c967760] part of check-in [04867cba] Persist AggInfo expressions before deleting them when omitting the LIMIT clause in a subquery. One possible fix for ticket [7c6d876f84e6e7e2]. (check-in: [04867cba] user: drh branch: tkt-7c6d876f84e6e7e2, size: 7687)
2019-08-31
20:13
[12106f07] part of check-in [d7680074] 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: [d7680074] user: drh branch: trunk, size: 7334)
2018-06-05
20:04
[18b00de0] part of check-in [dce2dfbe] 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: [dce2dfbe] user: dan branch: exp-agg-opt, size: 6555)
2016-04-14
19:29
[116ab835] part of check-in [129083bd] Work toward improving analysis and code generation for DISTINCT and aggregate queries. (check-in: [129083bd] user: drh branch: better-distinct-agg, size: 6455)
2014-09-15
14:46
[b35b4cd6] part of check-in [0bdf1a08] 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: [0bdf1a08] user: drh branch: trunk, size: 6555)
2012-11-02
19:08
[45c0201e] part of check-in [62ebfa74] Adding test cases for ticket [bfbf38e5e9956a] (check-in: [62ebfa74] user: drh branch: ticket-bfbf38e5e9, size: 6413)
2012-08-23
19:46
[0be144b4] part of check-in [00b1dc71] Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. (check-in: [00b1dc71] user: drh branch: nested-agg, size: 2106)
16:18
[6c1efa2e] part of check-in [3c3ffa90] Further improvements to the processing of nested aggregate queries. (check-in: [3c3ffa90] user: drh branch: nested-agg, size: 1096) Added