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
26 SET @start_global_value=@@global.innodb_lock_wait_timeout;
27 SELECT @start_global_value;
28
29 --echo '#---------------------BS_STVARS_032_01----------------------#'
30 ####################################################################
31 # Displaying default value #
32 ####################################################################
33 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
34 --echo 1 Expected
35
36
37 --echo '#---------------------BS_STVARS_032_02----------------------#'
38 ####################################################################
39 # Check if Value can set #
40 ####################################################################
41
42 SET global innodb_lock_wait_timeout=60;
43 SELECT @@global.innodb_lock_wait_timeout;
44 SET session innodb_lock_wait_timeout=60;
45 SELECT @@session.innodb_lock_wait_timeout;
46
47 --echo '#---------------------BS_STVARS_032_03----------------------#'
48 #################################################################
49 # Check if the value in GLOBAL Table matches value in variable #
50 #################################################################
51
52 --disable_warnings
53 SELECT @@GLOBAL.innodb_lock_wait_timeout = VARIABLE_VALUE
54 FROM performance_schema.global_variables
55 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
56 --enable_warnings
57 --echo 1 Expected
58
59 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
60 --echo 1 Expected
61
62 --disable_warnings
63 SELECT COUNT(VARIABLE_VALUE)
64 FROM performance_schema.global_variables
65 WHERE VARIABLE_NAME='innodb_lock_wait_timeout';
66 --enable_warnings
67 --echo 1 Expected
68
69
70
71 --echo '#---------------------BS_STVARS_032_04----------------------#'
72 ################################################################################
73 # Check if accessing variable with and without GLOBAL point to same variable #
74 ################################################################################
75 SELECT @@innodb_lock_wait_timeout = @@GLOBAL.innodb_lock_wait_timeout;
76 --echo 1 Expected
77
78
79
80 --echo '#---------------------BS_STVARS_032_05----------------------#'
81 ################################################################################
82 # Check if innodb_lock_wait_timeout can be accessed with and without @@ sign #
83 ################################################################################
84
85 SELECT COUNT(@@innodb_lock_wait_timeout);
86 --echo 1 Expected
87
88 SELECT COUNT(@@local.innodb_lock_wait_timeout);
89
90 SELECT COUNT(@@SESSION.innodb_lock_wait_timeout);
91
92 SELECT COUNT(@@GLOBAL.innodb_lock_wait_timeout);
93 --echo 1 Expected
94
95 --Error ER_BAD_FIELD_ERROR
96 SELECT innodb_lock_wait_timeout = @@SESSION.innodb_lock_wait_timeout;
97
98 #
99 # check the default value
100 #
101 set @@global.innodb_lock_wait_timeout=100;
102 set @@global.innodb_lock_wait_timeout=DEFAULT;
103 select @@global.innodb_lock_wait_timeout;
104 set @@session.innodb_lock_wait_timeout=100;
105 set @@session.innodb_lock_wait_timeout=DEFAULT;
106 select @@session.innodb_lock_wait_timeout;
107
108 #
109 # check for valid values
110 #
111
112 SET @@global.innodb_lock_wait_timeout=1;
113 SELECT @@global.innodb_lock_wait_timeout;
114 SET @@global.innodb_lock_wait_timeout=1024;
115 SELECT @@global.innodb_lock_wait_timeout;
116 SET @@global.innodb_lock_wait_timeout=1073741824;
117 SELECT @@global.innodb_lock_wait_timeout;
118
119 SET @@session.innodb_lock_wait_timeout=1;
120 SELECT @@session.innodb_lock_wait_timeout;
121 SET @@session.innodb_lock_wait_timeout=1024;
122 SELECT @@session.innodb_lock_wait_timeout;
123 SET @@session.innodb_lock_wait_timeout=1073741824;
124 SELECT @@session.innodb_lock_wait_timeout;
125
126 #
127 # check for invalid values
128 #
129 --Error ER_WRONG_TYPE_FOR_VAR
130 SET @@global.innodb_lock_wait_timeout="t";
131 SELECT @@global.innodb_lock_wait_timeout;
132 SET @@global.innodb_lock_wait_timeout=-1024;
133 SELECT @@global.innodb_lock_wait_timeout;
134 SET @@global.innodb_lock_wait_timeout=1073741825;
135 SELECT @@global.innodb_lock_wait_timeout;
136 --Error ER_WRONG_TYPE_FOR_VAR
137 SET @@global.innodb_lock_wait_timeout=" ";
138 SELECT @@global.innodb_lock_wait_timeout;
139 --Error ER_WRONG_TYPE_FOR_VAR
140 SET @@global.innodb_lock_wait_timeout=' ';
141 SELECT @@global.innodb_lock_wait_timeout;
142 --Error ER_WRONG_TYPE_FOR_VAR
143 SET @@global.innodb_lock_wait_timeout=1.1;
144 SELECT @@global.innodb_lock_wait_timeout;
145
146
147 --Error ER_WRONG_TYPE_FOR_VAR
148 SET @@session.innodb_lock_wait_timeout="T";
149 SELECT @@session.innodb_lock_wait_timeout;
150 SET @@session.innodb_lock_wait_timeout=-1024;
151 SELECT @@session.innodb_lock_wait_timeout;
152 SET @@session.innodb_lock_wait_timeout=1073999999;
153 SELECT @@session.innodb_lock_wait_timeout;
154 --Error ER_WRONG_TYPE_FOR_VAR
155 SET @@session.innodb_lock_wait_timeout=' ';
156 SELECT @@session.innodb_lock_wait_timeout;
157 --Error ER_WRONG_TYPE_FOR_VAR
158 SET @@session.innodb_lock_wait_timeout=" ";
159 SELECT @@session.innodb_lock_wait_timeout;
160 --Error ER_WRONG_TYPE_FOR_VAR
161 SET @@session.innodb_lock_wait_timeout=1.1;
162 SELECT @@session.innodb_lock_wait_timeout;
163
164
165
166 # Cleanup
167 #
168
169 SET @@global.innodb_lock_wait_timeout = @start_global_value;
170 SELECT @@global.innodb_lock_wait_timeout;