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

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

Count Diff
13 (65%)
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
2 (10%)
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 MariaDB server version for the right syntax to use near 'THIS IS NOT VALID SQL, I HOPE' at line 1
2 (10%)
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.20'/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 boolean in %s/pdo_mysql_exec.php on line 109
1 (5%)
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
004+
003- [035] With emulated PS it works but makes no sense given that exec() returns sort of affected rows...
004- done!
005+ Warning: PDO::exec(): SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) in %s/pdo_mysql_exec.php on line 6
006+ [028] Expecting '0'/integer got ''/boolean when running 'CREATE FUNCTION f( ver_param VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC RETURN ver_param;', [HY000] HY000 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
007+
008+ Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION test.f does not exist in %s/pdo_mysql_exec.php on line 108
009+
010+ Fatal error: Call to a member function fetchAll() on boolean in %s/pdo_mysql_exec.php on line 109
1 (5%)
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.12-log'/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[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) 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 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
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 boolean in %s/pdo_mysql_exec.php on line 109
1 (5%)