Annotation of embedaddon/php/ext/mysqli/tests/bug53503.phpt, revision 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>