sqldelight icon indicating copy to clipboard operation
sqldelight copied to clipboard

Not working LOWER OR COLLATE NOCASE

Open v1rus-dev opened this issue 1 year ago • 3 comments

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

v1rus-dev avatar Oct 11 '23 15:10 v1rus-dev