Bug #61659 Workbench status screen sorts wrong
Submitted: 27 Jun 2011 18:31 Modified: 3 Feb 2012 4:09
Reporter: Chris Wagner Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.34 OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: workbench sort order

[27 Jun 2011 18:31] Chris Wagner
The server status screen has wonky sorting.  Clicking on the Id field (which should be ID) sorts the field in ASCII order rather than numeric order.  e.g. 1300 sorts before 500 which sorts before 900.  The screen also cannot be unsorted.  U can only flip between ascending and descending order.  The time also ASCII sorts.  Host is wonky too.

How to repeat:

Suggested fix:
Make columns able to be non-sorted, i.e. original order, by clicking the header a third time thus removing the up/down triangle sort indicator.  Make ID and Time columns sort numerically.  Make Host column sort on numeric IP and port value rather than ASCII.
[27 Jun 2011 20:29] MySQL Verification Team
Could you please try version 5.2.34 and the exactly OS you are using. Thanks.
[27 Jun 2011 23:11] Chris Wagner
Are u aware of any changes to the sorting function in 34?
[28 Jun 2011 0:09] MySQL Verification Team
Thank you for the feedback. Verified with time column.
[3 Feb 2012 4:09] Philip Olson
Fixed as of 5.2.38:

The "Server Status" window would incorrectly
sort options. Numeric fields are now sorted numerically (e.g.,
1300 is now after 500).