Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-172

Order by for varchar columns is always case insensitive

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

        Hide
        tfischer Thomas Fox added a comment -

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

        Show
        tfischer Thomas Fox added a comment - done, see e.g. Criteria.addAscendingOrderByColumn(ColumnImpl, boolean)

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development