[Dbix-class] MSSQL - problem sorting by joined
column while limiting rows
rabbit+dbic at rabbit.us
Tue Dec 15 12:10:47 GMT 2009
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 . This *should* be the end of this :)
>>  http://dev.catalyst.perl.org/repos/bast/DBIx-
> 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:
More information about the DBIx-Class