#45763 [Opn->Asn]: mysqli::multi_query does not work with mysqlnd

[email protected]
Newsgroups php.bugs
Message-ID <[email protected]>
 ID:               45763
 Updated by:       [email protected]
 Reported By:      michael dot kofler at gmx dot com
-Status:           Open
+Status:           Assigned
 Bug Type:         MySQLi related
 Operating System: linux
 PHP Version:      5.3.0alpha1
-Assigned To:      
+Assigned To:      andrey
 New Comment:

Assigning to primary maintainer


Previous Comments:
------------------------------------------------------------------------

[2008-08-08 13:44:27] michael dot kofler at gmx dot com

Description:
------------
mysqli::multi_query returns FALSE if more than one query is given

Reproduce code:
---------------
$mysqli = new mysqli($mysqlhost, $mysqluser, $mysqlpasswd, $mysqldb);
$sql = "SELECT 1; SELECT 2; SELECT 3";
$ok = $mysqli->multi_query($sql);
if($ok === FALSE) {
   echo $mysqli->error();
 }


Expected result:
----------------
non (because $ok === TRUE)

(works with mysqli + libmysql)

Actual result:
--------------
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '; SELECT
2; SELECT 3' at line 1


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=45763&edit=1
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.