| Subject: | Using mysql_server_prepare causes segmentation fault |
Originally reported by Jeff Rife at http://bugs.mysql.com/bug.php?id=27421
Description:
Repeatedly executing any prepared statement with a placeholder parameter
causes a segmentation fault if "mysql_server_prepare" has been set.
The value of the parameter passed doesn't seem to matter, nor does
calling "finish" (although I thought that was the issue, so that's why I
did it).
This happens for all users and regardless of whether the connection is
local or via TCP/IP.
How to repeat:
use DBI;
my $dbh = DBI->connect('DBI:mysql:mysql_server_prepare=1');
# any prepare with a placeholder parameter will exhibit the symptoms
my $sth = $dbh->prepare("SELECT * FROM mytable WHERE a = ?");
print "About to execute #1";
$sth->execute(1);
print "Finished #1";
$sth->finish();
print "About to execute #2";
$sth->execute(1); # Segmentation fault here
print "Finished #2";
$sth->finish();
See original report for more details.