JPQL doens't support ORDER BY UPPER(fieldname)
----------------------------------------------

                 Key: OPENJPA-1817
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1817
             Project: OpenJPA
          Issue Type: Improvement
            Reporter: Alexander Karpov
            Priority: Minor


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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to