Debian Codegraph @

mysql-test/suite/stress/include/ddl7.inc

raw
1 ######## include/ddl7.inc ######
2 #
3 # Stress the storage engine with rapid CREATE/DROP TABLE/INDEX
4 # and following SELECT/INSERT/SHOW etc.
5 # Subtest 7 variants (7A - 7D)
6 #
7 # The variables
8 # $loop_size -- number of rounds till we look at the clock again
9 # $runtime -- rough intended runtime per subtest variant
10 # $engine_type -- storage engine to be used in CREATE TABLE
11 # must be set within the routine sourcing this script.
12 #
13 # Other stuff which must already exist:
14 # - connection con2
15 # - stmt_start and stmt_break prepared by the default connection
16 #
17 # Please look for more details within include/ddl1.inc.
18 #
19 # Creation of this test:
20 # 2007-07-04 mleich
21 #
22
23
24 #----------------------------------------------------------------------
25 # Settings for Subtest 7 variants
26 # Scenario: CREATE INDEX/INSERT(F)/DROP INDEX/INSERT/CREATE INDEX(F)/DELETE
27 let $create_index= CREATE UNIQUE INDEX IDX1 ON t1 (f2);
28 let $insert_record= INSERT INTO t1 VALUES(1,1);
29 let $drop_index= DROP INDEX IDX1 ON t1;
30 let $delete_record= DELETE FROM t1 WHERE f1 = 1;
31 eval CREATE TABLE t1 (f1 BIGINT, f2 BIGINT, PRIMARY KEY(f1)) ENGINE=$engine_type;
32 INSERT INTO t1 VALUES(0,1);
33 #----------------------------------------------------------------------
34
35 #
36 --echo # Subtest 7A (one connection, no PREPARE/EXECUTE)
37 --echo # connection action
38 --echo # default: $create_index
39 --echo # default: $insert_record (expect to get ER_DUP_ENTRY)
40 --echo # default: $drop_index
41 --echo # default: $insert_record
42 --echo # default: $create_index (expect to get ER_DUP_ENTRY)
43 --echo # default: $delete_record
44 --disable_query_log
45 --disable_result_log
46 connection default;
47 let $run= 1;
48 let $counter= 1;
49 # Determine the current time.
50 EXECUTE stmt_start;
51 # Run execution loops till the planned runtime is reached
52 while ($run)
53 {
54 let $loop_run= $loop_size;
55 while ($loop_run)
56 {
57 eval $create_index;
58 --error 0,ER_DUP_ENTRY
59 eval $insert_record;
60 if (!$mysql_errno)
61 {
62 --echo # Error: INSERT was successful though we expected ER_DUP_ENTRY
63 --echo # abort
64 exit;
65 }
66 eval $drop_index;
67 eval $insert_record;
68 --error 0,ER_DUP_ENTRY
69 eval $create_index;
70 if (!$mysql_errno)
71 {
72 --echo # Error: CREATE INDEX was successful though we expected ER_DUP_ENTRY
73 --echo # abort
74 exit;
75 }
76 eval $delete_record;
77 dec $loop_run;
78 }
79 if (`EXECUTE stmt_break`)
80 {
81 let $run= 0;
82 }
83 }
84 --enable_result_log
85 --enable_query_log
86 #
87 --echo # Subtest 7B (one connection, use PREPARE/EXECUTE)
88 --echo # connection action
89 --echo # default: $create_index
90 --echo # default: $insert_record (expect to get ER_DUP_ENTRY)
91 --echo # default: $drop_index
92 --echo # default: $insert_record
93 --echo # default: $create_index (expect to get ER_DUP_ENTRY)
94 --echo # default: $delete_record
95 --disable_query_log
96 --disable_result_log
97 connection default;
98 eval PREPARE create_index FROM "$create_index";
99 eval PREPARE insert_record FROM "$insert_record";
100 eval PREPARE delete_record FROM "$delete_record";
101 eval PREPARE drop_index FROM "$drop_index";
102 let $run= 1;
103 let $counter= 1;
104 # Determine the current time.
105 EXECUTE stmt_start;
106 # Run execution loops till the planned runtime is reached
107 while ($run)
108 {
109 let $loop_run= $loop_size;
110 while ($loop_run)
111 {
112 EXECUTE create_index;
113 --error 0,ER_DUP_ENTRY
114 EXECUTE insert_record;
115 if (!$mysql_errno)
116 {
117 --echo # Error: INSERT was successful though we expected ER_DUP_ENTRY
118 --echo # abort
119 exit;
120 }
121 EXECUTE drop_index;
122 EXECUTE insert_record;
123 --error 0,ER_DUP_ENTRY
124 EXECUTE create_index;
125 if (!$mysql_errno)
126 {
127 --echo # Error: CREATE INDEX was successful though we expected ER_DUP_ENTRY
128 --echo # abort
129 exit;
130 }
131 EXECUTE delete_record;
132 dec $loop_run;
133 }
134 if (`EXECUTE stmt_break`)
135 {
136 let $run= 0;
137 }
138 }
139 DEALLOCATE PREPARE create_index;
140 DEALLOCATE PREPARE insert_record;
141 DEALLOCATE PREPARE delete_record;
142 DEALLOCATE PREPARE drop_index;
143 --enable_result_log
144 --enable_query_log
145 #
146 --echo # Subtest 7C (two connections, no PREPARE/EXECUTE)
147 --echo # connection action
148 --echo # default: $create_index
149 --echo # default: $insert_record (expect to get ER_DUP_ENTRY)
150 --echo # con2: $drop_index
151 --echo # default: $insert_record
152 --echo # con2: $create_index (expect to get ER_DUP_ENTRY)
153 --echo # con2: $delete_record
154 --disable_query_log
155 --disable_result_log
156 connection default;
157 let $run= 1;
158 let $counter= 1;
159 # Determine the current time.
160 EXECUTE stmt_start;
161 # Run execution loops till the planned runtime is reached
162 while ($run)
163 {
164 let $loop_run= $loop_size;
165 while ($loop_run)
166 {
167 eval $create_index;
168 --error 0,ER_DUP_ENTRY
169 eval $insert_record;
170 if (!$mysql_errno)
171 {
172 --echo # Error: INSERT was successful though we expected ER_DUP_ENTRY
173 --echo # abort
174 exit;
175 }
176 connection con2;
177 eval $drop_index;
178 connection default;
179 eval $insert_record;
180 connection con2;
181 --error 0,ER_DUP_ENTRY
182 eval $create_index;
183 if (!$mysql_errno)
184 {
185 --echo # Error: CREATE INDEX was successful though we expected ER_DUP_ENTRY
186 --echo # abort
187 exit;
188 }
189 eval $delete_record;
190 connection default;
191 dec $loop_run;
192 }
193 if (`EXECUTE stmt_break`)
194 {
195 let $run= 0;
196 }
197 }
198 --enable_result_log
199 --enable_query_log
200 #
201 --echo # Subtest 7D (two connections, use PREPARE/EXECUTE)
202 --echo # connection action
203 --echo # default: $create_index
204 --echo # default: $insert_record (expect to get ER_DUP_ENTRY)
205 --echo # con2: $drop_index
206 --echo # default: $insert_record
207 --echo # con2: $create_index (expect to get ER_DUP_ENTRY)
208 --echo # con2: $delete_record
209 --disable_query_log
210 --disable_result_log
211 connection default;
212 eval PREPARE create_index FROM "$create_index";
213 eval PREPARE insert_record FROM "$insert_record";
214 EXECUTE create_index;
215 connection con2;
216 eval PREPARE create_index FROM "$create_index";
217 eval PREPARE drop_index FROM "$drop_index";
218 eval PREPARE delete_record FROM "$delete_record";
219 EXECUTE drop_index;
220 connection default;
221 let $run= 1;
222 let $counter= 1;
223 # Determine the current time.
224 EXECUTE stmt_start;
225 # Run execution loops till the planned runtime is reached
226 while ($run)
227 {
228 let $loop_run= $loop_size;
229 while ($loop_run)
230 {
231 EXECUTE create_index;
232 --error 0,ER_DUP_ENTRY
233 EXECUTE insert_record;
234 if (!$mysql_errno)
235 {
236 --echo # Error: INSERT was successful though we expected ER_DUP_ENTRY
237 --echo # abort
238 exit;
239 }
240 connection con2;
241 EXECUTE drop_index;
242 connection default;
243 EXECUTE insert_record;
244 connection con2;
245 --error 0,ER_DUP_ENTRY
246 EXECUTE create_index;
247 if (!$mysql_errno)
248 {
249 --echo # Error: CREATE INDEX was successful though we expected ER_DUP_ENTRY
250 --echo # abort
251 exit;
252 }
253 EXECUTE delete_record;
254 connection default;
255 dec $loop_run;
256 }
257 if (`EXECUTE stmt_break`)
258 {
259 let $run= 0;
260 }
261 }
262 DEALLOCATE PREPARE create_index;
263 DEALLOCATE PREPARE insert_record;
264 connection con2;
265 DEALLOCATE PREPARE create_index;
266 DEALLOCATE PREPARE drop_index;
267 DEALLOCATE PREPARE delete_record;
268 connection default;
269 --enable_result_log
270 --enable_query_log
271
272 DROP TABLE t1;