Alan Humphrey wrote: >> -----Original Message----- >> From: Peter Rabbitson [mailto:[email protected]] >> 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 _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
