Bug #50158 Client-side sorting is always alpha

• Submitted: 7 Jan 2010 20:49
• Modified: 29 Jan 2010 10:56
• Reporter: Todd Farmer (OCA)
• Status: Closed
• Category: MySQL Workbench
• Severity: S1 (Critical)
• Version: 5.2.11
• OS: Windows (XP)
• Assigned to: Sergei Tkachenko
• CPU Architecture: Any

[7 Jan 2010 20:49] Todd Farmer

Description:
WB has client-side sorting, but it appears to be done in alpha order, regardless of data type.

How to repeat:
CREATE TABLE test_sort( a INT);
INSERT INTO test_sort VALUES (1), (2), (3), (3), (4), (5), (10), (11), (20), (21), (30), (31), (100), (101);
SELECT * FROM test_sort;

Then sort the result by clicking on the column header for a:

1
10
100
101
11
2
20
21
3
3
30
31
4
5

Suggested fix:
Sort data appropriately depending on data type.

[7 Jan 2010 21:15] Peter Laursen

Why not let the server sort?  Duplicating server functionalities client-side is completely hopeless in my opinion!

[26 Jan 2010 21:52] Johannes Taxacher

fix confirmed. will be included in 5.2.15

[29 Jan 2010 10:56] Tony Bedford

An entry has been added to the 5.2.15 changelog:

Client-side sorting always sorted on an alpha basis, regardless of data type. This meant numerical values were not sorted into the order expected.