v.25.6Improvement

At the beginning of 2024, prefer_column_name_to_alias was

At the beginning of 2024, prefer_column_name_to_alias was hardcoded to true for MySQL handler because the new analyzer was not enabled by default. Now, it can be unhardcoded. #80916 (Yarik Briukhovetskyi).
The hardcoded setting prefer_column_name_to_alias for the MySQL handler in ClickHouse has been made configurable, allowing users to enable or disable it as needed.

Why it matters

Previously, the prefer_column_name_to_alias setting was forced to true for the MySQL handler because the new query analyzer was not enabled by default. This change provides flexibility by unhardcoding the setting, enabling better compatibility and control over column name versus alias preference in query results.

How to use it

Users can now configure the prefer_column_name_to_alias setting explicitly when using the MySQL handler by adjusting the related user settings or configuration files to either true or false according to their preference.