Support case-insensitive when select where

StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.

https://starrocks.io

Apache License 2.0

8.99k stars 1.81k forks source link

Support case-insensitive when select where #45264

Open mzgs9988 opened 6 months ago

mzgs9988 commented 6 months ago

Enhancement

I'm using Realtime synchronization from MySQL，when i query with sql: select * from xxx where name like '%a%' on mysql，the result returned name with 'aAa', case-insensitive，but when i query in starrocks，the result is empty, case-sensitive，how can i resolve this problem？Thank you ! starrocks version: 3.0

xyan3880 commented 6 months ago

mysql uses collation/charset of the value/column for case sensitivity .

Unfortunately I don't think starrocks supports it now, so you can try "ilike()" function, which is undocumented so far.

github-actions[bot] commented 4 days ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!