Debian Codegraph @

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

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