Bug #78623 [Asn]: Regression caused by "SP call yields additional empty result set"

From: Date: Thu, 03 Oct 2019 11:03:31 +0000
Subject: Bug #78623 [Asn]: Regression caused by "SP call yields additional empty result set"
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-223018@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=78623&edit=1

 ID:                 78623
 Updated by:         cmb@php.net
 Reported by:        attila at szeremi dot org
 Summary:            Regression caused by "SP call yields additional
                     empty result set"
 Status:             Assigned
 Type:               Bug
 Package:            PDO MySQL
 Operating System:   Debian
 PHP Version:        7.3.10
 Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

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] <https://travis-ci.org/cmb69/php-src/jobs/592985351#L3080>


Previous Comments:
------------------------------------------------------------------------
[2019-10-02 16:13:06] attila at szeremi dot org

Description:
------------
The fix to this bug in PHP 7.3.10 seems to have caused a regression: https://bugs.php.net/bug.php?id=41997

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: https://github.com/amcsi/php7.3.10-pdo-mysql-regression

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

Test script:
---------------
https://github.com/amcsi/php7.3.10-pdo-mysql-regression/blob/master/example.php

Expected result:
----------------
array(2) {
  [0]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  [1]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
}

Actual result:
--------------
array(3) {
  [0]=>
  string(5) "HY000"
  [1]=>
  int(2014)
  [2]=>
  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."
}


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



--
Edit this bug report at https://bugs.php.net/bug.php?id=78623&edit=1

Thread (4 messages)

« previous php.bugs (#223018) next »