From: alexander dot over at koeln dot de
Operating system: Suse 9.3
PHP version: 5.1.4
PHP Bug Type: MySQLi related
Bug description: MySQLi multi_query functionality results in error
Description:
------------
Sorry for that english :D
When trying to use the multi_query functions from mysqli adapter, it
always fails with an syntax error if more than one sql statement is given
to the function/object.
Reproduce code:
---------------
$mysqli = new mysqli('localhost', 'root', '', 'test');
$query = "SELECT CURRENT_USER();";
$query .= "SELECT CURRENT_USER();";
if ($mysqli->multi_query($query)) {
do {
if ($result = $mysqli->store_result()) {
while ($row = $result->fetch_row()) {
printf("%s\n", $row[0]);
}
$result->close();
}
} while ($mysqli->next_result());
} else {
echo $mysqli->error;
}
$mysqli->close();
Expected result:
----------------
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Actual result:
--------------
Fehler in der Syntax bei ';SELECT CURRENT_USER()' in Zeile 1.
(German Locale)
--
Edit bug report at http://bugs.php.net/?id=37567&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37567&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=37567&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37567&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37567&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37567&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37567&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37567&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37567&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37567&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37567&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37567&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37567&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37567&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37567&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37567&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37567&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37567&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37567&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37567&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37567&r=mysqlcfg
