Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_string_range.result

raw
1 DROP TABLE IF EXISTS t1,t2,t3;
2 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
3 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
4 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
5 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
6 INSERT INTO t3 (c1) VALUES('a');
7 SELECT COUNT(c1) FROM t1;
8 COUNT(c1)
9 0
10 DELETE FROM t1 WHERE c1 = 'a';
11 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
12 COUNT(c1)
13 0
14 SELECT COUNT(c1) FROM t1;
15 COUNT(c1)
16 0
17 DROP TABLE t1,t2,t3;
18 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
19 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
20 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
21 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
22 INSERT INTO t3 (c1) VALUES('a');
23 SELECT COUNT(c1) FROM t1;
24 COUNT(c1)
25 0
26 DELETE FROM t1 WHERE c1 = 'a';
27 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
28 COUNT(c1)
29 0
30 SELECT COUNT(c1) FROM t1;
31 COUNT(c1)
32 0
33 DROP TABLE t1,t2,t3;
34 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
35 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
36 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
37 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
38 INSERT INTO t3 (c1) VALUES('a');
39 SELECT COUNT(c1) FROM t1;
40 COUNT(c1)
41 0
42 DELETE FROM t1 WHERE c1 = 'a';
43 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
44 COUNT(c1)
45 0
46 SELECT COUNT(c1) FROM t1;
47 COUNT(c1)
48 0
49 DROP TABLE t1,t2,t3;
50 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
51 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
52 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
53 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
54 INSERT INTO t3 (c1) VALUES('a');
55 SELECT COUNT(c1) FROM t1;
56 COUNT(c1)
57 0
58 DELETE FROM t1 WHERE c1 = 'a';
59 SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
60 COUNT(c1)
61 0
62 SELECT COUNT(c1) FROM t1;
63 COUNT(c1)
64 0
65 DROP TABLE t1,t2,t3;
66 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
67 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
68 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
69 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
70 INSERT INTO t3 (c1) VALUES('a');
71 SELECT COUNT(c1) FROM t2;
72 COUNT(c1)
73 7
74 DELETE FROM t2 WHERE c1 = 'a';
75 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
76 COUNT(c1)
77 0
78 SELECT COUNT(c1) FROM t2;
79 COUNT(c1)
80 6
81 DROP TABLE t1,t2,t3;
82 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
83 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
84 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
85 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
86 INSERT INTO t3 (c1) VALUES('a');
87 SELECT COUNT(c1) FROM t2;
88 COUNT(c1)
89 7
90 DELETE FROM t2 WHERE c1 = 'a';
91 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
92 COUNT(c1)
93 0
94 SELECT COUNT(c1) FROM t2;
95 COUNT(c1)
96 6
97 DROP TABLE t1,t2,t3;
98 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
99 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
100 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
101 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
102 INSERT INTO t3 (c1) VALUES('a');
103 SELECT COUNT(c1) FROM t2;
104 COUNT(c1)
105 7
106 DELETE FROM t2 WHERE c1 = 'a';
107 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
108 COUNT(c1)
109 0
110 SELECT COUNT(c1) FROM t2;
111 COUNT(c1)
112 7
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 t2;
120 COUNT(c1)
121 7
122 DELETE FROM t2 WHERE c1 = 'a';
123 SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
124 COUNT(c1)
125 0
126 SELECT COUNT(c1) FROM t2;
127 COUNT(c1)
128 6
129 DROP TABLE t1,t2,t3;
130 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
131 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
132 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
133 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
134 INSERT INTO t3 (c1) VALUES('a');
135 SELECT COUNT(c1) FROM t3;
136 COUNT(c1)
137 1
138 DELETE FROM t3 WHERE c1 = 'a';
139 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
140 COUNT(c1)
141 0
142 SELECT COUNT(c1) FROM t3;
143 COUNT(c1)
144 0
145 DROP TABLE t1,t2,t3;
146 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
147 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
148 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
149 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
150 INSERT INTO t3 (c1) VALUES('a');
151 SELECT COUNT(c1) FROM t3;
152 COUNT(c1)
153 1
154 DELETE FROM t3 WHERE c1 = 'a';
155 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
156 COUNT(c1)
157 0
158 SELECT COUNT(c1) FROM t3;
159 COUNT(c1)
160 0
161 DROP TABLE t1,t2,t3;
162 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
163 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
164 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
165 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
166 INSERT INTO t3 (c1) VALUES('a');
167 SELECT COUNT(c1) FROM t3;
168 COUNT(c1)
169 1
170 DELETE FROM t3 WHERE c1 = 'a';
171 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
172 COUNT(c1)
173 0
174 SELECT COUNT(c1) FROM t3;
175 COUNT(c1)
176 1
177 DROP TABLE t1,t2,t3;
178 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
179 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
180 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
181 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
182 INSERT INTO t3 (c1) VALUES('a');
183 SELECT COUNT(c1) FROM t3;
184 COUNT(c1)
185 1
186 DELETE FROM t3 WHERE c1 = 'a';
187 SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
188 COUNT(c1)
189 0
190 SELECT COUNT(c1) FROM t3;
191 COUNT(c1)
192 0
193 DROP TABLE t1,t2,t3;
194 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
195 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
196 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
197 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
198 INSERT INTO t3 (c1) VALUES('a');
199 SELECT COUNT(c1) FROM t1;
200 COUNT(c1)
201 0
202 DELETE FROM t1 WHERE c1 = 'b';
203 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
204 COUNT(c1)
205 0
206 SELECT COUNT(c1) FROM t1;
207 COUNT(c1)
208 0
209 DROP TABLE t1,t2,t3;
210 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
211 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
212 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
213 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
214 INSERT INTO t3 (c1) VALUES('a');
215 SELECT COUNT(c1) FROM t1;
216 COUNT(c1)
217 0
218 DELETE FROM t1 WHERE c1 = 'b';
219 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
220 COUNT(c1)
221 0
222 SELECT COUNT(c1) FROM t1;
223 COUNT(c1)
224 0
225 DROP TABLE t1,t2,t3;
226 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
227 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
228 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
229 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
230 INSERT INTO t3 (c1) VALUES('a');
231 SELECT COUNT(c1) FROM t1;
232 COUNT(c1)
233 0
234 DELETE FROM t1 WHERE c1 = 'b';
235 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
236 COUNT(c1)
237 0
238 SELECT COUNT(c1) FROM t1;
239 COUNT(c1)
240 0
241 DROP TABLE t1,t2,t3;
242 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
243 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
244 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
245 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
246 INSERT INTO t3 (c1) VALUES('a');
247 SELECT COUNT(c1) FROM t1;
248 COUNT(c1)
249 0
250 DELETE FROM t1 WHERE c1 = 'b';
251 SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
252 COUNT(c1)
253 0
254 SELECT COUNT(c1) FROM t1;
255 COUNT(c1)
256 0
257 DROP TABLE t1,t2,t3;
258 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
259 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
260 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
261 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
262 INSERT INTO t3 (c1) VALUES('a');
263 SELECT COUNT(c1) FROM t2;
264 COUNT(c1)
265 7
266 DELETE FROM t2 WHERE c1 = 'b';
267 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
268 COUNT(c1)
269 0
270 SELECT COUNT(c1) FROM t2;
271 COUNT(c1)
272 5
273 DROP TABLE t1,t2,t3;
274 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
275 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
276 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
277 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
278 INSERT INTO t3 (c1) VALUES('a');
279 SELECT COUNT(c1) FROM t2;
280 COUNT(c1)
281 7
282 DELETE FROM t2 WHERE c1 = 'b';
283 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
284 COUNT(c1)
285 0
286 SELECT COUNT(c1) FROM t2;
287 COUNT(c1)
288 5
289 DROP TABLE t1,t2,t3;
290 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
291 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
292 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
293 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
294 INSERT INTO t3 (c1) VALUES('a');
295 SELECT COUNT(c1) FROM t2;
296 COUNT(c1)
297 7
298 DELETE FROM t2 WHERE c1 = 'b';
299 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
300 COUNT(c1)
301 0
302 SELECT COUNT(c1) FROM t2;
303 COUNT(c1)
304 7
305 DROP TABLE t1,t2,t3;
306 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
307 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
308 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
309 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
310 INSERT INTO t3 (c1) VALUES('a');
311 SELECT COUNT(c1) FROM t2;
312 COUNT(c1)
313 7
314 DELETE FROM t2 WHERE c1 = 'b';
315 SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
316 COUNT(c1)
317 0
318 SELECT COUNT(c1) FROM t2;
319 COUNT(c1)
320 5
321 DROP TABLE t1,t2,t3;
322 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
323 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
324 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
325 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
326 INSERT INTO t3 (c1) VALUES('a');
327 SELECT COUNT(c1) FROM t3;
328 COUNT(c1)
329 1
330 DELETE FROM t3 WHERE c1 = 'b';
331 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
332 COUNT(c1)
333 0
334 SELECT COUNT(c1) FROM t3;
335 COUNT(c1)
336 1
337 DROP TABLE t1,t2,t3;
338 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
339 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
340 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
341 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
342 INSERT INTO t3 (c1) VALUES('a');
343 SELECT COUNT(c1) FROM t3;
344 COUNT(c1)
345 1
346 DELETE FROM t3 WHERE c1 = 'b';
347 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
348 COUNT(c1)
349 0
350 SELECT COUNT(c1) FROM t3;
351 COUNT(c1)
352 1
353 DROP TABLE t1,t2,t3;
354 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
355 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
356 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
357 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
358 INSERT INTO t3 (c1) VALUES('a');
359 SELECT COUNT(c1) FROM t3;
360 COUNT(c1)
361 1
362 DELETE FROM t3 WHERE c1 = 'b';
363 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
364 COUNT(c1)
365 0
366 SELECT COUNT(c1) FROM t3;
367 COUNT(c1)
368 1
369 DROP TABLE t1,t2,t3;
370 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
371 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
372 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
373 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
374 INSERT INTO t3 (c1) VALUES('a');
375 SELECT COUNT(c1) FROM t3;
376 COUNT(c1)
377 1
378 DELETE FROM t3 WHERE c1 = 'b';
379 SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
380 COUNT(c1)
381 0
382 SELECT COUNT(c1) FROM t3;
383 COUNT(c1)
384 1
385 DROP TABLE t1,t2,t3;
386 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
387 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
388 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
389 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
390 INSERT INTO t3 (c1) VALUES('a');
391 SELECT COUNT(c1) FROM t1;
392 COUNT(c1)
393 0
394 DELETE FROM t1 WHERE c1 = 'c';
395 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
396 COUNT(c1)
397 0
398 SELECT COUNT(c1) FROM t1;
399 COUNT(c1)
400 0
401 DROP TABLE t1,t2,t3;
402 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
403 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
404 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
405 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
406 INSERT INTO t3 (c1) VALUES('a');
407 SELECT COUNT(c1) FROM t1;
408 COUNT(c1)
409 0
410 DELETE FROM t1 WHERE c1 = 'c';
411 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
412 COUNT(c1)
413 0
414 SELECT COUNT(c1) FROM t1;
415 COUNT(c1)
416 0
417 DROP TABLE t1,t2,t3;
418 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
419 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
420 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
421 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
422 INSERT INTO t3 (c1) VALUES('a');
423 SELECT COUNT(c1) FROM t1;
424 COUNT(c1)
425 0
426 DELETE FROM t1 WHERE c1 = 'c';
427 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
428 COUNT(c1)
429 0
430 SELECT COUNT(c1) FROM t1;
431 COUNT(c1)
432 0
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 t1;
440 COUNT(c1)
441 0
442 DELETE FROM t1 WHERE c1 = 'c';
443 SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
444 COUNT(c1)
445 0
446 SELECT COUNT(c1) FROM t1;
447 COUNT(c1)
448 0
449 DROP TABLE t1,t2,t3;
450 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
451 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
452 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
453 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
454 INSERT INTO t3 (c1) VALUES('a');
455 SELECT COUNT(c1) FROM t2;
456 COUNT(c1)
457 7
458 DELETE FROM t2 WHERE c1 = 'c';
459 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
460 COUNT(c1)
461 0
462 SELECT COUNT(c1) FROM t2;
463 COUNT(c1)
464 6
465 DROP TABLE t1,t2,t3;
466 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
467 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
468 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
469 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
470 INSERT INTO t3 (c1) VALUES('a');
471 SELECT COUNT(c1) FROM t2;
472 COUNT(c1)
473 7
474 DELETE FROM t2 WHERE c1 = 'c';
475 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
476 COUNT(c1)
477 0
478 SELECT COUNT(c1) FROM t2;
479 COUNT(c1)
480 6
481 DROP TABLE t1,t2,t3;
482 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
483 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
484 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
485 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
486 INSERT INTO t3 (c1) VALUES('a');
487 SELECT COUNT(c1) FROM t2;
488 COUNT(c1)
489 7
490 DELETE FROM t2 WHERE c1 = 'c';
491 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
492 COUNT(c1)
493 0
494 SELECT COUNT(c1) FROM t2;
495 COUNT(c1)
496 7
497 DROP TABLE t1,t2,t3;
498 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
499 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
500 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
501 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
502 INSERT INTO t3 (c1) VALUES('a');
503 SELECT COUNT(c1) FROM t2;
504 COUNT(c1)
505 7
506 DELETE FROM t2 WHERE c1 = 'c';
507 SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
508 COUNT(c1)
509 0
510 SELECT COUNT(c1) FROM t2;
511 COUNT(c1)
512 6
513 DROP TABLE t1,t2,t3;
514 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
515 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
516 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
517 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
518 INSERT INTO t3 (c1) VALUES('a');
519 SELECT COUNT(c1) FROM t3;
520 COUNT(c1)
521 1
522 DELETE FROM t3 WHERE c1 = 'c';
523 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
524 COUNT(c1)
525 0
526 SELECT COUNT(c1) FROM t3;
527 COUNT(c1)
528 1
529 DROP TABLE t1,t2,t3;
530 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
531 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
532 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
533 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
534 INSERT INTO t3 (c1) VALUES('a');
535 SELECT COUNT(c1) FROM t3;
536 COUNT(c1)
537 1
538 DELETE FROM t3 WHERE c1 = 'c';
539 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
540 COUNT(c1)
541 0
542 SELECT COUNT(c1) FROM t3;
543 COUNT(c1)
544 1
545 DROP TABLE t1,t2,t3;
546 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
547 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
548 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
549 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
550 INSERT INTO t3 (c1) VALUES('a');
551 SELECT COUNT(c1) FROM t3;
552 COUNT(c1)
553 1
554 DELETE FROM t3 WHERE c1 = 'c';
555 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
556 COUNT(c1)
557 0
558 SELECT COUNT(c1) FROM t3;
559 COUNT(c1)
560 1
561 DROP TABLE t1,t2,t3;
562 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
563 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
564 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
565 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
566 INSERT INTO t3 (c1) VALUES('a');
567 SELECT COUNT(c1) FROM t3;
568 COUNT(c1)
569 1
570 DELETE FROM t3 WHERE c1 = 'c';
571 SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
572 COUNT(c1)
573 0
574 SELECT COUNT(c1) FROM t3;
575 COUNT(c1)
576 1
577 DROP TABLE t1,t2,t3;
578 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
579 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
580 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
581 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
582 INSERT INTO t3 (c1) VALUES('a');
583 SELECT COUNT(c1) FROM t1;
584 COUNT(c1)
585 0
586 DELETE FROM t1 WHERE c1 = 'd';
587 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
588 COUNT(c1)
589 0
590 SELECT COUNT(c1) FROM t1;
591 COUNT(c1)
592 0
593 DROP TABLE t1,t2,t3;
594 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
595 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
596 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
597 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
598 INSERT INTO t3 (c1) VALUES('a');
599 SELECT COUNT(c1) FROM t1;
600 COUNT(c1)
601 0
602 DELETE FROM t1 WHERE c1 = 'd';
603 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
604 COUNT(c1)
605 0
606 SELECT COUNT(c1) FROM t1;
607 COUNT(c1)
608 0
609 DROP TABLE t1,t2,t3;
610 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
611 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
612 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
613 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
614 INSERT INTO t3 (c1) VALUES('a');
615 SELECT COUNT(c1) FROM t1;
616 COUNT(c1)
617 0
618 DELETE FROM t1 WHERE c1 = 'd';
619 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
620 COUNT(c1)
621 0
622 SELECT COUNT(c1) FROM t1;
623 COUNT(c1)
624 0
625 DROP TABLE t1,t2,t3;
626 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
627 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
628 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
629 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
630 INSERT INTO t3 (c1) VALUES('a');
631 SELECT COUNT(c1) FROM t1;
632 COUNT(c1)
633 0
634 DELETE FROM t1 WHERE c1 = 'd';
635 SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
636 COUNT(c1)
637 0
638 SELECT COUNT(c1) FROM t1;
639 COUNT(c1)
640 0
641 DROP TABLE t1,t2,t3;
642 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
643 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
644 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
645 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
646 INSERT INTO t3 (c1) VALUES('a');
647 SELECT COUNT(c1) FROM t2;
648 COUNT(c1)
649 7
650 DELETE FROM t2 WHERE c1 = 'd';
651 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
652 COUNT(c1)
653 0
654 SELECT COUNT(c1) FROM t2;
655 COUNT(c1)
656 7
657 DROP TABLE t1,t2,t3;
658 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
659 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
660 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
661 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
662 INSERT INTO t3 (c1) VALUES('a');
663 SELECT COUNT(c1) FROM t2;
664 COUNT(c1)
665 7
666 DELETE FROM t2 WHERE c1 = 'd';
667 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
668 COUNT(c1)
669 0
670 SELECT COUNT(c1) FROM t2;
671 COUNT(c1)
672 7
673 DROP TABLE t1,t2,t3;
674 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
675 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
676 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
677 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
678 INSERT INTO t3 (c1) VALUES('a');
679 SELECT COUNT(c1) FROM t2;
680 COUNT(c1)
681 7
682 DELETE FROM t2 WHERE c1 = 'd';
683 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
684 COUNT(c1)
685 0
686 SELECT COUNT(c1) FROM t2;
687 COUNT(c1)
688 7
689 DROP TABLE t1,t2,t3;
690 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
691 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
692 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
693 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
694 INSERT INTO t3 (c1) VALUES('a');
695 SELECT COUNT(c1) FROM t2;
696 COUNT(c1)
697 7
698 DELETE FROM t2 WHERE c1 = 'd';
699 SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
700 COUNT(c1)
701 0
702 SELECT COUNT(c1) FROM t2;
703 COUNT(c1)
704 7
705 DROP TABLE t1,t2,t3;
706 CREATE TABLE t1(c1 CHAR(10) NOT NULL);
707 CREATE TABLE t2(c1 CHAR(10) NOT NULL);
708 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
709 CREATE TABLE t3(c1 CHAR(10) NOT NULL);
710 INSERT INTO t3 (c1) VALUES('a');
711 SELECT COUNT(c1) FROM t3;
712 COUNT(c1)
713 1
714 DELETE FROM t3 WHERE c1 = 'd';
715 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
716 COUNT(c1)
717 0
718 SELECT COUNT(c1) FROM t3;
719 COUNT(c1)
720 1
721 DROP TABLE t1,t2,t3;
722 CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
723 CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
724 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
725 CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
726 INSERT INTO t3 (c1) VALUES('a');
727 SELECT COUNT(c1) FROM t3;
728 COUNT(c1)
729 1
730 DELETE FROM t3 WHERE c1 = 'd';
731 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
732 COUNT(c1)
733 0
734 SELECT COUNT(c1) FROM t3;
735 COUNT(c1)
736 1
737 DROP TABLE t1,t2,t3;
738 CREATE TABLE t1(c1 BINARY(10) NOT NULL);
739 CREATE TABLE t2(c1 BINARY(10) NOT NULL);
740 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
741 CREATE TABLE t3(c1 BINARY(10) NOT NULL);
742 INSERT INTO t3 (c1) VALUES('a');
743 SELECT COUNT(c1) FROM t3;
744 COUNT(c1)
745 1
746 DELETE FROM t3 WHERE c1 = 'd';
747 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
748 COUNT(c1)
749 0
750 SELECT COUNT(c1) FROM t3;
751 COUNT(c1)
752 1
753 DROP TABLE t1,t2,t3;
754 CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
755 CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
756 INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
757 CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
758 INSERT INTO t3 (c1) VALUES('a');
759 SELECT COUNT(c1) FROM t3;
760 COUNT(c1)
761 1
762 DELETE FROM t3 WHERE c1 = 'd';
763 SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
764 COUNT(c1)
765 0
766 SELECT COUNT(c1) FROM t3;
767 COUNT(c1)
768 1
769 DROP TABLE t1,t2,t3;