v.18.14Improvement
Added Synonyms for LENGTH and CHARACTER_LENGTH; CONCAT Function Case-Sensitivity Adjusted
Added synonyms for theLENGTHandCHARACTER_LENGTHfunctions for compatibility. TheCONCATfunction is no longer case-sensitive. #3306
Why it matters
This feature enhances function compatibility by introducing synonyms for commonly used string length functions and improves usability by making theCONCAT function case-insensitive, thereby reducing errors caused by case mismatches and improving the user experience.How to use it
Users can use theLENGTH 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.