v.25.10New Feature
Add optimized case-insensitive variants of startsWith and
Added optimized case-insensitive variants ofstartsWithandendsWithfunctions:startsWithCaseInsensitive,endsWithCaseInsensitive,startsWithCaseInsensitiveUTF8, andendsWithCaseInsensitiveUTF8. #87374 (Guang Zhao).
Why it matters
These new functions solve the problem of performing case-insensitive prefix and suffix checks on strings more efficiently. They provide users with optimized alternatives to perform case-insensitive comparisons, improving performance and usability when filtering or querying text data without case sensitivity.How to use it
Use the new functionsstartsWithCaseInsensitive, endsWithCaseInsensitive, startsWithCaseInsensitiveUTF8, and endsWithCaseInsensitiveUTF8 in your SQL queries just like the existing startsWith and endsWith functions, but with case-insensitive behavior. For example:SELECT * FROM table WHERE startsWithCaseInsensitive(column, 'prefix');No special configuration or enabling is required; simply use these functions directly.