v.24.11Experimental Feature

Forbid Dynamic/Variant Types in Min/Max Functions

Official CH changelog text
Forbid Dynamic/Variant types in min/max functions to avoid confusion. #71761 (Pavel Kruglov).
Forbid the use of Dynamic and Variant data types in min and max aggregate functions to prevent confusion and potential misuse.

Why it matters

The feature addresses ambiguity and unexpected behavior that can arise when using Dynamic or Variant types with min and max functions. By forbidding these types, it ensures more predictable and consistent query results for users.

How to use it

This change is enforced automatically in ClickHouse from the specified version onward. Users should avoid using Dynamic or Variant columns as arguments to min and max functions in their queries.

Related resources

PreviousNext