Torque
  1. Torque
  2. TORQUE-78

Criteria.setIgnoreCase ignores datatype of column

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 3.3-RC1
    • Fix Version/s: 4.0-beta1
    • Component/s: Runtime
    • Labels:
      None
    • Environment:
      Windows XP, MS SQL Server

      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.

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Frauke Heyl
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development