Test: /ext/pdo_mysql/tests/bug80458.phpt - Version 7.4.29        

Bug #80458 PDOStatement::fetchAll() throws for upsert queries
Submitted: 2020-12-01 19:06:29 Modified: 2020-12-02 15:53:31
From: php.net.20.12.2016 Assigned:
Status: Closed Package: PDO MySQL
PHP Version: 7.4.13 OS: Arch Linux

There are 2 different diffs reported by users for this test.

Count Diff
1 (50%)
017+ 018+ Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/bug80458.php:34 019+ Stack trace: 020+ #0 %s/bug80458.php(34): PDO->exec('DROP PROCEDURE ...') 021+ #1 {main} 022+ thrown in %s/bug80458.php on line 34 017- array(0) { 018- } 019- array(1) { 020- [0]=> 021- array(2) { 022- ["first"]=> 023- int(7) 024- [0]=> 025- int(7) 026- } 027- } 028- array(0) { 029- } 030- Emulated prepares 031- array(0) { 032- } 033- array(0) { 034- } 035- bool(false) 036- array(1) { 037- [0]=> 038- array(2) { 039- ["first"]=> 040- string(2) "12" 041- [0]=> 042- string(2) "12" 043- } 044- } 045- array(0) { 046- } 047- array(1) { 048- [0]=> 049- array(2) { 050- ["first"]=> 051- string(2) "14" 052- [0]=> 053- string(2) "14" 054- } 055- } 056- array(0) { 057- } 058- array(0) { 059- } 060- array(1) { 061- [0]=> 062- array(2) { 063- ["first"]=> 064- int(16) 065- [0]=> 066- int(16) 067- } 068- }
1 (50%)
017+ 018+ Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1370 alter routine command denied to user ''@'localhost' for routine 'test.nores' in %s/bug80458.php:34 019+ Stack trace: 020+ #0 %s/bug80458.php(34): PDO->exec('DROP PROCEDURE ...') 021+ #1 {main} 022+ thrown in %s/bug80458.php on line 34 017- array(0) { 018- } 019- array(1) { 020- [0]=> 021- array(2) { 022- ["first"]=> 023- int(7) 024- [0]=> 025- int(7) 026- } 027- } 028- array(0) { 029- } 030- Emulated prepares 031- array(0) { 032- } 033- array(0) { 034- } 035- bool(false) 036- array(1) { 037- [0]=> 038- array(2) { 039- ["first"]=> 040- string(2) "12" 041- [0]=> 042- string(2) "12" 043- } 044- } 045- array(0) { 046- } 047- array(1) { 048- [0]=> 049- array(2) { 050- ["first"]=> 051- string(2) "14" 052- [0]=> 053- string(2) "14" 054- } 055- } 056- array(0) { 057- } 058- array(0) { 059- } 060- array(1) { 061- [0]=> 062- array(2) { 063- ["first"]=> 064- int(16) 065- [0]=> 066- int(16) 067- } 068- }