Debian Codegraph @

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

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