v.24.3Improvement

String Types and Enums Now Usable in Arrays, UNION Queries, and Conditional Expressions

Official CH changelog text
String types and Enums can be used in the same context, such as: arrays, UNION queries, conditional expressions. This closes #60726. #60727 (Alexey Milovidov).
String types and Enums can now be used interchangeably in contexts such as arrays, UNION queries, and conditional expressions in ClickHouse.

Why it matters

This feature resolves compatibility issues by allowing seamless use of String types and Enums together, improving query flexibility and preventing type conflicts in operations involving arrays, UNIONs, and conditionals.

How to use it

Users can directly use String types and Enums together in arrays, UNION queries, and conditional expressions without additional conversion or casting. No special configuration is required; the compatibility is built-in.

Related resources

PreviousNext