Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_deadlock_detect;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 Valid values are 'ON' and 'OFF'
6 select @@global.innodb_deadlock_detect in (0, 1);
7 @@global.innodb_deadlock_detect in (0, 1)
8 1
9 select @@global.innodb_deadlock_detect;
10 @@global.innodb_deadlock_detect
11 1
12 select @@session.innodb_deadlock_detect in (0, 1);
13 ERROR HY000: Variable 'innodb_deadlock_detect' is a GLOBAL variable
14 select @@session.innodb_deadlock_detect;
15 ERROR HY000: Variable 'innodb_deadlock_detect' is a GLOBAL variable
16 show global variables like 'innodb_deadlock_detect';
17 Variable_name Value
18 innodb_deadlock_detect ON
19 show session variables like 'innodb_deadlock_detect';
20 Variable_name Value
21 innodb_deadlock_detect ON
22 set global innodb_deadlock_detect='OFF';
23 set session innodb_deadlock_detect='OFF';
24 ERROR HY000: Variable 'innodb_deadlock_detect' is a GLOBAL variable and should be set with SET GLOBAL
25 select @@global.innodb_deadlock_detect;
26 @@global.innodb_deadlock_detect
27 0
28 set @@global.innodb_deadlock_detect=1;
29 select @@global.innodb_deadlock_detect;
30 @@global.innodb_deadlock_detect
31 1
32 set global innodb_deadlock_detect=0;
33 select @@global.innodb_deadlock_detect;
34 @@global.innodb_deadlock_detect
35 0
36 set @@global.innodb_deadlock_detect='ON';
37 select @@global.innodb_deadlock_detect;
38 @@global.innodb_deadlock_detect
39 1
40 set global innodb_deadlock_detect=1.1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_deadlock_detect'
42 set global innodb_deadlock_detect=1e1;
43 ERROR 42000: Incorrect argument type to variable 'innodb_deadlock_detect'
44 set global innodb_deadlock_detect=2;
45 ERROR 42000: Variable 'innodb_deadlock_detect' can't be set to the value of '2'
46 set global innodb_deadlock_detect='AUTO';
47 ERROR 42000: Variable 'innodb_deadlock_detect' can't be set to the value of 'AUTO'
48 set global innodb_deadlock_detect=-3;
49 ERROR 42000: Variable 'innodb_deadlock_detect' can't be set to the value of '-3'
50 select @@global.innodb_deadlock_detect;
51 @@global.innodb_deadlock_detect
52 1
53 SET @@global.innodb_deadlock_detect = @start_global_value;
54 SELECT @@global.innodb_deadlock_detect;
55 @@global.innodb_deadlock_detect
56 1