PHP mysqlnd svn commit: r1313 - trunk/tests/ext/pdo_mysql

[uwendel]

Author: uwendel
Date: 2008-03-03 14:24:20 +0100 (Mon, 03 Mar 2008)
New Revision: 1313

Added:
   trunk/tests/ext/pdo_mysql/pdo_mysql_stmt_errorinfo.phpt
Log:
PDOStatmenent::errorInfo(): native vs. emulated


Added: trunk/tests/ext/pdo_mysql/pdo_mysql_stmt_errorinfo.phpt
===================================================================
--- trunk/tests/ext/pdo_mysql/pdo_mysql_stmt_errorinfo.phpt	                        (rev
0)
+++ trunk/tests/ext/pdo_mysql/pdo_mysql_stmt_errorinfo.phpt	2008-03-03 13:24:20 UTC (rev
1313)
@@ -0,0 +1,63 @@
+--TEST--
+MySQL PDOStatement->errorInfo();
+--SKIPIF--
+<?php
+require_once('skipif.inc');
+require_once('mysql_pdo_test.inc');
+MySQLPDOTest::skip();
+$db = MySQLPDOTest::factory();
+?>
+--FILE--
+<?php
+	require_once('mysql_pdo_test.inc');
+	$db = MySQLPDOTest::factory();
+	MySQLPDOTest::createTestTable($db);
+
+	printf("Testing native PS...\n");
+	try {
+		$db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
+		if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
+			printf("[002] Unable to turn off emulated prepared statements\n");
+
+		$stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
+		$stmt->execute();
+		var_dump($stmt->errorInfo());
+
+	} catch (PDOException $e) {
+		printf("[001] %s [%s] %s\n",
+			$e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
+	}
+
+	printf("Testing emulated PS...\n");
+	try {
+		$db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
+		if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
+			printf("[004] Unable to turn on emulated prepared statements\n");
+
+		$stmt = $db->prepare('SELECT id FROM ihopeitdoesnotexist ORDER BY id ASC');
+		$stmt->execute();
+		var_dump($stmt->errorInfo());
+
+	} catch (PDOException $e) {
+		printf("[003] %s [%s] %s\n",
+			$e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo()));
+	}
+	print "done!";
+?>
+--EXPECTF--
+Testing native PS...
+
+Warning: PDOStatement::execute(): SQLSTATE[42S02]: Base table or view not found: 1146
Table '%s.ihopeitdoesnotexist' doesn't exist in %s on line %d
+array(3) {
+  [0]=>
+  string(5) "42S02"
+  [1]=>
+  int(1146)
+  [2]=>
+  string(49) "Table '%s.ihopeitdoesnotexist' doesn't exist"
+}
+Testing emulated PS...
+
+Warning: PDO::prepare(): SQLSTATE[42S02]: Base table or view not found: 1146 Table
'%s.ihopeitdoesnotexist' doesn't exist in %s on line %d
+
+Fatal error: Call to a member function execute() on a non-object in %s on line %d
\ No newline at end of file