Debian Codegraph @

mysql-test/suite/sys_vars/t/secure_file_priv_basic.test

raw
1 --source include/not_var_link.inc
2
3 #
4 # only global
5 #
6 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
7 select @@global.secure_file_priv;
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.secure_file_priv;
10 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
11 show global variables like 'secure_file_priv';
12 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
13 show session variables like 'secure_file_priv';
14 --disable_warnings
15 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
16 select * from performance_schema.global_variables where variable_name='secure_file_priv';
17 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
18 select * from performance_schema.session_variables where variable_name='secure_file_priv';
19 --enable_warnings
20
21 #
22 # show that it's read-only
23 #
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set global secure_file_priv=1;
26 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
27 set session secure_file_priv=1;