Bug #78623 [NEW]: Regression caused by "SP call yields additional empty result set"
From: attila at szeremi dot org
Operating system: Debian
PHP version: 7.3.10
Package: PDO MySQL
Bug Type: Bug
Bug description:Regression caused by "SP call yields additional empty result set"
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 bug report at https://bugs.php.net/bug.php?id=78623&edit=1
--
Fix committed: https://bugs.php.net/fix.php?id=78623&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=78623&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=78623&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=78623&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=78623&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=78623&r=support
Expected behavior: https://bugs.php.net/fix.php?id=78623&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=78623&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=78623&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=78623&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=78623&r=phptooold
Daylight Savings: https://bugs.php.net/fix.php?id=78623&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=78623&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=78623&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=78623&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=78623&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=78623&r=mysqlcfg
Thread (4 messages)
- attila at szeremi dot org