uw              Fri Dec 28 15:06:02 2007 UTC

  Modified files:              (Branch: PHP_5_3)
    /php-src/ext/mysqli/tests   003.phpt 
  Log:
  Sooner or later these old 0*.phpt tests had to bite us - fixing SQL syntax,
  HEAD sync will follow.
  
  
http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/003.phpt?r1=1.5.2.1.4.1&r2=1.5.2.1.4.2&diff_format=u
Index: php-src/ext/mysqli/tests/003.phpt
diff -u php-src/ext/mysqli/tests/003.phpt:1.5.2.1.4.1 
php-src/ext/mysqli/tests/003.phpt:1.5.2.1.4.2
--- php-src/ext/mysqli/tests/003.phpt:1.5.2.1.4.1       Wed Oct 10 10:06:53 2007
+++ php-src/ext/mysqli/tests/003.phpt   Fri Dec 28 15:06:02 2007
@@ -1,42 +1,64 @@
 --TEST--
 mysqli connect
 --SKIPIF--
-<?php 
-require_once('skipif.inc'); 
+<?php
+require_once('skipif.inc');
 require_once('skipifconnectfailure.inc');
 ?>
 --FILE--
 <?php
        include "connect.inc";
-       
-       /*** test mysqli_connect 127.0.0.1 ***/
+
        $link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
        mysqli_query($link, "SET sql_mode=''");
-               
+
        if (!mysqli_query($link,"DROP TABLE IF EXISTS test_bind_result"))
                printf("[001] [%d] %s\n", mysqli_errno($link), 
mysqli_error($link));
 
-       $rc = mysqli_query($link,"CREATE TABLE test_bind_result(c1 date, c2 
time, 
-                                                                               
                                c3 timestamp(14), 
-                                                                               
                                c4 year, 
-                                                                               
                                c5 datetime, 
-                                                                               
                                c6 timestamp(4), 
-                                                                               
                                c7 timestamp(6)) ENGINE=" . $engine);
+       $rc = @mysqli_query($link,"CREATE TABLE test_bind_result(
+               c1 date,
+               c2 time,
+               c3 timestamp(14),
+               c4 year,
+               c5 datetime,
+               c6 timestamp(4),
+               c7 timestamp(6)) ENGINE=" . $engine);
+
+       /*
+       Seems that not all MySQL 6.0 installations use defaults that ignore the 
display widths.
+       From the manual:
+       From MySQL 4.1.0 on, TIMESTAMP display format differs from that of 
earlier MySQL releases:
+       [...]
+       Display widths (used as described in the preceding section) are no 
longer supported.
+       In other words, for declarations such as TIMESTAMP(2), TIMESTAMP(4), 
and so on,
+       the display width is ignored.
+       [...]
+       */
+       if (!$rc)
+               $rc = @mysqli_query($link,"CREATE TABLE test_bind_result(
+                       c1 date,
+                       c2 time,
+                       c3 timestamp,
+                       c4 year,
+                       c5 datetime,
+                       c6 timestamp,
+                       c7 timestamp) ENGINE=" . $engine);
 
        if (!$rc)
                printf("[002] [%d] %s\n", mysqli_errno($link), 
mysqli_error($link));
 
-       $rc = mysqli_query($link, "INSERT INTO test_bind_result 
VALUES('2002-01-02',
-                                                                               
                                        '12:49:00',
-                                                                               
                                        '2002-01-02 17:46:59', 
-                                                                               
                                        2010,
-                                                                               
                                        '2010-07-10', 
-                                                                               
                                        '2020','1999-12-29')");
+       $rc = mysqli_query($link, "INSERT INTO test_bind_result VALUES(
+               '2002-01-02',
+               '12:49:00',
+               '2002-01-02 17:46:59',
+               2010,
+               '2010-07-10',
+               '2020','1999-12-29')");
        if (!$rc)
                printf("[003] [%d] %s\n", mysqli_errno($link), 
mysqli_error($link));
 
-       $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result");
+       $stmt = mysqli_prepare($link, "SELECT c1, c2, c3, c4, c5, c6, c7 FROM 
test_bind_result");
        mysqli_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7);
        mysqli_execute($stmt);
        mysqli_fetch($stmt);

-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to