SourceForge has been redesigned. Learn more.
Close

#4030 (ok 4.1.0-rc1) ORDER BY SUM(`field`) does not sort DESC

4.0.4
fixed
None
1
2014-12-04
2013-07-20
No

The query "SELECT SUM(field) FROM table GROUP BY field2" can be sorted ASC and DESC on the SUM column using the GUI. But as soon as I escape the argument, sorting will stick to ASC.

SELECT SUM(`field`) FROM table GROUP BY field2

(note the backticks around "field") cannot be sorted DESC on SUM column using the GUI.

This is a follow-up of [bugs:#619].

Related

Bugs: #4619
Bugs: #619

Discussion

  • Hugues Peccatte

    Hugues Peccatte - 2013-11-15

    Hi,

    First information: when sorting a column like "SUM(field)", the column isn't set as sorted (arrow is not in the header of the column).

    I look if I can fix it.

     
  • Marc Delisle

    Marc Delisle - 2013-11-16
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-11-16
    • summary: ORDER BY SUM(field) does not sort DESC --> (ok 4.1.0-beta3) ORDER BY SUM(field) does not sort DESC
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-11-23
    • summary: (ok 4.1.0-beta3) ORDER BY SUM(field) does not sort DESC --> (ok 4.1.0-rc1) ORDER BY SUM(field) does not sort DESC
     
  • Marc Delisle

    Marc Delisle - 2013-12-12
    • Status: resolved --> fixed