[Dbix-class] MSSQL - problem sorting by joined column while limiting rows

[Peter Rabbitson]

Alan Humphrey wrote:
>> -----Original Message-----
>> From: Peter Rabbitson [mailto:rabbit+dbic at rabbit.us]
>> Sent: Saturday, December 12, 2009 3:37 PM
>> To: DBIx::Class user and developer list
>> Subject: Re: [Dbix-class] MSSQL - problem sorting by joined column
>> while limiting rows
>>
>> On Fri, Dec 11, 2009 at 02:24:29PM -0800, Alan Humphrey wrote:
>>> An update on this problem.
>>>
>>> Database was converted to MSSQL2008.
>>>
>>> The latest code works fine, except if prefetch is used.  See below
>> for code and trace results.
>> Try [1]. This *should* be the end of this :)
>>
>> [1] http://dev.catalyst.perl.org/repos/bast/DBIx-
>> Class/0.08/branches/mssql_limit_regression/
>>
> 
> Good news and bad news.  Good news - results are coming back.  Bad news -
> the sort is wrong.

Negative - it works here just fine. A request was crafted to specifically
mimic your query - please put on the debugger hat and find out why your
stuff breaks and ours doesn't:
http://dev.catalyst.perl.org/svnweb/bast/revision?rev=8114

Cheers