2
# Bug58747 breaks secure_file_priv+not secure yet+still accesses other folders
5
# we do the windows specific relative directory testing
7
--source include/windows.inc
9
CREATE TABLE t1 (c1 longtext);
10
INSERT INTO t1 values ('a');
12
LET $MYSQL_TMP_DIR_UCASE= `SELECT upper('$MYSQL_TMP_DIR')`;
13
LET $MYSQL_TMP_DIR_LCASE= `SELECT lower('$MYSQL_TMP_DIR')`;
16
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
17
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR/B11764517.tmp';
19
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
20
show global variables like 'secure_file_priv';
22
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
23
eval SELECT load_file('$MYSQL_TMP_DIR\\\\B11764517.tmp') AS x;
25
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
26
eval SELECT load_file('$MYSQL_TMP_DIR/B11764517.tmp') AS x;
28
--replace_result $MYSQL_TMP_DIR_UCASE MYSQL_TMP_DIR_UCASE
29
eval SELECT load_file('$MYSQL_TMP_DIR_UCASE/B11764517.tmp') AS x;
31
--replace_result $MYSQL_TMP_DIR_LCASE MYSQL_TMP_DIR_LCASE
32
eval SELECT load_file('$MYSQL_TMP_DIR_LCASE/B11764517.tmp') AS x;
34
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
35
eval SELECT load_file('$MYSQL_TMP_DIR\\\\..a..\\\\..\\\\..\\\\B11764517.tmp') AS x;
37
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
38
eval LOAD DATA INFILE '$MYSQL_TMP_DIR\\\\B11764517.tmp' INTO TABLE t1;
40
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
41
eval LOAD DATA INFILE '$MYSQL_TMP_DIR/B11764517.tmp' INTO TABLE t1;
43
--replace_result $MYSQL_TMP_DIR_UCASE MYSQL_TMP_DIR_UCASE
44
eval LOAD DATA INFILE '$MYSQL_TMP_DIR_UCASE/B11764517.tmp' INTO TABLE t1;
46
--replace_result $MYSQL_TMP_DIR_LCASE MYSQL_TMP_DIR_LCASE
47
eval LOAD DATA INFILE '$MYSQL_TMP_DIR_LCASE/B11764517.tmp' INTO TABLE t1;
49
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
50
--error ER_OPTION_PREVENTS_STATEMENT
51
eval LOAD DATA INFILE "$MYSQL_TMP_DIR\\\\..a..\\\\..\\\\..\\\\B11764517.tmp" into table t1;
53
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
54
--error ER_OPTION_PREVENTS_STATEMENT
55
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR\\\\..a..\\\\..\\\\..\\\\B11764517-2.tmp';
57
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
58
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR\\\\B11764517-2.tmp';
60
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
61
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR/B11764517-3.tmp';
63
--replace_result $MYSQL_TMP_DIR_UCASE MYSQL_TMP_DIR_UCASE
64
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR_UCASE/B11764517-4.tmp';
66
--replace_result $MYSQL_TMP_DIR_LCASE MYSQL_TMP_DIR_LCASE
67
eval SELECT * FROM t1 INTO OUTFILE '$MYSQL_TMP_DIR_LCASE/B11764517-5.tmp';
70
--remove_file $MYSQL_TMP_DIR/B11764517.tmp;
72
--remove_file $MYSQL_TMP_DIR/B11764517-2.tmp;
74
--remove_file $MYSQL_TMP_DIR/B11764517-3.tmp;
76
--remove_file $MYSQL_TMP_DIR/B11764517-4.tmp;
78
--remove_file $MYSQL_TMP_DIR/B11764517-5.tmp;