 | | | DBD::mysql 3.0006 patch to fix quote parsing and finish problems | DBD::mysql 3.0006 patch to fix quote parsing and finish problems 2006-07-28 - By Martin J. Evans
Back
Attached is a patch to DBD::mysql 3.0006 which fixes two issues I've seen.
1. Someone, can't remember who now, reported a problem with some SQL which
contained an escaped ' and ? but DBD::mysql incorrectly thought it was a
parameter. e.g. '\'?' was counted as a parameter.
2. No finish calls when fetch exhausts the result-set causes problems with code
like this:
use DBI;
$h = DBI->connect("dbi:mysql:xxx", "xxx","yyy");
for (my $n = 0; $n < 2; $n++) {
$h->do(q/insert into mje (b) values('a')/);
$sth = $h->prepare_cached("select LAST_INSERT_ID()");
$sth->execute;
my $r = $sth->fetchall_arrayref;
}
which will output the warning:
prepare_cached(select LAST_INSERT_ID()) statement handle
DBI::st=HASH(0x9ba8114) still Active at -e line 8
The same changes are required for DBD::mysql 3.0006_1.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=mysql@(protected)
|
|
|