Debian Codegraph @

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

raw
1 #
2 # show the global and session values;
3 #
4
5 # workaround to adjust for the directory separators being different in
6 # different OSes : slash on unixes and backslash or slash on windows.
7 # TODO: fix with a proper comparison in mysqltest
8 let $rcd= `SELECT REPLACE('$MYSQL_CHARSETSDIR', '\\\\\', '.')`;
9 let $rcd= `SELECT REPLACE('$rcd', '/', '.')`;
10 let $regex_charsetdir= /$rcd[\\\/]/MYSQL_CHARSETSDIR/;
11
12 --replace_regex $regex_charsetdir
13 select @@global.character_sets_dir;
14
15 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
16 select @@session.character_sets_dir;
17 --replace_regex $regex_charsetdir
18 show global variables like 'character_sets_dir';
19 --replace_regex $regex_charsetdir
20 show session variables like 'character_sets_dir';
21 --disable_warnings
22 --replace_regex $regex_charsetdir
23 select * from performance_schema.global_variables where variable_name='character_sets_dir';
24 --replace_regex $regex_charsetdir
25 select * from performance_schema.session_variables where variable_name='character_sets_dir';
26 --enable_warnings
27
28 #
29 # show that it's read-only
30 #
31 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
32 set global character_sets_dir="foo";
33 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 set session character_sets_dir="foo";
35