Case-sensitive issue in filter operation

[ajewelbd]

Hi,
We are facing case-sensitive issue while filter from ui5.
Suppose, a column value is stored as 'Flush'. If we filter from ui5 'Fl', then we get the data.
But if we write 'fl', we get no data.

Best regards.
Md. Ashraful Alam

[gregorwolf]

Hi @ajewelbd,

to help finding a solution it would be great if you could create a pull request that shows your issue in a new test request that you add to:

tests/assets/cap-proj/rest-client-test/beers.http

To replicate the behaviour of your UI5 app it's the best to look at the Network tab in the developer tools.

Best Regards
Gregor

[ajewelbd]

Hi @gregorwolf,
Thanks a lot for reply.

URLs:
Working: http:https://localhost:40004/my-service/Customers?$filter=contains(name,'Fl')

Nor working: http:https://localhost:40004/my-service/Customers?$filter=contains(name,'fl')

Thanks.

[gregorwolf]

Have you tested if it works with sqlite?

[ajewelbd]

Yah, It is properly working in SQLite, But, not in postgre.

[gregorwolf]

Can you provide also the output when you run the cds-pg variant with:

export DEBUG=cds-pg

and when running with sqlite use:

export DEBUG=sqlite

[ajewelbd]

Hi.

I think i found the issue. In postgre LIKE operator is case-sensitive.
But, if we use ILIKE then it is woks fine.

If I am not wrong, in cds-pg 'LIKE' operator is used.

Thanks.

[gregorwolf]

Would be great if you can contribute the improvement via a pull request.