Bug #41997 [Ver]: pdo_mysql: stored procedure call returning single rowset blocks future queries

Edit report at https://bugs.php.net/bug.php?id=41997&edit=1 ID: 41997 Updated by: cmb@php.net Reported by: nitel_defect at yahoo dot com Summary: pdo_mysql: stored procedure call returning single rowset blocks future queries Status: Verified Type: Bug Package: PDO MySQL Operating System: * PHP Version: 5.2.3 Assigned To: cmb Block user comment: N Private report: N New Comment: > not sure about libmysqlclient yet Behaves the same. Previous Comments: ------------------------------------------------------------------------ [2019-08-05 07:58:19] cmb@php.net The originally reported issue has been basically resolved, but the fix for bug #40935 broke the test case as reported by stas@ above. The relevant behavior of calling stored procedures is described in the documentation[1]: | The final result from the procedure is a status result that | includes no result set. The status indicates whether the procedure | succeeded or an error occurred. This is not properly handled by mysqlnd, though (not sure about libmysqlclient yet), which simply proceeds to this status result when ::nextRowset() is called, but then errors because the actual result set is missing. [1] <https://dev.mysql.com/doc/refman/8.0/en/c-api-multiple-queries.html> ------------------------------------------------------------------------ [2019-08-05 07:40:05] cmb@php.net Related To: Bug #39858 ------------------------------------------------------------------------ [2015-07-10 12:41:58] spam2 at rhsoft dot net Related To: Bug #70039 ------------------------------------------------------------------------ [2015-07-10 12:41:58] spam2 at rhsoft dot net Related To: Bug #70039 ------------------------------------------------------------------------ [2013-08-11 03:36:39] stas@php.net I still see test bug_41997 failing for me on master. Same happens on tracis CI: https://travis-ci.org/php/php-src/builds/10062028 Error message is: Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error in /home/smalyshev/php-src/ext/pdo_mysql/tests/bug_41997.php on line 10 Client library version is: pdo_mysql Client API version => mysqlnd 5.0.11-dev - 20120503 - $Id: 40933630edef551dfaca71298a83fad8d03d62d4 $ ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=41997 -- Edit this bug report at https://bugs.php.net/bug.php?id=41997&edit=1