| 1 |
--echo # |
| 2 |
--echo # Bug50373 --secure-file-priv="" |
| 3 |
--echo # |
| 4 |
CREATE TABLE t1 (c1 VARCHAR(50)); |
| 5 |
INSERT INTO t1 VALUES ("one"),("two"),("three"),("four"),("five"); |
| 6 |
SHOW VARIABLES LIKE 'secure_file_priv'; |
| 7 |
--disable_query_log |
| 8 |
# Atempt to create a file where we normally aren't allowed to create one. |
| 9 |
# Use the mysql-test dir |
| 10 |
--let $PROTECTED_FILE=$MYSQLTEST_VARDIR/tmp/bug50373.txt |
| 11 |
--eval SELECT * FROM t1 INTO OUTFILE '$PROTECTED_FILE'; |
| 12 |
DELETE FROM t1; |
| 13 |
--eval LOAD DATA INFILE '$PROTECTED_FILE' INTO TABLE t1; |
| 14 |
SELECT * FROM t1; |
| 15 |
--eval SELECT load_file('$PROTECTED_FILE') AS loaded_file; |
| 16 |
--enable_query_log |
| 17 |
remove_file $PROTECTED_FILE; |
| 18 |
DROP TABLE t1; |
| 19 |
|