1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
--TEST--
LOAD DATA INFILE - open_basedir
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifconnectfailure.inc');
if (file_exists('./simple.csv') && !unlink('./simple.csv'))
die("skip Cannot remove previous CSV file");
if (!$fp = fopen('./simple.csv', 'w'))
die("skip Cannot create test CSV file");
fclose($fp);
@unlink('./simple.csv');
?>
--INI--
safe_mode=0
open_basedir="."
--FILE--
<?php
@include_once("connect.inc");
if (!isset($db)) {
// run-tests, I love you for not allowing me to set ini settings dynamically
print "[006] [1148] The used command is not allowed with this MySQL version
[007] [0]
[008] LOAD DATA not run?
[010] [1148] The used command is not allowed with this MySQL version
done!";
die();
}
require('table.inc');
mysql_close($link);
if ($socket)
$host = sprintf("%s:%s", $host, $socket);
else if ($port)
$host = sprintf("%s:%s", $host, $port);
if (!$link = mysql_connect($host, $user, $passwd, true, 128)) {
printf("[001] Cannot connect using host '%s', user '%s', password '****', [%d] %s\n",
$host, $user, $passwd,
mysql_errno(), mysql_error());
}
if (!mysql_select_db($db, $link)) {
printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
if (file_exists('./simple.csv'))
unlink('./simple.csv');
if (!$fp = fopen('./simple.csv', 'w'))
printf("[003] Cannot open CSV file\n");
if (ini_get('unicode.semantics')) {
if (!fwrite($fp, (binary)"'97';'x';\n") ||
!fwrite($fp, (binary)"'98';'y';\n") ||
!fwrite($fp, (binary)"99;'z';\n")) {
printf("[004] Cannot write CVS file '%s'\n", $file);
}
} else {
if (!fwrite($fp, "97;'x';\n") ||
!fwrite($fp, "98;'y';\n") ||
!fwrite($fp, "99;'z';\n")) {
printf("[005] Cannot write CVS file '%s'\n", $file);
}
}
fclose($fp);
$sql = sprintf("LOAD DATA LOCAL INFILE '%s'
INTO TABLE test
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n'",
mysql_real_escape_string(realpath('./simple.csv'), $link));
if (!mysql_query($sql, $link))
printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
if (!($res = mysql_query('SELECT label FROM test WHERE id = 97', $link)) ||
!($row = mysql_fetch_assoc($res)) ||
!mysql_free_result($res))
printf("[007] [%d] '%s'\n", mysql_errno($link), mysql_error($link));
if ($row['label'] != "x")
printf("[008] LOAD DATA not run?\n");
if (!mysql_query('DELETE FROM test', $link))
printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
$sql = "LOAD DATA LOCAL INFILE '/tmp/idonotexist'
INTO TABLE test
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\''
LINES TERMINATED BY '\n'";
if (!mysql_query($sql, $link))
printf("[010] [%d] %s\n", mysql_errno($link), mysql_error($link));
mysql_close($link);
unlink("./simple.csv");
print "done!";
?>
--EXPECTF--
[006] [1148] %s
[007] [0] ''
[008] LOAD DATA not run?
[010] [1148] %s
done!
|