DBD::mysql 3.0006 patch to fix quote parsing and finish problems

--_=XFMail.1.5.5-RC1.Linux:20060728164000:21812=_
Content-Type: text/plain; charset=us-ascii

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



--_=XFMail.1.5.5-RC1.Linux:20060728164000:21812=_
Content-Type: text/plain; charset=us-ascii


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org
--_=XFMail.1.5.5-RC1.Linux:20060728164000:21812=_--
End of MIME message