v.23.11Improvement

Function concat now supports arbitrary argument types, aligning with MySQL behavior

Official CH changelog text
Functionconcat now supports arbitrary argument types (instead of only String and FixedString arguments). This makes it behave more similar to MySQL concat implementation. For example, SELECT concat('ab', 42) now returns ab42. #56540 (Serge Klochkov).
concat function now supports arbitrary argument types, not limited to String and FixedString, aligning its behavior closer to MySQL's concat.

Why it matters

This enhancement allows users to concatenate values of different data types without explicit type conversion, simplifying queries and improving usability by producing results similar to MySQL's concat function.

How to use it

Simply use the concat function with any argument types in your queries. For example:

SELECT concat('ab', 42)


will return ab42 without requiring manual casting.

Related resources

PreviousNext