[ I'm not on the list, please CC me any reply ]

Hi,

i'm the debian maintainer of the libdbd-mysql-perl package. I've got a bug report : http://bugs.debian.org/118553

Extract : | I am getting erratic behaviour when I use a placeholder as an argument to | LIMIT. For instance, if I do | | $sth = $dbh->prepare("SELECT foo, bar FROM baz LIMIT ?, ?"); | $sth->execute($start, $length) or die $dbh->errstr; | | it works most of the time. However, sometimes it gets confused about the | encoding of the parameters, and I get an error message complaining | about a syntax error "near '20', 10", for instance. It looks like | the $sth got confused as to the arg type while trying to bind it.

You'll find more information in the complete bug reporti (cf link above). There's a work around the problem (using bind_param) but the problem still needs to be adressed.

The package is still the "old" DBD::mysql (1.2216), tell me if it's fixed in the 2.x version...

Cheers,