v.23.2Improvement
Add MySQL Compatibility for SHOW ENGINES Query Support
Add support for SHOW ENGINES query for MySQL compatibility. #45859 (Filatenkov Artur).Why it matters
This feature addresses the need for better interoperability with MySQL tools and workflows by enabling theSHOW ENGINES query. It helps users identify available table engines in ClickHouse similarly to MySQL, simplifying migration and integration processes.How to use it
Users can execute theSHOW ENGINES query directly in ClickHouse, just like in MySQL, to list supported table engines. No additional configuration is required.