v.25.10New Feature

Add optimized case-insensitive variants of startsWith and

Added optimized case-insensitive variants of startsWith and endsWith functions: startsWithCaseInsensitive, endsWithCaseInsensitive, startsWithCaseInsensitiveUTF8, and endsWithCaseInsensitiveUTF8. #87374 (Guang Zhao).
Added optimized case-insensitive string matching functions: startsWithCaseInsensitive, endsWithCaseInsensitive, startsWithCaseInsensitiveUTF8, and endsWithCaseInsensitiveUTF8.

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 functions startsWithCaseInsensitive, 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.