MySQL Bugs: #49302: No ability to order by DESC

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

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.

Sorting by DESC was enabled by holding Control while clicking. I've changed that to toggle between ASC and DESC by clicking multiple times.

confirmed changed behavior for setting sort direction.

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.