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