openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <>
Subject [jira] Resolved: (OPENJPA-1308) shouldn't always use CAST with UPPER and LOWER for DB2
Date Fri, 23 Oct 2009 17:42:59 GMT


Michael Dick resolved OPENJPA-1308.

    Resolution: Fixed

Thanks for the patches, BJ. The fix is in the latest SNAPSHOT builds. 

> shouldn't always use CAST with UPPER and LOWER for DB2
> ------------------------------------------------------
>                 Key: OPENJPA-1308
>                 URL:
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.0.3, 1.2.1, 2.0.0-M2
>         Environment: DB2
>            Reporter: B.J. Reed
>            Assignee: Michael Dick
>            Priority: Minor
>             Fix For: 1.0.4, 1.2.2, 2.0.0
>         Attachments: OPENJPA-1308-1.0.x.patch, OPENJPA-1308-1.2.x.patch, OPENJPA-1308-trunk.patch
> 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

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message