DevForce Community Forum : Bug/Issue with orderby GUIDs in cache http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Bug/Issue with orderby GUIDs in cache Mon, 13 Apr 2026 05:05:54 -700 Wed, 21 Jul 2010 19:09:34 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1985 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Bug/Issue with orderby GUIDs in cache : Yep, we ran into this as well.... http://www.ideablade.com/forum/forum_posts.asp?TID=1985&PID=7737#7737 Author: ting
Subject: 1985
Posted: 21-Jul-2010 at 7:09pm

Yep, we ran into this as well.  We'll take care of it along with the String equality issues. ;)

]]> Wed, 21 Jul 2010 19:09:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1985&PID=7737#7737 Bug/Issue with orderby GUIDs in cache : Slightly unusual bug here...SQL... http://www.ideablade.com/forum/forum_posts.asp?TID=1985&PID=7714#7714 Author: jsobell
Subject: 1985
Posted: 20-Jul-2010 at 11:24pm

Slightly unusual bug here...

SQL Server does not order GUIDs in the same way as .NET, so if you query against the cache you will get very different search order results to the server's returned order.

According to Microsoft's doco the SQL Server uses only the last eight digits of the GUID for sorting. This is a total pain in the bum, but such is life.
We use the following extension to Guid to ensure our internal sorts match SQL Server's:

public static int CompareToSql(this Guid left, Guid value)
{
  return (left.ToString().Substring(24).CompareTo(value.ToString().Substring(24)));
}

The cache in DF appears to do a regular sort, so in some cases (such as ours, surprise surprise) it breaks if the QueryStrategy is not set to QueryStrategy.DataSourceOnly

Just another interesting issue found while converting an EF4 app to IdeaBlade :)

I'll include this in an incident report.
]]> Tue, 20 Jul 2010 23:24:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1985&PID=7714#7714