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

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

Count Diff
1 (50%)
003+ 004+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 003- [035] With emulated PS it works but makes no sense given that exec() returns sort of affected rows... 004- done! 005+ [018] Expecting '0'/integer got ''/boolean when running 'DROP PROCEDURE IF EXISTS p', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 006+ 007+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 008+ [019] Expecting '0'/integer got ''/boolean when running 'CREATE PROCEDURE p(OUT ver_param VARCHAR(255)) BEGIN SELECT VERSION() INTO ver_param; END;', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 009+ 010+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 011+ [020] Expecting '1'/integer got ''/boolean when running 'CALL p(@version)', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 012+ [022] Data seems wrong, dumping 013+ array(1) { 014+ [0]=> 015+ array(1) { 016+ ["p_version"]=> 017+ NULL 018+ } 019+ } 020+ 021+ Notice: Undefined variable: p_version in %s/pdo_mysql_exec.php on line 85 022+ 023+ Notice: Undefined variable: p_version in %s/pdo_mysql_exec.php on line 87 024+ 025+ Notice: Undefined variable: p_version in %s/pdo_mysql_exec.php on line 87 026+ [024] Found different version strings, SP returned ''/NULL, SELECT returned '10.6.7-MariaDB'/string 027+ 028+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 029+ [025] Expecting '0'/integer got ''/boolean when running 'DROP PROCEDURE IF EXISTS p', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 030+ 031+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 032+ [027] Expecting '0'/integer got ''/boolean when running 'DROP FUNCTION IF EXISTS f', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 033+ 034+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 6 035+ [028] Expecting '0'/integer got ''/boolean when running 'CREATE FUNCTION f( ver_param VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC RETURN ver_param;', [HY000] HY000 1728 Cannot load from mysql.proc. The table is probably corrupted 036+ 037+ Warning: PDO::query(): SQLSTATE[HY000]: General error: 1728 Cannot load from mysql.proc. The table is probably corrupted in %s/pdo_mysql_exec.php on line 108 038+ 039+ Fatal error: Uncaught Error: Call to a member function fetchAll() on bool in %s/pdo_mysql_exec.php:109 040+ Stack trace: 041+ #0 {main} 042+ thrown in %s/pdo_mysql_exec.php on line 109
1 (50%)
003+ 004+ Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 1370 alter routine command denied to user ''@'localhost' for routine 'test.p' in %s/pdo_mysql_exec.php on line 6 005+ [018] Expecting '0'/integer got ''/boolean when running 'DROP PROCEDURE IF EXISTS p', [42000] 42000 1370 alter routine command denied to user ''@'localhost' for routine 'test.p' 006+ 007+ Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 1370 alter routine command denied to user ''@'localhost' for routine 'test.f' in %s/pdo_mysql_exec.php on line 6 008+ [027] Expecting '0'/integer got ''/boolean when running 'DROP FUNCTION IF EXISTS f', [42000] 42000 1370 alter routine command denied to user ''@'localhost' for routine 'test.f'