Wrong Fields Mapping While Using SUM() And COALESCE() In Query List
(Doc ID 1572311.1)
Last updated on MARCH 26, 2019
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(e.projects,0) ) in the second SUM(..).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document