1--TEST-- 2Bug #53649 (mysql_query with "load data" unable to save result set) 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifconnectfailure.inc'); 7 8if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { 9 die(sprintf("skip Connect failed, [%d] %s\n", mysqlerrno(), mysqli_error())); 10} 11 12if (!mysql_query("DROP TABLE IF EXISTS test", $link) || 13 !mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, $link)) 14 die(sprintf("skip [%d] %s\n", mysql_errno($link), mysql_error($link))); 15 16if (false === file_put_contents('bug53649.data', "1\n2\n3\n")) 17 die(sprintf("skip Failed to create data file\n")); 18 19if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link) && 20 1148 == mysql_errno($link)) 21 die("skip LOAD DATA LOAD INFILE not allowed\n"); 22?> 23--FILE-- 24<?php 25 require_once("connect.inc"); 26 27 if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { 28 printf("[001] Connect failed, [%d] %s\n", mysqlerrno(), mysqli_error()); 29 } 30 31 if (!mysql_query("DROP TABLE IF EXISTS test", $link)) { 32 printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link)); 33 } 34 35 if (!mysql_query("CREATE TABLE test (dump1 INT UNSIGNED NOT NULL PRIMARY KEY) ENGINE=" . $engine, $link)) { 36 printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); 37 } 38 39 if (false === file_put_contents('bug53649.data', "1\n2\n3\n")) 40 printf("[004] Failed to create data file\n"); 41 42 if (!mysql_query("SELECT 1 FROM DUAL", $link)) 43 printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); 44 45 if (!mysql_query("LOAD DATA LOCAL INFILE 'bug53649.data' INTO TABLE test", $link)) { 46 printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); 47 echo "bug"; 48 } else { 49 echo "done"; 50 } 51 mysql_close($link); 52?> 53--CLEAN-- 54<?php 55require_once('connect.inc'); 56 57if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { 58 printf("[clean] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 59 $host, $user, $db, $port, $socket); 60} 61 62if (!mysql_query($link, 'DROP TABLE IF EXISTS test', $link)) { 63 printf("[clean] Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 64} 65 66mysql_close($link); 67 68unlink('bug53649.data'); 69?> 70--EXPECTF-- 71Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in %s on line %d 72done 73
