Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 SET @start_global_value = @@global.innodb_stats_traditional;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 --echo Valid values are 'ON' and 'OFF'
10 select @@global.innodb_stats_traditional in (0, 1);
11 select @@global.innodb_stats_traditional;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.innodb_stats_traditional;
14 show global variables like 'innodb_stats_traditional';
15 show session variables like 'innodb_stats_traditional';
16 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
17 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
18
19 #
20 # show that it's writable
21 #
22 set global innodb_stats_traditional='OFF';
23 select @@global.innodb_stats_traditional;
24 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
25 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
26 set @@global.innodb_stats_traditional=1;
27 select @@global.innodb_stats_traditional;
28 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
29 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
30 set global innodb_stats_traditional=0;
31 select @@global.innodb_stats_traditional;
32 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
33 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
34 set @@global.innodb_stats_traditional='ON';
35 select @@global.innodb_stats_traditional;
36 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
37 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
38 --error ER_GLOBAL_VARIABLE
39 set session innodb_stats_traditional='OFF';
40 --error ER_GLOBAL_VARIABLE
41 set @@session.innodb_stats_traditional='ON';
42
43 #
44 # incorrect types
45 #
46 --error ER_WRONG_TYPE_FOR_VAR
47 set global innodb_stats_traditional=1.1;
48 --error ER_WRONG_TYPE_FOR_VAR
49 set global innodb_stats_traditional=1e1;
50 --error ER_WRONG_VALUE_FOR_VAR
51 set global innodb_stats_traditional=2;
52 --error ER_WRONG_VALUE_FOR_VAR
53 set global innodb_stats_traditional=-3;
54 select @@global.innodb_stats_traditional;
55 select * from information_schema.global_variables where variable_name='innodb_stats_traditional';
56 select * from information_schema.session_variables where variable_name='innodb_stats_traditional';
57 --error ER_WRONG_VALUE_FOR_VAR
58 set global innodb_stats_traditional='AUTO';
59
60 #
61 # Cleanup
62 #
63
64 SET @@global.innodb_stats_traditional = @start_global_value;
65 SELECT @@global.innodb_stats_traditional;