Annotation of embedaddon/php/ext/mysqli/tests/bug53503.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: Bug #53503 (mysqli::query returns false after successful LOAD DATA query)
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifconnectfailure.inc');
7:
8: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
9: die("skip Cannot connect to MySQL");
10:
11: include_once("local_infile_tools.inc");
12: if ($msg = check_local_infile_support($link, $engine))
13: die(sprintf("skip %s, [%d] %s", $msg, $link->errno, $link->error));
14:
15: mysqli_close($link);
16:
17: ?>
18: --FILE--
19: <?php
20: require_once("connect.inc");
21:
22: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
23: printf("[001] Connect failed, [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
24: }
25:
26: if (!$link->query("DROP TABLE IF EXISTS test")) {
27: printf("[002] [%d] %s\n", $link->errno, $link->error);
28: }
29:
30: if (!$link->query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine)) {
31: printf("[003] [%d] %s\n", $link->errno, $link->error);
32: }
33:
34: if (FALSE == file_put_contents('bug53503.data', "1\n2\n3\n"))
35: printf("[004] Failed to create CVS file\n");
36:
37: if (!$link->query("SELECT 1 FROM DUAL"))
38: printf("[005] [%d] %s\n", $link->errno, $link->error);
39:
40: if (!$link->query("LOAD DATA LOCAL INFILE 'bug53503.data' INTO TABLE test")) {
41: printf("[006] [%d] %s\n", $link->errno, $link->error);
42: echo "bug";
43: } else {
44: echo "done";
45: }
46: $link->close();
47: ?>
48: --CLEAN--
49: <?php
50: require_once('connect.inc');
51:
52: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
53: printf("[clean] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
54: $host, $user, $db, $port, $socket);
55: }
56:
57: if (!$link->query($link, 'DROP TABLE IF EXISTS test')) {
58: printf("[clean] Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
59: }
60:
61: $link->close();
62:
63: unlink('bug53503.data');
64: ?>
65: --EXPECT--
66: done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>