|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #78623 Regression caused by "SP call yields additional empty result set"
Submitted: 2019-10-02 16:13 UTC Modified: 2019-10-03 11:03 UTC
From: attila at szeremi dot org Assigned: cmb (profile)
Status: Closed Package: PDO MySQL
PHP Version: 7.3.10 OS: Debian
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: attila at szeremi dot org
New email:
PHP Version: OS:


 [2019-10-02 16:13 UTC] attila at szeremi dot org
The fix to this bug in PHP 7.3.10 seems to have caused a regression:

The error mentioned in that ticket seems to now be coming up, but triggered in a different way.

I made a repo where you can reproduce this with the help of Docker Compose:

If you downgrade the PHP version to 7.3.9, the problem goes away.

Test script:

Expected result:
array(2) {
  array(1) {
    string(1) "1"
  array(1) {
    string(1) "2"

Actual result:
array(3) {
  string(5) "HY000"
  string(269) "Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute."


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2019-10-02 16:21 UTC]
-Assigned To: +Assigned To: cmb
 [2019-10-03 11:03 UTC]
Thanks for reporting!

However, I cannot reproduce this (neither on Windows/mysqlnd/MySQL
5.6 nor on Travis[1]).  This may be a libmysql-client issue, or
may be related to some other database server (version).

If we can't make progress on this, I'll revert the fix for bug
#41997 within the next days, so 7.2.24RC1 and 7.3.11RC1 won't have
the regression.

[1] <>
 [2019-10-07 07:19 UTC]
Automatic comment on behalf of
Log: Fix #78623: Regression caused by &quot;SP call yields additional empty result set&quot;
 [2019-10-07 07:19 UTC]
-Status: Assigned +Status: Closed
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Mon Jul 15 00:01:28 2024 UTC