Debian Codegraph @

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

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