[OPENJPA-2468] JPQL Functions (CONCAT, TRIM, etc) doesnt works with IN clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Component/s: jdbc
• Assignee: Unassigned
• Reporter: Amol Bhosale
• Created: 06/Jan/14 07:32
• Updated: 06/Jan/14 14:36
• Resolved: 06/Jan/14 14:36

Description

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'