[Catalyst] Class::DBI::Sweet LIMIT clause with placeholders

Christian Hansen ch at ngmedia.com
Wed Jun 8 15:57:45 CEST 2005

On 2005-06-07, at 23.29, Perrin Harkins wrote:

> FYI, Tim Bunce seems to think that the LIMIT clause with placeholders
> that Class::DBI::Sweet uses will no longer work with recent DBD::mysql
> releases.  Is anyone else experiencing this?

I can confirm this, it's broken in DBD::mysql 2.9007 and 2.9008.

But it's not directly related to LIMIT clause, it will trow an 
exception on any value that binds a numeric datatype with undef.

A temporary solution is to downgrade to DBD::mysql 2.9006


Christian Hansen
+46 40 660 17 50

More information about the Catalyst mailing list