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

Order By Clauses with non function operands fail

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.2
    • 3.3
    • Runtime
    • None
    • Any.
    • TTHS4

    Description

      Many types of order by clauses no longer work
      in 3.2-rc1, they worked fine in 3.1.1 . For example:

      ORDER BY table.column < 100
      ORDER BY table.column IN (1, 2, 3)
      ORDER BY 100 > table.column

      The cause of this is the new
      SQLBuilder.removeSQLFunction()
      which only removes takes table.column name from inside parens.

      Migrated Scarab issue raised by Jacob Champlin (jchamplin at emocorp dot com)

      Attachments

        1. patch.txt
          2 kB
          Scott Eade

        Activity

          People

            tfischer Thomas Fox
            seade Scott Eade
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: