Debian Codegraph @

mysql-test/suite/engines/funcs/t/de_string_range.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2,t3;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
5 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
6 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
7 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
8 INSERT INTO t3 (c1) VALUES('a');
9 SELECT COUNT(c1) FROM t1;
10 DELETE FROM t1 WHERE c1 = 'a';
11 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
12 SELECT COUNT(c1) FROM t1;
13 DROP TABLE t1,t2,t3;
14 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
15 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
16 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
17 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
18 INSERT INTO t3 (c1) VALUES('a');
19 SELECT COUNT(c1) FROM t1;
20 DELETE FROM t1 WHERE c1 = 'a';
21 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
22 SELECT COUNT(c1) FROM t1;
23 DROP TABLE t1,t2,t3;
24 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
25 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
26 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
27 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
28 INSERT INTO t3 (c1) VALUES('a');
29 SELECT COUNT(c1) FROM t1;
30 DELETE FROM t1 WHERE c1 = 'a';
31 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
32 SELECT COUNT(c1) FROM t1;
33 DROP TABLE t1,t2,t3;
34 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
35 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
36 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
37 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
38 INSERT INTO t3 (c1) VALUES('a');
39 SELECT COUNT(c1) FROM t1;
40 DELETE FROM t1 WHERE c1 = 'a';
41 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
42 SELECT COUNT(c1) FROM t1;
43 DROP TABLE t1,t2,t3;
44 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
45 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
46 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
47 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
48 INSERT INTO t3 (c1) VALUES('a');
49 SELECT COUNT(c1) FROM t2;
50 DELETE FROM t2 WHERE c1 = 'a';
51 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
52 SELECT COUNT(c1) FROM t2;
53 DROP TABLE t1,t2,t3;
54 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
55 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
56 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
57 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
58 INSERT INTO t3 (c1) VALUES('a');
59 SELECT COUNT(c1) FROM t2;
60 DELETE FROM t2 WHERE c1 = 'a';
61 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
62 SELECT COUNT(c1) FROM t2;
63 DROP TABLE t1,t2,t3;
64 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
65 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
66 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
67 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
68 INSERT INTO t3 (c1) VALUES('a');
69 SELECT COUNT(c1) FROM t2;
70 DELETE FROM t2 WHERE c1 = 'a';
71 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
72 SELECT COUNT(c1) FROM t2;
73 DROP TABLE t1,t2,t3;
74 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
75 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
76 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
77 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
78 INSERT INTO t3 (c1) VALUES('a');
79 SELECT COUNT(c1) FROM t2;
80 DELETE FROM t2 WHERE c1 = 'a';
81 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
82 SELECT COUNT(c1) FROM t2;
83 DROP TABLE t1,t2,t3;
84 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
85 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
86 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
87 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
88 INSERT INTO t3 (c1) VALUES('a');
89 SELECT COUNT(c1) FROM t3;
90 DELETE FROM t3 WHERE c1 = 'a';
91 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
92 SELECT COUNT(c1) FROM t3;
93 DROP TABLE t1,t2,t3;
94 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
95 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
96 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
97 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
98 INSERT INTO t3 (c1) VALUES('a');
99 SELECT COUNT(c1) FROM t3;
100 DELETE FROM t3 WHERE c1 = 'a';
101 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
102 SELECT COUNT(c1) FROM t3;
103 DROP TABLE t1,t2,t3;
104 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
105 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
106 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
107 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
108 INSERT INTO t3 (c1) VALUES('a');
109 SELECT COUNT(c1) FROM t3;
110 DELETE FROM t3 WHERE c1 = 'a';
111 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
112 SELECT COUNT(c1) FROM t3;
113 DROP TABLE t1,t2,t3;
114 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
115 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
116 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
117 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
118 INSERT INTO t3 (c1) VALUES('a');
119 SELECT COUNT(c1) FROM t3;
120 DELETE FROM t3 WHERE c1 = 'a';
121 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
122 SELECT COUNT(c1) FROM t3;
123 DROP TABLE t1,t2,t3;
124 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
125 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
126 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
127 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
128 INSERT INTO t3 (c1) VALUES('a');
129 SELECT COUNT(c1) FROM t1;
130 DELETE FROM t1 WHERE c1 = 'b';
131 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
132 SELECT COUNT(c1) FROM t1;
133 DROP TABLE t1,t2,t3;
134 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
135 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
136 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
137 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
138 INSERT INTO t3 (c1) VALUES('a');
139 SELECT COUNT(c1) FROM t1;
140 DELETE FROM t1 WHERE c1 = 'b';
141 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
142 SELECT COUNT(c1) FROM t1;
143 DROP TABLE t1,t2,t3;
144 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
145 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
146 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
147 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
148 INSERT INTO t3 (c1) VALUES('a');
149 SELECT COUNT(c1) FROM t1;
150 DELETE FROM t1 WHERE c1 = 'b';
151 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
152 SELECT COUNT(c1) FROM t1;
153 DROP TABLE t1,t2,t3;
154 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
155 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
156 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
157 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
158 INSERT INTO t3 (c1) VALUES('a');
159 SELECT COUNT(c1) FROM t1;
160 DELETE FROM t1 WHERE c1 = 'b';
161 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
162 SELECT COUNT(c1) FROM t1;
163 DROP TABLE t1,t2,t3;
164 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
165 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
166 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
167 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
168 INSERT INTO t3 (c1) VALUES('a');
169 SELECT COUNT(c1) FROM t2;
170 DELETE FROM t2 WHERE c1 = 'b';
171 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
172 SELECT COUNT(c1) FROM t2;
173 DROP TABLE t1,t2,t3;
174 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
175 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
176 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
177 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
178 INSERT INTO t3 (c1) VALUES('a');
179 SELECT COUNT(c1) FROM t2;
180 DELETE FROM t2 WHERE c1 = 'b';
181 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
182 SELECT COUNT(c1) FROM t2;
183 DROP TABLE t1,t2,t3;
184 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
185 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
186 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
187 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
188 INSERT INTO t3 (c1) VALUES('a');
189 SELECT COUNT(c1) FROM t2;
190 DELETE FROM t2 WHERE c1 = 'b';
191 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
192 SELECT COUNT(c1) FROM t2;
193 DROP TABLE t1,t2,t3;
194 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
195 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
196 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
197 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
198 INSERT INTO t3 (c1) VALUES('a');
199 SELECT COUNT(c1) FROM t2;
200 DELETE FROM t2 WHERE c1 = 'b';
201 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
202 SELECT COUNT(c1) FROM t2;
203 DROP TABLE t1,t2,t3;
204 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
205 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
206 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
207 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
208 INSERT INTO t3 (c1) VALUES('a');
209 SELECT COUNT(c1) FROM t3;
210 DELETE FROM t3 WHERE c1 = 'b';
211 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
212 SELECT COUNT(c1) FROM t3;
213 DROP TABLE t1,t2,t3;
214 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
215 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
216 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
217 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
218 INSERT INTO t3 (c1) VALUES('a');
219 SELECT COUNT(c1) FROM t3;
220 DELETE FROM t3 WHERE c1 = 'b';
221 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
222 SELECT COUNT(c1) FROM t3;
223 DROP TABLE t1,t2,t3;
224 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
225 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
226 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
227 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
228 INSERT INTO t3 (c1) VALUES('a');
229 SELECT COUNT(c1) FROM t3;
230 DELETE FROM t3 WHERE c1 = 'b';
231 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
232 SELECT COUNT(c1) FROM t3;
233 DROP TABLE t1,t2,t3;
234 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
235 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
236 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
237 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
238 INSERT INTO t3 (c1) VALUES('a');
239 SELECT COUNT(c1) FROM t3;
240 DELETE FROM t3 WHERE c1 = 'b';
241 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
242 SELECT COUNT(c1) FROM t3;
243 DROP TABLE t1,t2,t3;
244 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
245 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
246 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
247 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
248 INSERT INTO t3 (c1) VALUES('a');
249 SELECT COUNT(c1) FROM t1;
250 DELETE FROM t1 WHERE c1 = 'c';
251 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
252 SELECT COUNT(c1) FROM t1;
253 DROP TABLE t1,t2,t3;
254 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
255 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
256 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
257 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
258 INSERT INTO t3 (c1) VALUES('a');
259 SELECT COUNT(c1) FROM t1;
260 DELETE FROM t1 WHERE c1 = 'c';
261 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
262 SELECT COUNT(c1) FROM t1;
263 DROP TABLE t1,t2,t3;
264 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
265 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
266 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
267 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
268 INSERT INTO t3 (c1) VALUES('a');
269 SELECT COUNT(c1) FROM t1;
270 DELETE FROM t1 WHERE c1 = 'c';
271 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
272 SELECT COUNT(c1) FROM t1;
273 DROP TABLE t1,t2,t3;
274 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
275 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
276 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
277 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
278 INSERT INTO t3 (c1) VALUES('a');
279 SELECT COUNT(c1) FROM t1;
280 DELETE FROM t1 WHERE c1 = 'c';
281 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
282 SELECT COUNT(c1) FROM t1;
283 DROP TABLE t1,t2,t3;
284 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
285 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
286 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
287 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
288 INSERT INTO t3 (c1) VALUES('a');
289 SELECT COUNT(c1) FROM t2;
290 DELETE FROM t2 WHERE c1 = 'c';
291 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
292 SELECT COUNT(c1) FROM t2;
293 DROP TABLE t1,t2,t3;
294 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
295 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
296 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
297 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
298 INSERT INTO t3 (c1) VALUES('a');
299 SELECT COUNT(c1) FROM t2;
300 DELETE FROM t2 WHERE c1 = 'c';
301 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
302 SELECT COUNT(c1) FROM t2;
303 DROP TABLE t1,t2,t3;
304 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
305 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
306 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
307 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
308 INSERT INTO t3 (c1) VALUES('a');
309 SELECT COUNT(c1) FROM t2;
310 DELETE FROM t2 WHERE c1 = 'c';
311 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
312 SELECT COUNT(c1) FROM t2;
313 DROP TABLE t1,t2,t3;
314 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
315 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
316 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
317 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
318 INSERT INTO t3 (c1) VALUES('a');
319 SELECT COUNT(c1) FROM t2;
320 DELETE FROM t2 WHERE c1 = 'c';
321 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
322 SELECT COUNT(c1) FROM t2;
323 DROP TABLE t1,t2,t3;
324 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
325 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
326 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
327 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
328 INSERT INTO t3 (c1) VALUES('a');
329 SELECT COUNT(c1) FROM t3;
330 DELETE FROM t3 WHERE c1 = 'c';
331 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
332 SELECT COUNT(c1) FROM t3;
333 DROP TABLE t1,t2,t3;
334 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
335 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
336 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
337 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
338 INSERT INTO t3 (c1) VALUES('a');
339 SELECT COUNT(c1) FROM t3;
340 DELETE FROM t3 WHERE c1 = 'c';
341 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
342 SELECT COUNT(c1) FROM t3;
343 DROP TABLE t1,t2,t3;
344 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
345 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
346 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
347 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
348 INSERT INTO t3 (c1) VALUES('a');
349 SELECT COUNT(c1) FROM t3;
350 DELETE FROM t3 WHERE c1 = 'c';
351 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
352 SELECT COUNT(c1) FROM t3;
353 DROP TABLE t1,t2,t3;
354 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
355 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
356 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
357 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
358 INSERT INTO t3 (c1) VALUES('a');
359 SELECT COUNT(c1) FROM t3;
360 DELETE FROM t3 WHERE c1 = 'c';
361 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
362 SELECT COUNT(c1) FROM t3;
363 DROP TABLE t1,t2,t3;
364 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
365 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
366 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
367 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
368 INSERT INTO t3 (c1) VALUES('a');
369 SELECT COUNT(c1) FROM t1;
370 DELETE FROM t1 WHERE c1 = 'd';
371 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
372 SELECT COUNT(c1) FROM t1;
373 DROP TABLE t1,t2,t3;
374 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
375 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
376 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
377 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
378 INSERT INTO t3 (c1) VALUES('a');
379 SELECT COUNT(c1) FROM t1;
380 DELETE FROM t1 WHERE c1 = 'd';
381 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
382 SELECT COUNT(c1) FROM t1;
383 DROP TABLE t1,t2,t3;
384 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
385 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
386 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
387 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
388 INSERT INTO t3 (c1) VALUES('a');
389 SELECT COUNT(c1) FROM t1;
390 DELETE FROM t1 WHERE c1 = 'd';
391 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
392 SELECT COUNT(c1) FROM t1;
393 DROP TABLE t1,t2,t3;
394 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
395 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
396 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
397 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
398 INSERT INTO t3 (c1) VALUES('a');
399 SELECT COUNT(c1) FROM t1;
400 DELETE FROM t1 WHERE c1 = 'd';
401 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
402 SELECT COUNT(c1) FROM t1;
403 DROP TABLE t1,t2,t3;
404 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
405 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
406 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
407 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
408 INSERT INTO t3 (c1) VALUES('a');
409 SELECT COUNT(c1) FROM t2;
410 DELETE FROM t2 WHERE c1 = 'd';
411 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
412 SELECT COUNT(c1) FROM t2;
413 DROP TABLE t1,t2,t3;
414 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
415 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
416 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
417 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
418 INSERT INTO t3 (c1) VALUES('a');
419 SELECT COUNT(c1) FROM t2;
420 DELETE FROM t2 WHERE c1 = 'd';
421 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
422 SELECT COUNT(c1) FROM t2;
423 DROP TABLE t1,t2,t3;
424 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
425 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
426 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
427 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
428 INSERT INTO t3 (c1) VALUES('a');
429 SELECT COUNT(c1) FROM t2;
430 DELETE FROM t2 WHERE c1 = 'd';
431 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
432 SELECT COUNT(c1) FROM t2;
433 DROP TABLE t1,t2,t3;
434 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
435 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
436 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
437 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
438 INSERT INTO t3 (c1) VALUES('a');
439 SELECT COUNT(c1) FROM t2;
440 DELETE FROM t2 WHERE c1 = 'd';
441 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
442 SELECT COUNT(c1) FROM t2;
443 DROP TABLE t1,t2,t3;
444 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
445 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
446 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
447 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
448 INSERT INTO t3 (c1) VALUES('a');
449 SELECT COUNT(c1) FROM t3;
450 DELETE FROM t3 WHERE c1 = 'd';
451 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
452 SELECT COUNT(c1) FROM t3;
453 DROP TABLE t1,t2,t3;
454 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
455 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
456 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
457 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
458 INSERT INTO t3 (c1) VALUES('a');
459 SELECT COUNT(c1) FROM t3;
460 DELETE FROM t3 WHERE c1 = 'd';
461 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
462 SELECT COUNT(c1) FROM t3;
463 DROP TABLE t1,t2,t3;
464 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
465 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
466 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
467 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
468 INSERT INTO t3 (c1) VALUES('a');
469 SELECT COUNT(c1) FROM t3;
470 DELETE FROM t3 WHERE c1 = 'd';
471 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
472 SELECT COUNT(c1) FROM t3;
473 DROP TABLE t1,t2,t3;
474 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
475 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
476 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
477 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
478 INSERT INTO t3 (c1) VALUES('a');
479 SELECT COUNT(c1) FROM t3;
480 DELETE FROM t3 WHERE c1 = 'd';
481 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
482 SELECT COUNT(c1) FROM t3;
483 DROP TABLE t1,t2,t3;
484