List:Commits« Previous MessageNext Message »
From:grichter Date:March 27 2007 6:34pm
Subject:PHP mysqlnd svn commit: r270 - trunk/ext/mysqli/tests
View as plain text  
Author: grichter
Date: 2007-03-27 18:34:14 +0200 (Tue, 27 Mar 2007)
New Revision: 270

Modified:
   trunk/ext/mysqli/tests/015.phpt
Log:
fixed test: tables needs to be innodb


Modified: trunk/ext/mysqli/tests/015.phpt
===================================================================
--- trunk/ext/mysqli/tests/015.phpt	2007-03-27 16:26:16 UTC (rev 269)
+++ trunk/ext/mysqli/tests/015.phpt	2007-03-27 16:34:14 UTC (rev 270)
@@ -1,5 +1,5 @@
 --TEST--
-mysqli autocommit/commit/rollback with myisam 
+mysqli autocommit/commit/rollback with innodb 
 --SKIPIF--
 <?php	
 	require_once('skipif.inc');
@@ -26,7 +26,7 @@
 
   	mysqli_query($link,"DROP TABLE IF EXISTS ac_01");
 
-	mysqli_query($link,"CREATE TABLE ac_01(a int, b varchar(10))");
+	mysqli_query($link,"CREATE TABLE ac_01(a int, b varchar(10)) Engine=InnoDB");
 
 	mysqli_query($link, "INSERT INTO ac_01 VALUES (1, 'foobar')");
 	mysqli_autocommit($link, FALSE);
@@ -36,7 +36,7 @@
 
 	mysqli_rollback($link);
 
-	$result = mysqli_query($link, "SELECT * FROM ac_01");
+	$result = mysqli_query($link, "SELECT SQL_NO_CACHE * FROM ac_01");
 	$row = mysqli_fetch_row($result);
 	mysqli_free_result($result);
 
@@ -57,9 +57,9 @@
 --EXPECTF--
 array(2) {
   [0]=>
-  %s(1) "2"
+  %s(1) "1"
   [1]=>
-  %s(4) "egon"
+  %s(6) "foobar"
 }
 array(2) {
   [0]=>

Thread
PHP mysqlnd svn commit: r270 - trunk/ext/mysqli/testsgrichter27 Mar