[OPENJPA-1817] JPQL doens't support ORDER BY UPPER(fieldname)

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Alexander Karpov
• Created: 28/Sep/10 10:03
• Updated: 21/Jan/14 20:16

Description

I tried to solve it myself

I have changed
\openjpa\openjpa-kernel\src\main\jjtree\org\apache\openjpa\kernel\jpql\JPQL.jjt
void orderby_extension() #ORDERBYEXTENSION : { }
{
aggregate_select_expression()
}
to
void orderby_extension() #ORDERBYEXTENSION : { }
{
aggregate_select_expression() | upper()
}

But afraid that it might break any other cases.

Issue Links

• blocks: JUDDI-785 find with CASE_INSENSITIVE_SORT throws JPA exception
• is related to: JUDDI-785 find with CASE_INSENSITIVE_SORT throws JPA exception