v.23.6New Feature

Add Setting for MySQL Type Display in SHOW COLUMNS Statement

Official CH changelog text
Add a new setting named use_mysql_types_in_show_columns to alter the SHOW COLUMNS SQL statement to display MySQL equivalent types when a client is connected via the MySQL compatibility port. #49577 (Thomas Panetti).
Added a new setting use_mysql_types_in_show_columns that modifies the SHOW COLUMNS SQL statement to display MySQL equivalent column types when connected through the MySQL compatibility port.

Why it matters

This feature addresses the need for better MySQL compatibility by adjusting the data types shown in SHOW COLUMNS to match MySQL's type conventions. It improves usability and integration for users connecting to ClickHouse using MySQL clients or tools expecting MySQL-style type information.

How to use it

To enable this feature, set the use_mysql_types_in_show_columns setting to 1 in the session or user profile when connected via the MySQL compatibility port. This will cause the SHOW COLUMNS statement to return column types in MySQL format.

Related resources

PreviousNext