|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #62820 mysqlnd API incompatability breaks PDOStatement->nextRowset()
Submitted: 2012-08-14 18:28 UTC Modified: 2020-12-09 15:49 UTC
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: Assigned: nikic (profile)
Status: Closed Package: PDO MySQL
PHP Version: master-Git-2012-08-14 (Git) OS:
Private report: No CVE-ID: None
 [2012-08-14 18:28 UTC]
When the mysqlnd driver is used PDOStatement->nextRowset() does not return bool(false) when there are no more result sets. This causes several test 
failures, which all have a diff looking similar to this:

    009+ Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error in %s/bug_41997.php on line 11
    010+ array(0) {
    011+ }

This can be traced down to mysql_next_result() returning 0 instead of -1 in

The reason is that (when using mysqlnd) mysql_next_result is aliased to mysqlnd_next_result, but both have different APIs: The mysqlnd_ version only returns PASS = 0 or FAIL = 1, whereas the mysql_ version returns -1 if the call worked, but there were no more resultsets.

This is documented at in the "Return Values" section. The default mysqlnd next_result implementation is here:


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-08-14 18:29 UTC]
Related bug report:
 [2012-09-11 13:46 UTC]
-Assigned To: +Assigned To: mysql
 [2013-03-24 15:38 UTC]
Just looked at the code again, what I said above is wrong. The code checks mysql_more_results() before (, so it should not be related to the return value of mysql_next_result(). Something else is wrong.
 [2014-01-01 12:36 UTC]
-Package: PDO related +Package: PDO MySQL
 [2017-10-24 08:07 UTC]
-Status: Assigned +Status: Open -Assigned To: mysql +Assigned To:
 [2020-12-09 15:49 UTC]
-Status: Open +Status: Closed -Assigned To: +Assigned To: nikic
 [2020-12-09 15:49 UTC]
The original hypothesis here was incorrect, and various rowset handling issues have recently been fixed, so I think it's safe to close this one.
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sun Sep 19 15:03:37 2021 UTC