Wrong Fields Mapping While Using SUM() And COALESCE() In Query List
Last updated on SEPTEMBER 21, 2017
Applies to:Oracle TopLink - Version 22.214.171.124.0 to 126.96.36.199.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms