sqldelight
sqldelight copied to clipboard
Not working LOWER OR COLLATE NOCASE
SQLDelight Version
2.0.0-rc02
Application Operating System
iOS
Describe the Bug
I have some bug with code below:
getPointBySearchString: SELECT * FROM point WHERE shopId LIKE '%' || :searchStr || '%' OR name LIKE '%' || :searchStr || '%' OR street LIKE '%' || :searchStr || '%' COLLATE NOCASE;
OR
getPointBySearchString: SELECT * FROM point WHERE LOWER(shopId) LIKE '%' || LOWER(:searchStr) || '%' OR LOWER(name) LIKE '%' || LOWER(:searchStr) || '%' OR LOWER(street) LIKE '%' || LOWER(:searchStr) || '%';
This code works on android but doesn't work on iOS. I use it for search with case ignore.
Stacktrace
No response