Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_print_all_deadlocks_basic.result

raw
1 SET @start_global_value = @@global.innodb_print_all_deadlocks;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 Valid values are 'ON' and 'OFF'
6 SELECT @@global.innodb_print_all_deadlocks in (0, 1);
7 @@global.innodb_print_all_deadlocks in (0, 1)
8 1
9 SELECT @@global.innodb_print_all_deadlocks;
10 @@global.innodb_print_all_deadlocks
11 0
12 SELECT @@session.innodb_print_all_deadlocks;
13 ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable
14 SHOW global variables LIKE 'innodb_print_all_deadlocks';
15 Variable_name Value
16 innodb_print_all_deadlocks OFF
17 SHOW session variables LIKE 'innodb_print_all_deadlocks';
18 Variable_name Value
19 innodb_print_all_deadlocks OFF
20 SELECT * FROM performance_schema.global_variables
21 WHERE variable_name='innodb_print_all_deadlocks';
22 VARIABLE_NAME VARIABLE_VALUE
23 innodb_print_all_deadlocks OFF
24 SELECT * FROM performance_schema.session_variables
25 WHERE variable_name='innodb_print_all_deadlocks';
26 VARIABLE_NAME VARIABLE_VALUE
27 innodb_print_all_deadlocks OFF
28 SET global innodb_print_all_deadlocks='OFF';
29 SELECT @@global.innodb_print_all_deadlocks;
30 @@global.innodb_print_all_deadlocks
31 0
32 SELECT * FROM performance_schema.global_variables
33 WHERE variable_name='innodb_print_all_deadlocks';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_print_all_deadlocks OFF
36 SELECT * FROM performance_schema.session_variables
37 WHERE variable_name='innodb_print_all_deadlocks';
38 VARIABLE_NAME VARIABLE_VALUE
39 innodb_print_all_deadlocks OFF
40 SET @@global.innodb_print_all_deadlocks=1;
41 SELECT @@global.innodb_print_all_deadlocks;
42 @@global.innodb_print_all_deadlocks
43 1
44 SELECT * FROM performance_schema.global_variables
45 WHERE variable_name='innodb_print_all_deadlocks';
46 VARIABLE_NAME VARIABLE_VALUE
47 innodb_print_all_deadlocks ON
48 SELECT * FROM performance_schema.session_variables
49 WHERE variable_name='innodb_print_all_deadlocks';
50 VARIABLE_NAME VARIABLE_VALUE
51 innodb_print_all_deadlocks ON
52 SET global innodb_print_all_deadlocks=0;
53 SELECT @@global.innodb_print_all_deadlocks;
54 @@global.innodb_print_all_deadlocks
55 0
56 SELECT * FROM performance_schema.global_variables
57 WHERE variable_name='innodb_print_all_deadlocks';
58 VARIABLE_NAME VARIABLE_VALUE
59 innodb_print_all_deadlocks OFF
60 SELECT * FROM performance_schema.session_variables
61 WHERE variable_name='innodb_print_all_deadlocks';
62 VARIABLE_NAME VARIABLE_VALUE
63 innodb_print_all_deadlocks OFF
64 SET @@global.innodb_print_all_deadlocks='ON';
65 SELECT @@global.innodb_print_all_deadlocks;
66 @@global.innodb_print_all_deadlocks
67 1
68 SELECT * FROM performance_schema.global_variables
69 WHERE variable_name='innodb_print_all_deadlocks';
70 VARIABLE_NAME VARIABLE_VALUE
71 innodb_print_all_deadlocks ON
72 SELECT * FROM performance_schema.session_variables
73 WHERE variable_name='innodb_print_all_deadlocks';
74 VARIABLE_NAME VARIABLE_VALUE
75 innodb_print_all_deadlocks ON
76 SET session innodb_print_all_deadlocks='OFF';
77 ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable and should be set with SET GLOBAL
78 SET @@session.innodb_print_all_deadlocks='ON';
79 ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable and should be set with SET GLOBAL
80 SET global innodb_print_all_deadlocks=1.1;
81 ERROR 42000: Incorrect argument type to variable 'innodb_print_all_deadlocks'
82 SET global innodb_print_all_deadlocks=1e1;
83 ERROR 42000: Incorrect argument type to variable 'innodb_print_all_deadlocks'
84 SET global innodb_print_all_deadlocks=2;
85 ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of '2'
86 SET global innodb_print_all_deadlocks=-3;
87 ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of '-3'
88 SELECT @@global.innodb_print_all_deadlocks;
89 @@global.innodb_print_all_deadlocks
90 1
91 SELECT * FROM performance_schema.global_variables
92 WHERE variable_name='innodb_print_all_deadlocks';
93 VARIABLE_NAME VARIABLE_VALUE
94 innodb_print_all_deadlocks ON
95 SELECT * FROM performance_schema.session_variables
96 WHERE variable_name='innodb_print_all_deadlocks';
97 VARIABLE_NAME VARIABLE_VALUE
98 innodb_print_all_deadlocks ON
99 SET global innodb_print_all_deadlocks='AUTO';
100 ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of 'AUTO'
101 SET @@global.innodb_print_all_deadlocks = @start_global_value;
102 SELECT @@global.innodb_print_all_deadlocks;
103 @@global.innodb_print_all_deadlocks
104 0