mysema/querydsl — Issue #98: SQL/JPA 2.3.1 with PostgreSQL wrong Escape
Author: thackel
Created: 2012-02-10 16:05:33+00:00
State: open

2.3.1 introduced some new functionality regarding escaping.
This breaks queries for Postgresql 8.4.x/9.0.x.

So

EntityPathBase.someStringField.containsIgnoreCase(searchString)

produces SQL like:

select * from FOO foo where lower(foo.bar like ? escape '\')

This does not execute within PostgreSQL, it needs double backslashes.