Debian Codegraph @

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

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