[Dbix-class] strange SQL generated

[Matt S Trout]

On Wed, Feb 15, 2006 at 10:34:35AM -0800, Alan Humphrey wrote:
> Looks like this line in ResultSet triggers the bug:
> 
>     $row = $self->search(\@unique_hashes, { rows => 1 })->first;
> 
> If the { rows => 1 } attribute is removed then there's no problem.
> 
> That attribute certainly *looks* superfluous...

For that query, yes. But that's indicative of a potentially larger problem
with limit/offset support on SQL Server. Can you give it a kick around and
see what does and doesn't work please?

-- 
     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +