Bug #51859 Order (sort) by numbers are wrong

• Submitted: 9 Mar 2010 11:24
• Modified: 9 Mar 2010 11:38
• Reporter: olaf ocke
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.16
• OS: MacOS
• CPU Architecture: Any
• Tags: id, order, sort

[9 Mar 2010 11:24] olaf ocke

Description:
I was a little surprised no one else reported this as a bug yet (I searched), while I consider it highly annoying.

The sorting / ordering of a column with ids is wrong.

How to repeat:
It's very easy, just sort/order a column with ids in the SQL Editor by clicking on the column name.

The ordering goes as follows:

1, 10, 100, 101, 102, 11, 12, 13, 2 , 3, 4 , 5 ,6 etc

You get the idea :-)

Really annoying in my opinion.

Suggested fix:
it should be:
1, 2, 3, 4, 10, 11, 12, 100, 101, 102 etc

[9 Mar 2010 11:32] Valeriy Kravchuk

Thank you for the problem report. Please, check with a newer version, 5.2.16, and inform about the results.

[9 Mar 2010 11:37] olaf ocke

Ah this seems to be fixed at 5.2.16!

[9 Mar 2010 11:38] olaf ocke

fixed