Bug #78623 [Com]: Regression caused by "SP call yields additional empty result set"
Edit report at https://bugs.php.net/bug.php?id=78623&edit=1
ID: 78623
Comment by: dude at mailinator dot com
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:
You guys really need to fix the bug on which any person can comment using any email. This is just
bad.
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)