db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (TORQUE-78) Criteria.setIgnoreCase ignores datatype of column
Date Mon, 24 Sep 2012 07:08:16 GMT

     [ https://issues.apache.org/jira/browse/TORQUE-78?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Thomas Fox closed TORQUE-78.

> Criteria.setIgnoreCase ignores datatype of column
> -------------------------------------------------
>                 Key: TORQUE-78
>                 URL: https://issues.apache.org/jira/browse/TORQUE-78
>             Project: Torque
>          Issue Type: Bug
>          Components: Runtime
>    Affects Versions: 3.3-RC1
>         Environment: Windows XP, MS SQL Server
>            Reporter: Frauke Heyl
>            Priority: Minor
>             Fix For: 4.0-beta1
> 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. 

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message