Debian Codegraph @

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

raw
1 # enum global
2 --source include/have_maria.inc
3
4 SET @start_global_value = @@global.aria_sync_log_dir;
5
6 #
7 # exists as global only
8 #
9 select @@global.aria_sync_log_dir;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.aria_sync_log_dir;
12 show global variables like 'aria_sync_log_dir';
13 show session variables like 'aria_sync_log_dir';
14 select * from information_schema.global_variables where variable_name='aria_sync_log_dir';
15 select * from information_schema.session_variables where variable_name='aria_sync_log_dir';
16
17 #
18 # show that it's writable
19 #
20 set global aria_sync_log_dir=1;
21 select @@global.aria_sync_log_dir;
22 --error ER_GLOBAL_VARIABLE
23 set session aria_sync_log_dir=1;
24
25 #
26 # all valid values
27 #
28 set global aria_sync_log_dir=never;
29 select @@global.aria_sync_log_dir;
30 set global aria_sync_log_dir=newfile;
31 select @@global.aria_sync_log_dir;
32 set global aria_sync_log_dir=always;
33 select @@global.aria_sync_log_dir;
34
35 #
36 # incorrect types/values
37 #
38 --error ER_WRONG_TYPE_FOR_VAR
39 set global aria_sync_log_dir=1.1;
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global aria_sync_log_dir=1e1;
42 --error ER_WRONG_VALUE_FOR_VAR
43 set global aria_sync_log_dir="foo";
44 --error ER_WRONG_VALUE_FOR_VAR
45 set global aria_sync_log_dir=3;
46
47 SET @@global.aria_sync_log_dir = @start_global_value;