v.23.6New Feature

Support for All Data Types in Transform Function and CASE Statement

Official CH changelog text
The function transform as well as CASE with value matching started to support all data types. This closes #29730. This closes #32387. This closes #50827. This closes #31336. This closes #40493. #51351 (Alexey Milovidov).
The transform function and CASE expressions with value matching now support all data types in ClickHouse.

Why it matters

Previously, transform and CASE with value matching had limitations on the data types they could handle. This feature removes those restrictions, allowing users to apply these constructs to any data type, thereby increasing versatility and simplifying query logic.

How to use it

Users can directly use the вфеф function and CASE expressions with value matching on columns or expressions of any data type without additional configuration.

Related resources

PreviousNext