v.23.12Improvement

Function substring Now Supports Enum Types for Improved Compatibility with Third-Party Tools

Official CH changelog text
The function substring (aliases: substr, mid) can now be used with Enum types. Previously, the first function argument had to be a value of type String or FixedString. This improves compatibility with 3rd party tools such as Tableau via MySQL interface. #57277 (Serge Klochkov).
The substring function (including its aliases substr and mid) now supports Enum types as input. Previously, it only accepted String or FixedString types.

Why it matters

This enhancement addresses compatibility issues with third-party tools like Tableau when connecting through the MySQL interface, enabling broader and more flexible use of the substring function with enumerated types.

How to use it

You can now apply the substring (or substr, mid) function directly to Enum type columns or values in your queries just as you would with String types. No additional configuration or enablement is required.

Related resources

PreviousNext