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

Bug #63185 nextRowset() ignores MySQL errors with native prepared statements
Submitted: 2012-09-29 11:31:19 Modified: 2020-12-08 09:41:00
From: dexen.devries Assigned:
Status: Closed Package: PDO MySQL
PHP Version: 5.4.7 OS: linux

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

Count Diff
1 (50%)
001+ Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/bug63185.php:7 002+ Stack trace: 003+ #0 %s/bug63185.php(7): PDO->exec('DROP PROCEDURE ...') 004+ #1 {main} 005+ thrown in %s/bug63185.php on line 7 001- array(1) { 002- [0]=> 003- array(2) { 004- ["foo"]=> 005- string(1) "x" 006- [0]=> 007- string(1) "x" 008- } 009- } 010- SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.no_such_table' doesn't exist 011- array(1) { 012- [0]=> 013- array(2) { 014- ["foo"]=> 015- string(1) "x" 016- [0]=> 017- string(1) "x" 018- } 019- } 020- SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.no_such_table' doesn't exist 021- array(0) { 022- }
1 (50%)
001+ Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1370 alter routine command denied to user ''@'localhost' for routine 'test.test_procedure_error_at_second' in %s/bug63185.php:7 002+ Stack trace: 003+ #0 %s/bug63185.php(7): PDO->exec('DROP PROCEDURE ...') 004+ #1 {main} 005+ thrown in %s/bug63185.php on line 7 001- array(1) { 002- [0]=> 003- array(2) { 004- ["foo"]=> 005- string(1) "x" 006- [0]=> 007- string(1) "x" 008- } 009- } 010- SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.no_such_table' doesn't exist 011- array(1) { 012- [0]=> 013- array(2) { 014- ["foo"]=> 015- string(1) "x" 016- [0]=> 017- string(1) "x" 018- } 019- } 020- SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.no_such_table' doesn't exist 021- array(0) { 022- }