sys_vars/r/aria_group_commit_basic.result

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