v.23.11Improvement

Function concat now accepts a single argument for consistency with MySQL

Official CH changelog text
Function concat can now be called with a single argument, e.g., SELECT concat('abc'). This makes its behavior more consistent with MySQL's concat implementation. #57000 (Serge Klochkov).
concat function now supports a single argument allowing calls like SELECT concat('abc'), aligning its behavior with MySQL's implementation.

Why it matters

This feature resolves inconsistencies in string concatenation by enabling the concat function to accept a single argument. It improves compatibility for users migrating from MySQL or writing cross-database queries by ensuring similar function behavior.

How to use it

Simply call the concat function with one argument as follows:

SELECT concat('abc')

No additional configuration or settings are required.

Related resources

PreviousNext