[TORQUE-78] Criteria.setIgnoreCase ignores datatype of column

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.3-RC1
• Fix Version/s: 4.0-beta1
• Component/s: Runtime
• Environment: Windows XP, MS SQL Server
• Assignee: Unassigned
• Reporter: Frauke Heyl
• Created: 19/Jan/07 16:55
• Updated: 24/Sep/12 07:06
• Resolved: 30/Jan/12 19:14

Description

If I call Criteria.setIgnoreCase(true); all columns and values are wrapped with UPPER, no matter wich type they have.
So for a datetime field I get some statement like:
select * from TABLE_X where UPPER(X_DATE) = UPPER('20070116 00:00:00')
which does not work correctly.
I now have a workaround setting ignore case for all Criterion objects seperately, but still I consider it as a bug, since the type of the column is known when the ignore case flag is evaluated in the build function of class SQLExpression.