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