Torque
  1. Torque
  2. TORQUE-172

Order by for varchar columns is always case insensitive

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.3, 3.3.1
    • Fix Version/s: 4.0-beta1
    • Component/s: Runtime
    • Labels:
      None

      Description

      An order by for Varchar columns is alwasy case insensitive, even if the database would normally do case sensitive ordering.
      E.G. for oracle, the generated code is
      ORDER BY UPPER(column)

      The user should be able to choose ehether ordering is case insensitive or not.

        Activity

        Thomas Fox created issue -
        Hide
        Thomas Fox added a comment -

        done, see e.g. Criteria.addAscendingOrderByColumn(ColumnImpl, boolean)

        Show
        Thomas Fox added a comment - done, see e.g. Criteria.addAscendingOrderByColumn(ColumnImpl, boolean)
        Thomas Fox made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 4.0 [ 12312102 ]
        Resolution Fixed [ 1 ]
        Thomas Fox made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        75d 18h 49m 1 Thomas Fox 30/Jan/12 18:25
        Resolved Resolved Closed Closed
        237d 12h 40m 1 Thomas Fox 24/Sep/12 08:06

          People

          • Assignee:
            Unassigned
            Reporter:
            Thomas Fox
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development