Debian Codegraph @

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

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