#30657 [NEW]: mysqli_multi_query ignores SQL errors

From: michael at kofler dot cc Operating system: linux (suse 9.1) PHP version: 5CVS-2004-11-02 (dev) PHP Bug Type: MySQLi related Bug description: mysqli_multi_query ignores SQL errors Description: ------------ with mysqli_multi_query I can execute several SQL commands at once; if an error happens in the second or third or ... SQL command, mysqli_multi_query returns TRUE, mysqli_error etc. contain no data on the error thus, it is impossible to detect and/or analyse errors in multi query statements Reproduce code: --------------- $ok = mysqli->multi_query("SELECT 1; SELECT blabla"); Expected result: ---------------- $ok should be FALSE, $mysqli->error should specify error (actually, $mysqli->error is inadequate; something like $mysqli->multi_error would be better, returning an array with the error messages for all statements) Actual result: -------------- $ok is TRUE -- Edit bug report at http://bugs.php.net/?id=30657&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30657&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30657&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30657&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30657&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30657&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30657&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30657&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30657&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30657&r=support Expected behavior: http://bugs.php.net/fix.php?id=30657&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30657&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30657&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30657&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30657&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30657&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30657&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30657&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30657&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30657&r=mysqlcfg