ID: 39858 Updated by: [EMAIL PROTECTED] Reported By: develar at gmail dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows XP SP2 PHP Version: 5.2.0 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2006-12-17 14:30:25] develar at gmail dot com Description: ------------ The second call stored procedures causes an error "SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query" with probability of 50%. I read #35333 #35637 #35203, but why the given code fine works in Debian? Reproduce code: --------------- CREATE PROCEDURE `foo`() NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN SELECT 2 * 2; END; <?php $Db = new PDO('mysql:host=localhost;dbname=test', 'root', '', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'", PDO::ATTR_PERSISTENT => true)); $Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $Pdo = $Db->prepare('CALL foo()'); $Pdo->execute(); print_r($Pdo->fetchAll()); $Pdo = $Db->prepare('CALL foo()'); $Pdo->execute(); print_r($Pdo->fetchAll()); $Pdo->closeCursor(); ?> Expected result: ---------------- Array ( [0] => Array ( [2 * 2] => 4 ) ) Array ( [0] => Array ( [2 * 2] => 4 ) ) Actual result: -------------- Array ( [0] => Array ( [2 * 2] => 4 ) ) <br /> <b>Warning</b>: PDOStatement::execute() [<a href='function.PDOStatement-execute'>function.PDOStatement-execute</a>]: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query in <b>C:\home\test\www\pdo.php</b> on line <b>12</b><br /> Array ( ) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39858&edit=1
