Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-321

DB2 ABS Casting problem

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.9.7
    • 1.0.0
    • jdbc
    • None

    Description

      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.

      Attachments

        1. OPENJPA-321.patch
          11 kB
          Teresa Kan
        2. OPENJPA-321.patch
          8 kB
          Catalina Wei

        Activity

          People

            tckan1 Teresa Kan
            kwsutter Kevin W. Sutter
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: