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
