v.22.11Improvement

Modify INFORMATION_SCHEMA for MySQL Compatibility in ClickHouse

Official CH changelog text
Modify the INFORMATION_SCHEMA tables in a way so that ClickHouse can connect to itself using the MySQL compatibility protocol. Add columns instead of aliases (related to #9769). It will improve the compatibility with various MySQL clients. #43198 (Filatenkov Artur).
Enhanced INFORMATION_SCHEMA tables for improved MySQL compatibility by adding explicit columns instead of aliases.

Why it matters

This feature enables ClickHouse to connect to itself using the MySQL compatibility protocol more effectively. By modifying the INFORMATION_SCHEMA tables and adding explicit columns, this update improves compatibility with various MySQL clients that rely on these schema details.

How to use it

No special configuration is required. When using ClickHouse's MySQL compatibility protocol, users will benefit from improved compatibility automatically through the enhanced INFORMATION_SCHEMA tables exposing explicit columns.

Related resources

PreviousNext