Test: /ext/pdo_mysql/tests/pdo_mysql_exec.phpt - Version 7.1.11 
There are 3 different diffs reported by users for this test.
| Count | Diff |
|---|---|
6 (75%) |
003+ [020] Expecting '0'/integer got '1'/integer when running 'CALL p(@version)', [00000] 00000
|
| 1 (13%) |
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
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', [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: 1304 PROCEDURE p already exists 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;', [42000] 42000 1304 PROCEDURE p already exists
009+
010+ Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user ''@'localhost' for routine 'test.p' in %s/pdo_mysql_exec.php on line 6
011+ [020] Expecting '0'/integer got ''/boolean when running 'CALL p(@version)', [42000] 42000 1370 execute command denied to user ''@'localhost' for routine 'test.p'
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 '5.6.24-enterprise-commercial-advanced'/string
027+
028+ 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
029+ [025] 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'
030+
031+ 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
032+ [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'
033+
034+ Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user ''@'localhost' for routine 'test.f' in %s/pdo_mysql_exec.php on line 108
035+
036+ Fatal error: Uncaught Error: Call to a member function fetchAll() on boolean in %s/pdo_mysql_exec.php:109
037+ Stack trace:
038+ #0 {main}
039+ thrown in %s/pdo_mysql_exec.php on line 109
|
| 1 (13%) |
001+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1874 InnoDB is in read only mode. in /software/php-7.1.11/ext/pdo_mysql/tests/mysql_pdo_test.inc on line 40
002+
003+ Warning: PDO::exec(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test.test' doesn't exist in /software/php-7.1.11/ext/pdo_mysql/tests/mysql_pdo_test.inc on line 41
004+
007+ [020] Expecting '0'/integer got '1'/integer when running 'CALL p(@version)', [00000] 00000
|