Bug #47264 linq2ef sort by length not correctly

• Submitted: 11 Sep 2009 0:56
• Modified: 14 Oct 2009 6:39
• Reporter: Chriz Yuen
• Status: No Feedback
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: 6.1
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[11 Sep 2009 0:56] Chriz Yuen

Description:
I mapped mysql database on entity framework. 
When i sort data by length, it returns natural order.
But, it works correctly with MS SQL server.

How to repeat:
var orderproduct = from SO in context.saleorder
                   orderby SO.CustomerName.Length
                   select new SO.CustomerName,SO.CustomerName.Length};

Suggested fix:
Should return sorted result rather than natural order

[14 Sep 2009 6:39] Susanne Ebrecht

Which charset do you use?

Do you have same problem when you try the statement on CLI?

[14 Oct 2009 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".