#27987 [NEW]: mysqli prepared statements crash mysqld on second execution

From: laura at cs dot rmit dot edu dot au Operating system: windows xp PHP version: 5.0.0RC1 PHP Bug Type: MySQL related Bug description: mysqli prepared statements crash mysqld on second execution Description: ------------ When using a mysqli prepared statement, first execution works. Second execution crashes the MySQL server. This is using PHP5RC1 and MySQL 5.0.0 alpha max and the sample code given at http://www.php.net/manual/en/function.mysqli-prepare.php (Example 1, OO style) I suspect the problem is caused by a bug in older versions of the MySQL library, as documented here: http://bugs.mysql.com/bug.php?id=2099 and here: http://bugs.mysql.com/bug.php?id=1663 This bug has been fixed in newer versions of the library from MySQL but I would guess the PHP5 version is based on an older (pre January) version of the library. Reproduce code: --------------- http://www.php.net/manual/en/function.mysqli-prepare.php Expected result: ---------------- Output as specified in the manual Actual result: -------------- MySQL server crash. -- Edit bug report at http://bugs.php.net/?id=27987&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27987&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27987&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27987&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27987&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27987&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27987&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27987&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27987&r=support Expected behavior: http://bugs.php.net/fix.php?id=27987&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27987&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27987&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27987&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27987&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27987&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27987&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27987&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27987&r=float