Bug #49302 No ability to order by DESC
Submitted: 1 Dec 2009 21:35 Modified: 26 Feb 2010 16:48
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.10 r4680 OS:Windows (XP)
Assigned to: Alfredo Kojima CPU Architecture:Any

[1 Dec 2009 21:35] Todd Farmer
Description:
QB's live editor allows for sorting by rows, but it apparently is limited to ASC order only.  In just about every such live editor I know of, successive clicks on the same column header will alternate between ASC and DESC sorting order.  WB doesn't appear to have DESC capabilities, at least on Windows.

How to repeat:
Try sorting table columns in DESC order.

Suggested fix:
Add ability to sort by DESC.
[24 Feb 2010 16:07] Alfredo Kojima
Sorting by DESC was enabled by holding Control while clicking. I've changed that to toggle between ASC and DESC by clicking multiple times.
[25 Feb 2010 18:22] Johannes Taxacher
confirmed changed behavior for setting sort direction.
[26 Feb 2010 16:48] Tony Bedford
An entry has been added to the 5.2.17 changelog:

The live data editor in SQL Editor did not allow the columns to be sorted in descending order by clicking the column heading. It only allowed column sorting in ascending order through clicking the column heading.