v.21.2Improvements

Improve MySQL Compatibility with Case Insensitivity and Aliases

Improve MySQL compatibility by making more functions case insensitive and adding aliases. #19387 (Daniil Kondratyev).
Improves MySQL compatibility by making more functions case insensitive and adding function aliases in ClickHouse.

Why it matters

This feature addresses incompatibilities between ClickHouse and MySQL by ensuring that function names are treated case insensitively and by providing aliases for functions, making it easier for users migrating from MySQL or working with MySQL-compatible queries to use ClickHouse without modifying their existing code significantly.

How to use it

Users can take advantage of improved MySQL compatibility automatically as function name case insensitivity and new aliases are enabled by default. Simply use MySQL-style function names in queries without worrying about case sensitivity.