Debian Codegraph @

mysql-test/suite/sys_vars/t/aria_stats_method_basic.test

raw
1 # enum session
2 --source include/have_maria.inc
3
4 SET @start_global_value = @@global.aria_stats_method;
5
6 #
7 # exists as global only
8 #
9 select @@global.aria_stats_method;
10 select @@session.aria_stats_method;
11 show global variables like 'aria_stats_method';
12 show session variables like 'aria_stats_method';
13 select * from information_schema.global_variables where variable_name='aria_stats_method';
14 select * from information_schema.session_variables where variable_name='aria_stats_method';
15
16 #
17 # show that it's writable
18 #
19 set global aria_stats_method=1;
20 select @@global.aria_stats_method;
21 set session aria_stats_method=1;
22 select @@session.aria_stats_method;
23
24 #
25 # all valid values
26 #
27 set session aria_stats_method=nulls_unequal;
28 select @@session.aria_stats_method;
29 set session aria_stats_method=nulls_equal;
30 select @@session.aria_stats_method;
31 set session aria_stats_method=nulls_ignored;
32 select @@session.aria_stats_method;
33
34 #
35 # incorrect types/values
36 #
37 --error ER_WRONG_TYPE_FOR_VAR
38 set session aria_stats_method=1.1;
39 --error ER_WRONG_TYPE_FOR_VAR
40 set session aria_stats_method=1e1;
41 --error ER_WRONG_VALUE_FOR_VAR
42 set session aria_stats_method="foo";
43 --error ER_WRONG_VALUE_FOR_VAR
44 set session aria_stats_method=3;
45
46 SET @@global.aria_stats_method = @start_global_value;