v.24.1Improvement

MySQL Interface Now Compatible with SHOW WARNINGS Queries

Official CH changelog text
MySQL interface gained compatibility with SHOW WARNINGS/SHOW COUNT(*) WARNINGS queries, though the returned result is always an empty set. #58929 (Serge Klochkov).
ClickHouse's MySQL interface now supports the SHOW WARNINGS and SHOW COUNT(*) WARNINGS queries, returning an empty result set.

Why it matters

This feature improves compatibility with MySQL by recognizing the SHOW WARNINGS and SHOW COUNT(*) WARNINGS commands in the MySQL interface, ensuring applications expecting these queries do not encounter errors, even though no actual warnings are produced.

How to use it

Users can execute the SHOW WARNINGS or SHOW COUNT(*) WARNINGS queries through the MySQL interface in ClickHouse as they would in MySQL. The queries will complete successfully but will return an empty set.

Related resources

PreviousNext