Bug #59525 Time column in connections view uses alphabetical sort order
Submitted: 15 Jan 2011 12:42 Modified: 6 Mar 2012 16:28
Reporter: Christopher Lörken Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.31 OS:Any
Assigned to: CPU Architecture:Any
Tags: administrator, Connections, sorting, time, workbench

[15 Jan 2011 12:42] Christopher Lörken 
Description:
In the connections view of the MySQL Workbench Server Administration view, you can sort after execution time by clicking in the header of the time column.
However, the list is sorted alphabetically and not by the actual execution time.
That means queries are listed after there execution time like this:

1
1
10
11
15
2
25
3
3
31

Tested with MySQL Workbench 5.2.31 CE, Revision 7110

How to repeat:
Log in to the server administration part on a server which has multiple running connections (a system with some sort of load), switch to the connections tab, sort by time.

Suggested fix:
The list should sort by number not by string.
[15 Jan 2011 17:10] Valeriy Kravchuk 
Thank you for the bug report. Verified on Mac OS X.
[6 Mar 2012 8:34] Jon Jo 
Same behaviour on Windows 7. (Would be useful to have this sort correctly to identify long running queries.)
[6 Mar 2012 16:28] Alfredo Kojima 
Duplicate of bug #61659