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

shouldn't always use CAST with UPPER and LOWER for DB2

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.0.3, 1.2.1, 2.0.0-M2, 2.0.0-M3
    • 1.0.4, 1.2.2, 1.3.0, 2.0.0-beta
    • sql
    • None
    • DB2
    • Patch Available

    Description

      Using DB2, when a user uses the UPPER or LOWER function, the field is automatically CAST to a varchar. It would be nice if OpenJPA were a little smarter and only used CAST when necessary. Using the CAST causes any indexes not to be used so performance won't be what it should.

      I saw some other DB2 functions that also are always CAST, so we may need to improve these also.

      Attachments

        1. OPENJPA-1308-1.0.x.patch
          16 kB
          Barrett Jay Reed
        2. OPENJPA-1308-1.2.x.patch
          12 kB
          Barrett Jay Reed
        3. OPENJPA-1308-trunk.patch
          13 kB
          Barrett Jay Reed

        Activity

          People

            mikedd Michael Dick
            bjreed Barrett Jay Reed
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: