v.21.1Improvements

Implement transform function with Decimal arguments

Implement function transform with Decimal arguments. #31839 (李帅).
Implemented the transform function to support Decimal arguments.

Why it matters

The feature adds compatibility for Decimal data types in the transform function, enabling users to perform conditional transformations on Decimal columns. This enhancement broadens the function’s usability for precise numeric data processing.

How to use it

Use the transform function with Decimal type arguments in the same way as with other supported types. For example, you can write queries like SELECT transform(decimal_column, [condition_values], [result_values], default_value) FROM table.