Debian Codegraph @

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

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