openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B.J. Reed (JIRA)" <>
Subject [jira] Updated: (OPENJPA-1308) shouldn't always use CAST with UPPER and LOWER for DB2
Date Tue, 20 Oct 2009 16:43:59 GMT


B.J. Reed updated OPENJPA-1308:

    Attachment:     (was: OPENJPA-1308-trunk.patch)

> shouldn't always use CAST with UPPER and LOWER for DB2
> ------------------------------------------------------
>                 Key: OPENJPA-1308
>                 URL:
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 1.0.3, 1.2.1, 2.0.0-M2
>         Environment: DB2
>            Reporter: B.J. Reed
>            Priority: Minor
>             Fix For: 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