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

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

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

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: 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.32'/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

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: 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.15'/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

001+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in /home/tpearson/Database/src/php-5.4.16/ext/pdo_mysql/tests/mysql_pdo_test.inc on line 39

002+

003+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in /home/tpearson/Database/src/php-5.4.16/ext/pdo_mysql/tests/mysql_pdo_test.inc on line 40

004+

005+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in /home/tpearson/Database/src/php-5.4.16/ext/pdo_mysql/tests/mysql_pdo_test.inc on line 41

006+

007+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

008+ [002] Expecting '0'/integer got ''/boolean when running 'DROP TABLE IF EXISTS test', [3D000] 3D000 1046 No database selected

009+

010+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

011+ [003] Expecting '0'/integer got ''/boolean when running 'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, col1 CHAR(10)) ENGINE=MyISAM', [3D000] 3D000 1046 No database selected

012+

013+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

014+ [004] Expecting '1'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (1, 'a')', [3D000] 3D000 1046 No database selected

015+

016+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

017+ [005] Expecting '2'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (2, 'b'), (3, 'c')', [3D000] 3D000 1046 No database selected

018+

019+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

020+ [006] Expecting '1'/integer got ''/boolean when running 'UPDATE test SET id = 4 WHERE id = 3', [3D000] 3D000 1046 No database selected

021+

022+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

023+ [007] Expecting '2'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (1, 'd') ON DUPLICATE KEY UPDATE id = 3', [3D000] 3D000 1046 No database selected

024+

025+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

026+ [008] Expecting '0'/integer got ''/boolean when running 'UPDATE test SET id = 5 WHERE id = 5', [3D000] 3D000 1046 No database selected

027+

028+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

029+ [009] Expecting '1'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (5, 'e') ON DUPLICATE KEY UPDATE id = 6', [3D000] 3D000 1046 No database selected

030+

031+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

032+ [010] Expecting '2'/integer got ''/boolean when running 'REPLACE INTO test(id, col1) VALUES (5, 'f')', [3D000] 3D000 1046 No database selected

033+

034+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

035+ [011] Expecting '1'/integer got ''/boolean when running 'REPLACE INTO test(id, col1) VALUES (6, 'g')', [3D000] 3D000 1046 No database selected

036+

037+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

038+ [012] Expecting '4'/integer got ''/boolean when running 'DELETE FROM test WHERE id > 2', [3D000] 3D000 1046 No database selected

039+

040+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

041+ [013] Expecting '0'/integer got ''/boolean when running 'DROP TABLE test', [3D000] 3D000 1046 No database selected

042+

043+ 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

044+ [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

045+

046+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

047+ [036] Expecting '0'/integer got ''/boolean when running 'CREATE TABLE test(id INT NOT NULL PRIMARY KEY, col1 CHAR(10)) ENGINE=MyISAM', [3D000] 3D000 1046 No database selected

048+

049+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

050+ [037] Expecting '1'/integer got ''/boolean when running 'INSERT INTO test(id, col1) VALUES (1, 'a')', [3D000] 3D000 1046 No database selected

051+

052+ Warning: PDO::exec(): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected in %s/pdo_mysql_exec.php on line 6

053+ [034] Expecting 0/integer got /boolean, [3D000] array (

054+ 0 => '3D000',

055+ 1 => 1046,

056+ 2 => 'No database selected',

057+ )

058+ [035] With emulated PS it works but makes no sense given that exec() returns sort of affected rows...

059+ done!