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: Open
+Status: Verified
Type: Bug
Package: PDO MySQL
Operating System: *
PHP Version: 5.2.3
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
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>
Previous Comments:
------------------------------------------------------------------------
[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 $
------------------------------------------------------------------------
[2008-07-30 01:00:01] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
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