Last updated on OCTOBER 08, 2013
Applies to:Oracle TopLink - Version 188.8.131.52.0 to 184.108.40.206.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.
When using function SUM() and COALESCE() in JPQL's query as the following :
The first SUM(..) and second SUM(..) is repeated which is not in the original JPQL. And the mapping in entity is correct.
Make a minor change in above JPQL, like change one of the operators from "+" to "-" in function SUM() and you get correct translated SQL.
The JPQL will also be translated correctly if you remove one of the item( like COALESCE(vu.ladenLoadTeu,0) ) in the second SUM(..).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms