Bug #66768 Connection IDs and time are sorted alphabetically
Submitted: 11 Sep 2012 14:16 Modified: 30 Nov 2012 2:07
Reporter: Matthias Maier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.42 OS:Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: connection ID, Connections, execution time, server administration, server status, sort

[11 Sep 2012 14:16] Matthias Maier 
Description:
It is not possible to sort connections by connection ID column because it is treated as text instead of number. Same for time column.

How to repeat:
Server Administration -> Server Status -> Connections: Click on ID or Time column. Column is sorted by ASCI value and length, not by numerical value.

Suggested fix:
It should be possible to sort columns by connection id and or execution time. Therefore these columns should be treated and sorted as numbers.
[11 Sep 2012 18:14] MySQL Verification Team 
Thank you for the bug report.
[30 Nov 2012 2:07] Philip Olson 
Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

The "Id" and "Time" columns within the "Server Administration", "Server
Status", "Connections" panel would not sort properly, as they were sorted
as ASCII values instead of numerically.

Thank you for the bug report.