IgnoreCase works only if a String property can be resolved to a column

[hakandilek]

Hello everyone,

I have the following select query using R2dbcEntityTemplate:

template.select(Book.class)
        .matching(query(where("TITLE").like("%" + matchingTitle + "%").ignoreCase(true)))
        .all();

When I run this, it produces the following query:

SELECT T_BOOK.* FROM T_BOOK WHERE T_BOOK.TITLE LIKE UPPER($1) {1: '%title%'}

I would expect that T_BOOK.TITLE would also be wrapped with the UPPER() function like the following:

SELECT T_BOOK.* FROM T_BOOK WHERE UPPER(T_BOOK.TITLE) LIKE UPPER($1) {1: '%title%'}

but it doesn't. In this case it does not produce real case-insensitive queries.

[mp911de]

Our QueryMapper validates ignore-case queries against the domain model. If the underlying property is a String, then we're wrapping the column name with UPPER(…).

Omitting that check seems to fix the issue.

[hakandilek]

@mp911de thanks for the fix!

[ilkerkocatepe]

Hello everyone, I'm sorry for writing an old issue, but I didn't want to create new one.
I have a problem about Turkish chars.
For instance; "ilker" is the query parameter and the name in db is "İlker". These don't match.
Is there a way to use LOWER instead UPPER? I thought this will help me.