Debian Codegraph @

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

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