[OPENJPA-764] Query parsing error with IN expression and String functions such as UPPER()

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0-M2
• Assignee: Unassigned
• Reporter: Pinaki Poddar
• Created: 10/Nov/08 20:57
• Updated: 09/Mar/10 18:31
• Resolved: 10/Nov/08 21:36

Description

Following JPQL query causes parse exception
"select a from A a where UPPER(a.name) IN (:list)"
while the following does not
"select a from A a where a.name IN (:list)"

Parse tree definition seems to be the cause.

Originally reported in Nabble mailing list post[1]

[1] http://n2.nabble.com/ParseException-when-using-UPPER-Keyword-with-an-IN-CLAUSE-tc1480819.html