Closed lwz9103 closed 3 months ago
Difference between sum and sum0: If agg data is empty, sum(nullable_col) return \N, but sum0 return 0. which code take effect:
AggregateFunctionProperties properties = { .returns_default_when_only_null = true, .is_order_dependent = false }
ClickHouse plan difference:
Changelog category (leave one):
Documentation entry for user-facing changes
Difference between sum and sum0: If agg data is empty, sum(nullable_col) return \N, but sum0 return 0. which code take effect:
ClickHouse plan difference:![image](https://github.com/Kyligence/ClickHouse/assets/23639010/f156aa67-af13-44f3-8297-ffe67b47b480)