Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
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 | Added: [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) | |