v.18.14Improvement

Added Synonyms for LENGTH and CHARACTER_LENGTH; CONCAT Function Case-Sensitivity Adjusted

Added synonyms for the LENGTH and CHARACTER_LENGTH functions for compatibility. The CONCAT function is no longer case-sensitive. #3306
Added synonyms for the LENGTH and CHARACTER_LENGTH functions to improve compatibility and made the CONCAT function case-insensitive.

Why it matters

This feature enhances function compatibility by introducing synonyms for commonly used string length functions and improves usability by making the CONCAT function case-insensitive, thereby reducing errors caused by case mismatches and improving the user experience.

How to use it

Users can use the LENGTH and CHARACTER_LENGTH functions interchangeably as synonyms without any configuration changes. The CONCAT function now accepts any case variation, so usage remains the same but with improved flexibility.