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
|
#
# WL#13168: Test MySQL command line client(mysql) --load-data-local-dir option
#
let $test_dir=$MYSQLTEST_VARDIR/tmp/wl13168;
let $wrong_test_dir=$MYSQLTEST_VARDIR/tmp/wl13168_2;
let $nonexistent_test_dir=$MYSQLTEST_VARDIR/tmp/wl13168_3;
let $test_file=$MYSQLTEST_VARDIR/tmp/wl13168/t1;
let $test_file_wrong_case=$MYSQLTEST_VARDIR/tmp/wl13168/T1;
let $test_file_wrong_file=$MYSQLTEST_VARDIR/tmp/wl13168/t2;
let $test_file_wrong_dir=$wrong_test_dir/t1;
let $test_file_wrong_dir_case=$MYSQLTEST_VARDIR/Tmp/wl13168/t1;
--echo # create the test directory
mkdir $test_dir;
--echo # create the wrong test directory
mkdir $wrong_test_dir;
--echo # create the test file
--write_file $test_file
1,a
2,b
EOF
--echo # create the wrong test file
--write_file $test_file_wrong_file
1,a
2,b
EOF
--echo # create a file in wrong dir
--write_file $test_file_wrong_dir
1,a
2,b
EOF
--echo # setup
CREATE TABLE test.wl13168(id INT PRIMARY KEY, data VARCHAR(50));
--echo # FR2/FR1.2: specify test_dir: should work
--exec $MYSQL --load_data_local_dir="$test_dir" -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
--echo # verify that the data are loaded
SELECT * FROM test.wl13168 ORDER BY id;
DELETE FROM test.wl13168;
--echo # FR1.1: specify empty (default): should fail
--error 1
--exec $MYSQL -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
--echo # FR1.1: specify explicit empty: should fail
--error 1
--exec $MYSQL --load_data_local_dir= -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
--echo # FR1.1: specify explicit empty and local-infile: should work
--exec $MYSQL --load_data_local_dir= --local-infile -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
DELETE FROM test.wl13168;
--echo # FR1.1: specify wrong file: should fail
--error 1
--exec $MYSQL --load_data_local_dir=$test_file_wrong_file -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
--echo # FR1.1: specify wrong dir: should fail
--error 1
--exec $MYSQL --load_data_local_dir=$test_file_wrong_dir -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
--echo # FR1.1: specify wrong dir and local-infile: should work
--exec $MYSQL --load_data_local_dir=$test_file_wrong_dir --local-infile -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
DELETE FROM test.wl13168;
--echo # Expect no error on MacOS and error on others
let expected_error=`SELECT if (CONVERT(@@version_compile_os USING LATIN1) RLIKE '^(osx|macos)', 0, 1)`;
--echo # FR1.5: specify wrong case dir: should fail except on MacOS
--error $expected_error
--exec $MYSQL --load_data_local_dir=$test_file -e "LOAD DATA LOCAL INFILE '$test_file_wrong_dir_case' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" > $MYSQLTEST_VARDIR/tmp/wl13168_log.txt
remove_file $MYSQLTEST_VARDIR/tmp/wl13168_log.txt;
DELETE FROM test.wl13168;
--echo # FR1.5: specify wrong case file: should fail except on MacOS
--error $expected_error
--exec $MYSQL --load_data_local_dir=$test_file -e "LOAD DATA LOCAL INFILE '$test_file_wrong_case' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" > $MYSQLTEST_VARDIR/tmp/wl13168_log.txt
remove_file $MYSQLTEST_VARDIR/tmp/wl13168_log.txt;
DELETE FROM test.wl13168;
--echo # Expect no error on windows and error on others
let expected_error=`select if (convert(@@version_compile_os using latin1) IN ("Win32","Win64","Windows") = 1, 0, 1)`;
--echo # FR2.1: specify non-existent dir: expect success on windows and failure on unix
--error $expected_error
--exec $MYSQL --load_data_local_dir=$nonexistent_test_dir -e "SELECT 1" > $MYSQLTEST_VARDIR/tmp/wl13168_log.txt
remove_file $MYSQLTEST_VARDIR/tmp/wl13168_log.txt;
SET @@global.local_infile = 0;
--echo # FR2/FR1.2: specify test_dir: should fail
--error 1
--exec $MYSQL --load_data_local_dir="$test_dir" -e "LOAD DATA LOCAL INFILE '$test_file' INTO TABLE test.wl13168 FIELDS TERMINATED BY ','" 2>&1
SELECT * FROM test.wl13168 ORDER BY id;
--echo # cleanup
DROP TABLE test.wl13168;
SET @@global.local_infile = 1;
force-rmdir $test_dir;
force-rmdir $wrong_test_dir;
|
