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

[uwendel]

Author: uwendel
Date: 2007-10-23 18:01:02 +0200 (Tue, 23 Oct 2007)
New Revision: 1138

Added:
   trunk/tests/ext/pdo_mysql/pdo_mysql_fetch_both.phpt
Log:
FETCH_BOTH gets confused by SELECT 1


Added: trunk/tests/ext/pdo_mysql/pdo_mysql_fetch_both.phpt
===================================================================
--- trunk/tests/ext/pdo_mysql/pdo_mysql_fetch_both.phpt	2007-10-23 13:50:40 UTC (rev 1137)
+++ trunk/tests/ext/pdo_mysql/pdo_mysql_fetch_both.phpt	2007-10-23 16:01:02 UTC (rev 1138)
@@ -0,0 +1,60 @@
+--TEST--
+MySQL PDOStatement->fetch()
+--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();
+
+	function fetch($offset, &$db, $query, $expect = null) {
+
+		try {
+			$stmt = $db->query('SELECT 1');
+			$num = $stmt->fetch(PDO::FETCH_NUM);
+
+			$stmt = $db->query('SELECT 1');
+			$assoc = $stmt->fetch(PDO::FETCH_ASSOC);
+
+			$stmt = $db->query('SELECT 1');
+			$both = $stmt->fetch(PDO::FETCH_BOTH);
+
+			$computed_both = array_merge($num, $assoc);
+			if ($computed_both != $both) {
+				printf("[%03d] Suspicious FETCH_BOTH result, dumping\n", $offset);
+				var_dump($computed_both);
+				var_dump($both);
+			}
+
+			if (!is_null($expect) && ($expect != $both)) {
+				printf("[%03d] Expected differes from returned data, dumping\n", $offset);
+				var_dump($expect);
+				var_dump($both);
+			}
+
+		} catch (PDOException $e) {
+
+			printf("[%03d] %s, [%s] %s\n",
+				$offset,
+				$e->getMessage(), $db->errroCode(), implode(' ', $db->errorInfo()));
+
+		}
+
+	}
+
+	try {
+
+		fetch(2, &$db, 'SELECT 1', array(0 => '1', '1' => '1'));
+
+	} catch (PDOException $e) {
+		printf("[001] %s [%s] %s\n",
+			$e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
+	}
+	print "done!";
+--EXPECTF--
+done!
\ No newline at end of file