v.23.7Improvement

Improve MySQL Compatibility for SHOW INDEX Statement

Official CH changelog text
Improve MySQL compatibility of the statement SHOW INDEX. #51796 (Robert Schulze).
Improves the MySQL compatibility of the SHOW INDEX statement in ClickHouse.

Why it matters

This feature enhances ClickHouse's support for the SHOW INDEX statement to align with MySQL's behavior. This improvement facilitates easier migration and interoperability for users transitioning from MySQL or working in environments supporting multiple database engines.

How to use it

Users can simply execute the SHOW INDEX statement as they would in MySQL. The statement now behaves more consistently with MySQL's output format without requiring additional configuration.

Related resources

PreviousNext