This issue looks the same as
[https://hibernate.atlassian.net/browse/HHH-10226]
but I'm getting a different error :
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: record = bytea
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
The test case is the same:
{{ String queryTest = "select customer from CustomerEntity customer where (customer.fistname, customer.lastname) in (:pairsList)";
List<Object[]> values = new ArrayList<>();
values.add(new Object[]
{"firstname1", "lastname1"}
);
values.add(new Object[]
{"firstname2", "lastname2"}
);
Query q = em.createQuery(queryTest);
q.setParameter("pairsList", values);
return q.getResultList();}}
If I change the query to
String queryTest = "select customer from CustomerEntity customer where (customer.fistname, customer.lastname) in (('a','b'), ('c','d'))";
it works, but it is not dynamic. |
|