Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.0.3, 1.2.1, 2.0.0-M2, 2.0.0-M3
-
Fix Version/s: 1.0.4, 1.2.2, 1.3.0, 2.0.0-beta
-
Component/s: sql
-
Labels:None
-
Environment:DB2
-
Patch Info: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.