Bug #72104 Broken sorting of numeric columns

• Submitted: 23 Mar 2014 0:22
• Modified: 21 Aug 2014 20:15
• Reporter: Przemyslaw Malkowski
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 6.1.2, 6.0.9
• OS: Linux
• 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] MySQL Verification Team

Hello Przemyslaw,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

[24 Mar 2014 6:36] MySQL Verification Team

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] MySQL Verification Team

Screenshot 6.1.2

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

[24 Mar 2014 6:40] MySQL Verification Team

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.