Bug #41997 [Csd->ReO]: SP call yields additional empty result set

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: SP call yields additional empty result set -Status: Closed +Status: Re-Opened Type: Bug Package: PDO MySQL Operating System: * PHP Version: 5.2.3 -Assigned To: cmb +Assigned To: Block user comment: N Private report: N New Comment: Since the regression reported as bug #78623 couldn't be resolved for now, I've reverted the fix for this bug, and re-open the ticket. Previous Comments: ------------------------------------------------------------------------ [2019-10-03 11:03:31] cmb@php.net Related To: Bug #78623 ------------------------------------------------------------------------ [2019-10-01 17:50:02] attila at szeremi dot org Here it is. It is definitely related to this issue. https://github.com/amcsi/php7.3.10-pdo-mysql-regression ------------------------------------------------------------------------ [2019-10-01 13:51:59] cmb@php.net Can you please provide a minimal self-contained reproduce script? ------------------------------------------------------------------------ [2019-10-01 13:31:23] attila at szeremi dot org Could the fix to this issue have caused breakage with empty rowset iteration loops? I had been using the workaround mentioned in the below ticket to be able to trigger exceptions in multi-statement PDO MySQL queries: https://bugs.php.net/bug.php?id=61613 But I can pretty much confirm that my test code that does while ($statement->nextRowset()); after a multi-statement query that in Bitbucket pipelines using the PHP 7.3.10 image the query doesn't seem to run at all (or maybe just the first one?), but in PHP 7.3.9 the multi-line statement is run correctly. I would test in 3v4l, but I don't know how to test DB stuff there. ------------------------------------------------------------------------ [2019-09-03 11:34:28] cmb@php.net Automatic comment on behalf of cmbecker69@gmx.de Revision: http://git.php.net/?p=php-src.git;a=commit;h=41a4379cb45419a376043ca5f8c5a2bca82cea7c Log: Fix #41997: SP call yields additional empty result set ------------------------------------------------------------------------ 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