|Subject:||Using mysql_server_prepare causes segmentation fault|
Originally reported by Jeff Rife atDescription: 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.