openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Sutter (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-321) DB2 ABS Casting problem
Date Fri, 17 Aug 2007 22:00:37 GMT
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.


Mime
View raw message