| 1 |
--source include/no_valgrind_without_big.inc |
| 2 |
|
| 3 |
--echo #----------------------------------------------------------------------- |
| 4 |
--echo # Setup |
| 5 |
let server_log= $MYSQLTEST_VARDIR/log/mysqld.1.err; |
| 6 |
let SEARCH_FILE= $server_log; |
| 7 |
let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect; |
| 8 |
--echo #----------------------------------------------------------------------- |
| 9 |
|
| 10 |
--echo # Search for : --secure-file-priv is set to NULL. Operations |
| 11 |
--echo # related to importing and exporting data are |
| 12 |
--echo # disabled |
| 13 |
let SEARCH_PATTERN= --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled; |
| 14 |
--source include/search_pattern.inc |
| 15 |
|
| 16 |
connect(test4_con,localhost,root,,,,,); |
| 17 |
show variables like 'secure_file_priv'; |
| 18 |
|
| 19 |
use test; |
| 20 |
--disable_warnings |
| 21 |
drop table if exists secure_file_priv_test_null; |
| 22 |
--enable_warnings |
| 23 |
create table secure_file_priv_test_null(c1 int); |
| 24 |
insert into secure_file_priv_test_null values (1), (2), (3), (4); |
| 25 |
--error 1290 |
| 26 |
select * from secure_file_priv_test_null into outfile 'blah'; |
| 27 |
--error 1290 |
| 28 |
select * from secure_file_priv_test_null into outfile 'null/blah'; |
| 29 |
drop table secure_file_priv_test_null; |
| 30 |
|
| 31 |
connection default; |
| 32 |
disconnect test4_con; |
| 33 |
|
| 34 |
--echo #----------------------------------------------------------------------- |
| 35 |
|
| 36 |
--echo # Clean-up |
| 37 |
--disable_warnings |
| 38 |
--source include/force_restart.inc |
| 39 |
--enable_warnings |
| 40 |
|
| 41 |
--echo #----------------------------------------------------------------------- |