db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frauke Heyl (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-78) Criteria.setIgnoreCase ignores datatype of column
Date Fri, 19 Jan 2007 16:55:29 GMT
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

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 contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.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