v.20.6Improvement

Supported MySQL SELECT DATABASE() and Added Integration Test

Official CH changelog text
Supported MySQL 'SELECT DATABASE()' #9336 2. Add MySQL replacement query integration test. #12314 (BohuTANG).
Added support for the MySQL function SELECT DATABASE() in ClickHouse.

Why it matters

This feature enables ClickHouse to recognize and handle the MySQL-specific SELECT DATABASE() statement, improving compatibility for users migrating or integrating MySQL queries. It allows seamless execution of queries that include this function without errors.

How to use it

Users can now run queries containing SELECT DATABASE() directly in ClickHouse without requiring any additional configuration or syntax changes.

Related resources

PreviousNext