v.20.11Improvement
Enhance minMap and maxMap to include zero values in results, addressing issue #16087.
Make the behaviour ofminMapandmaxMapmore desireable. It will not skip zero values in the result. Fixes #16087. #16631 (Ildus Kurbangaliev).
Why it matters
Previously, theminMap and maxMap functions would skip zero values when calculating their results, which could lead to inaccurate outputs. This fix ensures that zero values are correctly considered, providing more accurate and expected aggregation results.How to use it
To benefit from this improvement, users just need to upgrade to the ClickHouse version including this fix. No changes to query syntax or function usage are required; the behavior ofminMap and maxMap will automatically include zero values in their computations.