DB2 ABS Casting problem
-----------------------
Key: OPENJPA-321
URL: https://issues.apache.org/jira/browse/OPENJPA-321
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Affects Versions: 0.9.7
Reporter: Kevin Sutter
Assignee: Teresa Kan
Fix For: 1.0.0
Via the JPA TCK running against DB2, we found the following problem with
casting and the ABS function:
Instead of generating:
..WHERE (CAST(t0.TOTALPRICE AS DOUBLE) > CAST(ABS(?) AS DOUBLE))
We need to generate:
..WHERE (CAST(t0.TOTALPRICE AS DOUBLE) > ABS(CAST(? AS DOUBLE))
While doing a bit more investigation we are finding similar problems with other
function expressions such as MOD and TRIM.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
