v.23.5Improvement

Server to Support SQL_* Settings as No-Ops for MySQL Compatibility

Official CH changelog text
The server will allow using the SQL_* settings such as SQL_AUTO_IS_NULL as no-ops for MySQL compatibility. This closes #49927. #50013 (Alexey Milovidov).
ClickHouse now supports SQL_* settings such as SQL_AUTO_IS_NULL as no-ops to improve MySQL compatibility.

Why it matters

This feature addresses compatibility issues by recognizing MySQL-specific SQL_* settings without affecting ClickHouse behavior. It allows applications relying on MySQL client settings to interact with ClickHouse more seamlessly.

How to use it

Users can use MySQL client settings like SQL_AUTO_IS_NULL without impacting ClickHouse. These settings are accepted as no-ops automatically, requiring no changes to queries or server configuration.

Related resources

PreviousNext