aggregate functions not allowed in order by clause on some dbmses

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Medium
    • 2.6 M6, 2.6
    • Affects Version/s: 2.6 M3
    • Component/s: None
    • None

      SELECT new com.atlassian.bamboo.utils.Pair(tcr.testCase.id, count) FROM TestCaseResultImpl tcr
      WHERE tcr.testCase.testClass.plan = :plan
      AND tcr.state = 'FAILED'
      group by tcr.testCase.id
      order by count desc

      This query fails on MySQL 4.1, it does not allow count in "order by" clause. All possibly affected queries have to be converted.

            Assignee:
            Przemek Bruski
            Reporter:
            Przemek Bruski
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: