Debian Codegraph @

mysql-test/suite/sys_vars/r/aria_sync_log_dir_basic.result

raw
1 SET @start_global_value = @@global.aria_sync_log_dir;
2 select @@global.aria_sync_log_dir;
3 @@global.aria_sync_log_dir
4 NEWFILE
5 select @@session.aria_sync_log_dir;
6 ERROR HY000: Variable 'aria_sync_log_dir' is a GLOBAL variable
7 show global variables like 'aria_sync_log_dir';
8 Variable_name Value
9 aria_sync_log_dir NEWFILE
10 show session variables like 'aria_sync_log_dir';
11 Variable_name Value
12 aria_sync_log_dir NEWFILE
13 select * from information_schema.global_variables where variable_name='aria_sync_log_dir';
14 VARIABLE_NAME VARIABLE_VALUE
15 ARIA_SYNC_LOG_DIR NEWFILE
16 select * from information_schema.session_variables where variable_name='aria_sync_log_dir';
17 VARIABLE_NAME VARIABLE_VALUE
18 ARIA_SYNC_LOG_DIR NEWFILE
19 set global aria_sync_log_dir=1;
20 select @@global.aria_sync_log_dir;
21 @@global.aria_sync_log_dir
22 NEWFILE
23 set session aria_sync_log_dir=1;
24 ERROR HY000: Variable 'aria_sync_log_dir' is a GLOBAL variable and should be set with SET GLOBAL
25 set global aria_sync_log_dir=never;
26 select @@global.aria_sync_log_dir;
27 @@global.aria_sync_log_dir
28 NEVER
29 set global aria_sync_log_dir=newfile;
30 select @@global.aria_sync_log_dir;
31 @@global.aria_sync_log_dir
32 NEWFILE
33 set global aria_sync_log_dir=always;
34 select @@global.aria_sync_log_dir;
35 @@global.aria_sync_log_dir
36 ALWAYS
37 set global aria_sync_log_dir=1.1;
38 ERROR 42000: Incorrect argument type to variable 'aria_sync_log_dir'
39 set global aria_sync_log_dir=1e1;
40 ERROR 42000: Incorrect argument type to variable 'aria_sync_log_dir'
41 set global aria_sync_log_dir="foo";
42 ERROR 42000: Variable 'aria_sync_log_dir' can't be set to the value of 'foo'
43 set global aria_sync_log_dir=3;
44 ERROR 42000: Variable 'aria_sync_log_dir' can't be set to the value of '3'
45 SET @@global.aria_sync_log_dir = @start_global_value;