PHP mysqlnd svn commit: r117 - trunk/ext/mysqli/tests

[uwendel]

Author: uwendel
Date: 2007-03-13 13:50:28 +0100 (Tue, 13 Mar 2007)
New Revision: 117

Added:
   trunk/ext/mysqli/tests/mysqli_fetch_assoc_no_alias.phpt
Log:
Tiny BC break in mysqlnd or bug in libmysql, see Mantis #311. This is one cause why 
bug31668.phpt fails.


Added: trunk/ext/mysqli/tests/mysqli_fetch_assoc_no_alias.phpt
===================================================================
--- trunk/ext/mysqli/tests/mysqli_fetch_assoc_no_alias.phpt	2007-03-13 10:38:04 UTC (rev
116)
+++ trunk/ext/mysqli/tests/mysqli_fetch_assoc_no_alias.phpt	2007-03-13 12:50:28 UTC (rev
117)
@@ -0,0 +1,72 @@
+--TEST--
+mysqli_fetch_assoc()
+--SKIPIF--
+<?php require_once('skipif.inc'); ?>
+<?php require_once('skipifemb.inc'); ?>
+--FILE--
+<?php
+    include "connect.inc";    
+    require('table.inc');    
+        
+    if (!$res = mysqli_query($link, "SELECT 1, 2")) {
+        printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+    }
+    print "[002]\n";
+    var_dump(mysqli_fetch_assoc($res));
+    mysqli_free_result($res);
+    
+    if (!$res = mysqli_query($link, "SELECT 1 AS a, 2")) {
+        printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+    }
+    print "[004]\n";
+    var_dump(mysqli_fetch_assoc($res));
+    mysqli_free_result($res);
+    
+    if (!$res = mysqli_query($link, "SELECT 1 AS a, 2, 2 as '2'")) {
+        printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+    }
+    print "[006]\n";
+    var_dump(mysqli_fetch_assoc($res));
+    mysqli_free_result($res);
+    
+    if (!$res = mysqli_query($link, "SELECT 1 AS a, 2 as '2', 2")) {
+        printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
+    }
+    print "[008]\n";
+    var_dump(mysqli_fetch_assoc($res));
+    mysqli_free_result($res);
+       
+    mysqli_close($link);
+       
+    print "done!";
+?>
+--EXPECTF--
+[002]
+array(2) {
+  [1]=>
+  string(1) "1"
+  [2]=>
+  string(1) "2"
+}
+[004]
+array(2) {
+  ["a"]=>
+  string(1) "1"
+  [2]=>
+  string(1) "2"
+}
+[006]
+array(2) {
+  ["a"]=>
+  string(1) "1"
+  [2]=>
+  string(1) "2"
+}
+[008]
+array(2) {
+  ["a"]=>
+  string(1) "1"
+  [2]=>
+  string(1) "2"
+}
+done!
\ No newline at end of file