New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support case-insensitive when select where #45264
Labels
type/enhancement
Make an enhancement to StarRocks
Comments
mzgs9988
changed the title
ignore lower case when select where
case-insensitive when select where
May 8, 2024
mzgs9988
changed the title
case-insensitive when select where
Support case-insensitive when select where
May 8, 2024
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. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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
The text was updated successfully, but these errors were encountered: