Debian Codegraph @

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

raw
1
2 SET @start_global_value = @@global.innodb_deadlock_detect;
3 SELECT @start_global_value;
4
5 #
6 # exists as global
7 #
8 --echo Valid values are 'ON' and 'OFF'
9 select @@global.innodb_deadlock_detect in (0, 1);
10 select @@global.innodb_deadlock_detect;
11 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
12 select @@session.innodb_deadlock_detect in (0, 1);
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 select @@session.innodb_deadlock_detect;
15 show global variables like 'innodb_deadlock_detect';
16 show session variables like 'innodb_deadlock_detect';
17
18 #
19 # show that it's writable
20 #
21 set global innodb_deadlock_detect='OFF';
22 --error ER_GLOBAL_VARIABLE
23 set session innodb_deadlock_detect='OFF';
24 select @@global.innodb_deadlock_detect;
25 set @@global.innodb_deadlock_detect=1;
26 select @@global.innodb_deadlock_detect;
27 set global innodb_deadlock_detect=0;
28 select @@global.innodb_deadlock_detect;
29 set @@global.innodb_deadlock_detect='ON';
30 select @@global.innodb_deadlock_detect;
31
32 #
33 # incorrect types
34 #
35 --error ER_WRONG_TYPE_FOR_VAR
36 set global innodb_deadlock_detect=1.1;
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global innodb_deadlock_detect=1e1;
39 --error ER_WRONG_VALUE_FOR_VAR
40 set global innodb_deadlock_detect=2;
41 --error ER_WRONG_VALUE_FOR_VAR
42 set global innodb_deadlock_detect='AUTO';
43 --error ER_WRONG_VALUE_FOR_VAR
44 set global innodb_deadlock_detect=-3;
45 select @@global.innodb_deadlock_detect;
46
47 #
48 # Cleanup
49 #
50
51 SET @@global.innodb_deadlock_detect = @start_global_value;
52 SELECT @@global.innodb_deadlock_detect;