openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B.J. Reed (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-1308) shouldn't always use CAST with UPPER and LOWER for DB2
Date Fri, 18 Sep 2009 14:25:16 GMT
shouldn't always use CAST with UPPER and LOWER for DB2
------------------------------------------------------

                 Key: OPENJPA-1308
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1308
             Project: OpenJPA
          Issue Type: Improvement
          Components: sql
    Affects Versions: 2.0.0-M2, 1.2.1, 1.0.3
         Environment: DB2
            Reporter: B.J. Reed
            Priority: Minor
             Fix For: 2.0.0


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.

-- 
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