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.
