Bug #72104 Broken sorting of numeric columns
Submitted: 23 Mar 2014 0:22 Modified: 21 Aug 2014 20:15
Reporter: Przemyslaw Malkowski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.1.2, 6.0.9 OS:Linux
Assigned to: CPU Architecture:Any

[23 Mar 2014 0:22] Przemyslaw Malkowski
Description:
Basically any numeric column sorting around the Workbench is broken - the sorting applies only to the first digit.

How to repeat:
Go to any tabular report and click on numeric column header - it is supposed to sort by that column. For example Schema Inspector -> Tables -> Rows, or Performance Reports -> InnoDB Statistics -> InnoDB Buffer Stats by Table -> Pages, etc.

Suggested fix:
Fix sorting by numeric values.
[23 Mar 2014 0:25] Przemyslaw Malkowski
example view

Attachment: workbench_sorting1.png (image/png, text), 46.52 KiB.

[23 Mar 2014 0:25] Przemyslaw Malkowski
example view

Attachment: workbench_sorting2.png (image/png, text), 55.02 KiB.

[24 Mar 2014 6:29] Umesh Shastry
Hello Przemyslaw,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[24 Mar 2014 6:36] Umesh Shastry
I'm able to repeat this on OL6, but I could not repeat this issue on Win7(with WB 6.1.2 Beta), may be linux specific?
[24 Mar 2014 6:39] Umesh Shastry
Screenshot 6.1.2

Attachment: 6_1_2_72104.png (image/png, text), 137.76 KiB.

[24 Mar 2014 6:40] Umesh Shastry
Screenshot 6.0.9

Attachment: 6.0.9_72104.png (image/png, text), 126.53 KiB.

[3 Apr 2014 16:09] Joe Beason
Column sorting in the result window (on any column, not just numeric) will sort only ascending and not decending. This is on version 6.1.4.11773 for Windows (using version 7 SP1 64-bit).
[3 Apr 2014 16:19] Joe Beason
Apologies. The above comment is for Windows OS version, not Linux.
[18 Apr 2014 14:03] Bruce Leary
In addition to not being able to sort descending, the arrow flag added to the column heading to indicate that the column is sorted is not reset when the sorting is cancelled or changed to another column. In other words, the flag, once set, stays until the table is refreshed.
[21 Aug 2014 20:15] Philip Olson
Fixed as of the MySQL Workbench 6.2.0 release, and here's the changelog entry:

Sort on numeric columns did not function properly.

Thank you for the bug report.