Debian Codegraph @

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

raw
1
2
3 ################## mysql-test\t\innodb_lock_wait_timeout_basic.test ###########
4 # #
5 # Variable Name: innodb_lock_wait_timeout #
6 # Scope: Global , Session #
7 # Access Type: Dynamic #
8 # Data Type: numeric #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author : Sharique Abdullah #
13 # #
14 # #
15 # Description:Test Cases of Dynamic System Variable innodb_lock_wait_timeout #
16 # that checks the behavior of this variable in the following ways #
17 # * Value Check #
18 # * Scope Check #
19 # #
20 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
21 # server-system-variables.html #
22 # #
23 ###############################################################################
24
25 --source include/have_innodb.inc
26
27 SET @start_global_value=@@global.innodb_lock_wait_timeout;
28 SELECT @start_global_value;
29
30 --echo '#---------------------BS_STVARS_032_01----------------------#'
31 ####################################################################
32 # Displaying default value #
33 ####################################################################
34 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
35 --echo 1 Expected
36
37
38 --echo '#---------------------BS_STVARS_032_02----------------------#'
39 ####################################################################
40 # Check if Value can set #
41 ####################################################################
42
43 SET global innodb_lock_wait_timeout=60;
44 SELECT @@global.innodb_lock_wait_timeout;
45 SET session innodb_lock_wait_timeout=60;
46 SELECT @@session.innodb_lock_wait_timeout;
47
48 --echo '#---------------------BS_STVARS_032_03----------------------#'
49 #################################################################
50 # Check if the value in GLOBAL Table matches value in variable #
51 #################################################################
52
53 --disable_warnings
54 SELECT @@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE
55 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
56 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
57 --enable_warnings
58 --echo 1 Expected
59
60 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
61 --echo 1 Expected
62
63 --disable_warnings
64 SELECT COUNT(VARIABLE_VALUE)
65 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
67 --enable_warnings
68 --echo 1 Expected
69
70
71
72 --echo '#---------------------BS_STVARS_032_04----------------------#'
73 ################################################################################
74 # Check if accessing variable with and without GLOBAL point to same variable #
75 ################################################################################
76 SELECT @@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout;
77 --echo 1 Expected
78
79
80
81 --echo '#---------------------BS_STVARS_032_05----------------------#'
82 ################################################################################
83 # Check if innodb_lock_wait_timeout can be accessed with and without @@ sign #
84 ################################################################################
85
86 SELECT COUNT(@@innodb_lock_wait_timeout);
87 --echo 1 Expected
88
89 SELECT COUNT(@@local.innodb_lock_wait_timeout);
90
91 SELECT COUNT(@@SESSION.innodb_lock_wait_timeout);
92
93 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
94 --echo 1 Expected
95
96 --Error ER_BAD_FIELD_ERROR
97 SELECT innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
98
99 #
100 # check the default value
101 #
102 set @@global.innodb_lock_wait_timeout=100;
103 set @@global.innodb_lock_wait_timeout=DEFAULT;
104 select @@global.innodb_lock_wait_timeout;
105 set @@session.innodb_lock_wait_timeout=100;
106 set @@session.innodb_lock_wait_timeout=DEFAULT;
107 select @@session.innodb_lock_wait_timeout;
108
109 #
110 # check for valid values
111 #
112
113 SET @@global.innodb_lock_wait_timeout=1;
114 SELECT @@global.innodb_lock_wait_timeout;
115 SET @@global.innodb_lock_wait_timeout=1024;
116 SELECT @@global.innodb_lock_wait_timeout;
117 SET @@global.innodb_lock_wait_timeout=1073741824;
118 SELECT @@global.innodb_lock_wait_timeout;
119
120 SET @@session.innodb_lock_wait_timeout=1;
121 SELECT @@session.innodb_lock_wait_timeout;
122 SET @@session.innodb_lock_wait_timeout=1024;
123 SELECT @@session.innodb_lock_wait_timeout;
124 SET @@session.innodb_lock_wait_timeout=1073741824;
125 SELECT @@session.innodb_lock_wait_timeout;
126
127 #
128 # check for invalid values
129 #
130 --Error ER_WRONG_TYPE_FOR_VAR
131 SET @@global.innodb_lock_wait_timeout="t";
132 SELECT @@global.innodb_lock_wait_timeout;
133 SET @@global.innodb_lock_wait_timeout=-1024;
134 SELECT @@global.innodb_lock_wait_timeout;
135 SET @@global.innodb_lock_wait_timeout=1073741825;
136 SELECT @@global.innodb_lock_wait_timeout;
137 --Error ER_WRONG_TYPE_FOR_VAR
138 SET @@global.innodb_lock_wait_timeout=" ";
139 SELECT @@global.innodb_lock_wait_timeout;
140 --Error ER_WRONG_TYPE_FOR_VAR
141 SET @@global.innodb_lock_wait_timeout=' ';
142 SELECT @@global.innodb_lock_wait_timeout;
143 --Error ER_WRONG_TYPE_FOR_VAR
144 SET @@global.innodb_lock_wait_timeout=1.1;
145 SELECT @@global.innodb_lock_wait_timeout;
146
147
148 --Error ER_WRONG_TYPE_FOR_VAR
149 SET @@session.innodb_lock_wait_timeout="T";
150 SELECT @@session.innodb_lock_wait_timeout;
151 SET @@session.innodb_lock_wait_timeout=-1024;
152 SELECT @@session.innodb_lock_wait_timeout;
153 SET @@session.innodb_lock_wait_timeout=1073999999;
154 SELECT @@session.innodb_lock_wait_timeout;
155 --Error ER_WRONG_TYPE_FOR_VAR
156 SET @@session.innodb_lock_wait_timeout=' ';
157 SELECT @@session.innodb_lock_wait_timeout;
158 --Error ER_WRONG_TYPE_FOR_VAR
159 SET @@session.innodb_lock_wait_timeout=" ";
160 SELECT @@session.innodb_lock_wait_timeout;
161 --Error ER_WRONG_TYPE_FOR_VAR
162 SET @@session.innodb_lock_wait_timeout=1.1;
163 SELECT @@session.innodb_lock_wait_timeout;
164
165
166
167 # Cleanup
168 #
169
170 SET @@global.innodb_lock_wait_timeout = @start_global_value;
171 SELECT @@global.innodb_lock_wait_timeout;