Debian Codegraph @

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

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