db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (Resolved) (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (TORQUE-78) Criteria.setIgnoreCase ignores datatype of column
Date Mon, 30 Jan 2012 19:15:10 GMT

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

Thomas Fox resolved TORQUE-78.

       Resolution: Fixed
    Fix Version/s: 4.0

Fixed. See org.apache.torque.sql.SqlBuilderTest.testIgnoreCaseIntegerColumnType()
> 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
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
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