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

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

Count Diff
48 (94%)
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 (2%)
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 a non-object in %s/pdo_mysql_exec.php on line 109
1 (2%)
001+ Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 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 in %s/pdo_mysql_exec.php on line 6
002+ [016] [42000] 42000 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
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
001- Warning: PDO::exec(): SQLSTATE[42000]: Syntax error or access violation: 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 in %s on line %d
002- [016] [42000] 42000 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 %d
1 (2%)