MySQL Bugs: #71195: MySQL Workbench sort column not working properly with upper/lower case strings

Bug #71195	MySQL Workbench sort column not working properly with upper/lower case strings
Submitted:	20 Dec 2013 22:29	Modified:	7 Feb 2014 8:42
Reporter:	Georald Camposano	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.0.8.11354	OS:	Windows (Windows 8.1)
Assigned to:		CPU Architecture:	Any

Description:
Trying to sort a column (containing rows of string data) by clicking on the column name sorts the data starting with uppercase characters first, before sorting the lower case ones. In comparison, running a query with the ORDER BY clause sorts the data properly

How to repeat:
1. Create a table with 1 column of VARCHAR type
2. Enter in the following 10 rows of data:

 a
 b
 c
 d
 E
 F
 g
 H
 i
 j

3. Once created, open the table in Workbench (right click, Select Rows).
4. Click on the column header to sort the column in ASC or DESC order. Notice how the ordering prioritizes upper case characters first.
5. Run a SELECT query with the ORDER BY clause to see the correct sorting order.

Hello Georald,

Thank you for the report.
Verified as described.

Thanks,
Umesh

Fixed as of the upcoming MySQL Workbench 6.1.2 release, and here's the changelog entry:

Sorting by a column would sort the data starting with uppercase characters
first, before sorting the lower case strings. The sorting algorithm now
behaves like a typical "ORDER BY" clause, which does not prioritize
uppercase characters.

Thank you for the bug report.