Amol Bhosale created OPENJPA-2468:
-------------------------------------
Summary: JPQL Functions (CONCAT, TRIM, etc) doesnt works with IN
clause
Key: OPENJPA-2468
URL: https://issues.apache.org/jira/browse/OPENJPA-2468
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Reporter: Amol Bhosale
I was triying to use functions in my query as per the documentations however
was getting errors when Functions are used with IN clause, same functions do
work with comparator!!
Consider 2 entities
Employee[empId, lastName, firstName, mgrID] and
Manager[mgrId, empId]
Failing query
Select e from Employee e where CONCAT(firstName, lastName) IN ('First1Last1',
'First2Last2')
working Query
Select e from Employee e where CONCAT(firstName, lastName) = 'First1Last1' OR
CONCAT(firstName, lastName) = 'First2Last2'
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
