Using same Parameter for LIKE and = the equals check will always fail [DATAJPA-1627]

[spring-projects-issues]

jonasblumer opened DATAJPA-1627 and commented

Using the same parameter for an equals comparison and a LIKE comparison will always pre- and append % to the parameter making the equals comparison always fail.

@Query("SELECT * FROM User u WHERE u.name = :term OR u.username LIKE %:term%") List<Users> getUsers(final String term);

The parameter, when calling this with getUsers("Jonas") and checking SQL logging, is %Jonas%, which means the = :term check will always fail

---

No further details from DATAJPA-1627

[lorentzforces]

I came across this behavior recently and I'd like to contribute a fix for it (should a fix be desired). @schauder are you currently engaged on this issue, and would you mind if I took it?

[schauder]

A fix for this would be very welcome.

[gregturn]

@lorentzforces If you're still interested, I'd suggest beginning with writing a simple test case that exposes this issue then working your way toward a solution.

[gregturn]

Superceded by #3041.