Debian Codegraph @

mysql-test/suite/auth_sec/t/secure_file_priv_null.test

raw
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 #-----------------------------------------------------------------------