Test: /ext/pdo_mysql/tests/pdo_mysql_exec.phpt - Version 5.5.21-dev    

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

Count Diff
1 (50%)
003+ [020] Expecting '0'/integer got '1'/integer when running 'CALL p(@version)', [00000] 00000 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THIS IS NOT VALID SQL, I HOPE' at line 1
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
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.5.29'/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::exec(): SQLSTATE[42000]: Syntax error or access violation: 1304 FUNCTION f already exists 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;', [42000] 42000 1304 FUNCTION f already exists
036+
037+ 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
038+
039+ Fatal error: Call to a member function fetchAll() on a non-object in %s/pdo_mysql_exec.php on line 109