v.25.10Improvement

Make function lag case insensitive

Make function lag case insensitive for compatibility with MySQL. #88322 (Lonny Kapelushnik).
The lag function has been made case insensitive to improve compatibility with MySQL.

Why it matters

This change solves the issue of case sensitivity differences between ClickHouse and MySQL for the lag function, providing a smoother migration experience and reducing potential errors when porting queries.

How to use it

Users can simply use the lag function as before in their queries without worrying about the case of the function name, ensuring consistent behavior with MySQL. No additional configuration is required.