Debian Codegraph @

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

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