1DROP TABLE IF EXISTS t1,t2,t3;
2CREATE TABLE t1(c1 CHAR(10) NOT NULL);
3CREATE TABLE t2(c1 CHAR(10) NOT NULL);
4INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
5CREATE TABLE t3(c1 CHAR(10) NOT NULL);
6INSERT INTO t3 (c1) VALUES('a');
7SELECT COUNT(c1) FROM t1;
8COUNT(c1)
90
10DELETE FROM t1 WHERE c1 = 'a';
11SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
12COUNT(c1)
130
14SELECT COUNT(c1) FROM t1;
15COUNT(c1)
160
17DROP TABLE t1,t2,t3;
18CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
19CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
20INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
21CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
22INSERT INTO t3 (c1) VALUES('a');
23SELECT COUNT(c1) FROM t1;
24COUNT(c1)
250
26DELETE FROM t1 WHERE c1 = 'a';
27SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
28COUNT(c1)
290
30SELECT COUNT(c1) FROM t1;
31COUNT(c1)
320
33DROP TABLE t1,t2,t3;
34CREATE TABLE t1(c1 BINARY(10) NOT NULL);
35CREATE TABLE t2(c1 BINARY(10) NOT NULL);
36INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
37CREATE TABLE t3(c1 BINARY(10) NOT NULL);
38INSERT INTO t3 (c1) VALUES('a');
39SELECT COUNT(c1) FROM t1;
40COUNT(c1)
410
42DELETE FROM t1 WHERE c1 = 'a';
43SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
44COUNT(c1)
450
46SELECT COUNT(c1) FROM t1;
47COUNT(c1)
480
49DROP TABLE t1,t2,t3;
50CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
51CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
52INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
53CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
54INSERT INTO t3 (c1) VALUES('a');
55SELECT COUNT(c1) FROM t1;
56COUNT(c1)
570
58DELETE FROM t1 WHERE c1 = 'a';
59SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
60COUNT(c1)
610
62SELECT COUNT(c1) FROM t1;
63COUNT(c1)
640
65DROP TABLE t1,t2,t3;
66CREATE TABLE t1(c1 CHAR(10) NOT NULL);
67CREATE TABLE t2(c1 CHAR(10) NOT NULL);
68INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
69CREATE TABLE t3(c1 CHAR(10) NOT NULL);
70INSERT INTO t3 (c1) VALUES('a');
71SELECT COUNT(c1) FROM t2;
72COUNT(c1)
737
74DELETE FROM t2 WHERE c1 = 'a';
75SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
76COUNT(c1)
770
78SELECT COUNT(c1) FROM t2;
79COUNT(c1)
806
81DROP TABLE t1,t2,t3;
82CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
83CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
84INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
85CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
86INSERT INTO t3 (c1) VALUES('a');
87SELECT COUNT(c1) FROM t2;
88COUNT(c1)
897
90DELETE FROM t2 WHERE c1 = 'a';
91SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
92COUNT(c1)
930
94SELECT COUNT(c1) FROM t2;
95COUNT(c1)
966
97DROP TABLE t1,t2,t3;
98CREATE TABLE t1(c1 BINARY(10) NOT NULL);
99CREATE TABLE t2(c1 BINARY(10) NOT NULL);
100INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
101CREATE TABLE t3(c1 BINARY(10) NOT NULL);
102INSERT INTO t3 (c1) VALUES('a');
103SELECT COUNT(c1) FROM t2;
104COUNT(c1)
1057
106DELETE FROM t2 WHERE c1 = 'a';
107SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
108COUNT(c1)
1090
110SELECT COUNT(c1) FROM t2;
111COUNT(c1)
1127
113DROP TABLE t1,t2,t3;
114CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
115CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
116INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
117CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
118INSERT INTO t3 (c1) VALUES('a');
119SELECT COUNT(c1) FROM t2;
120COUNT(c1)
1217
122DELETE FROM t2 WHERE c1 = 'a';
123SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
124COUNT(c1)
1250
126SELECT COUNT(c1) FROM t2;
127COUNT(c1)
1286
129DROP TABLE t1,t2,t3;
130CREATE TABLE t1(c1 CHAR(10) NOT NULL);
131CREATE TABLE t2(c1 CHAR(10) NOT NULL);
132INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
133CREATE TABLE t3(c1 CHAR(10) NOT NULL);
134INSERT INTO t3 (c1) VALUES('a');
135SELECT COUNT(c1) FROM t3;
136COUNT(c1)
1371
138DELETE FROM t3 WHERE c1 = 'a';
139SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
140COUNT(c1)
1410
142SELECT COUNT(c1) FROM t3;
143COUNT(c1)
1440
145DROP TABLE t1,t2,t3;
146CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
147CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
148INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
149CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
150INSERT INTO t3 (c1) VALUES('a');
151SELECT COUNT(c1) FROM t3;
152COUNT(c1)
1531
154DELETE FROM t3 WHERE c1 = 'a';
155SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
156COUNT(c1)
1570
158SELECT COUNT(c1) FROM t3;
159COUNT(c1)
1600
161DROP TABLE t1,t2,t3;
162CREATE TABLE t1(c1 BINARY(10) NOT NULL);
163CREATE TABLE t2(c1 BINARY(10) NOT NULL);
164INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
165CREATE TABLE t3(c1 BINARY(10) NOT NULL);
166INSERT INTO t3 (c1) VALUES('a');
167SELECT COUNT(c1) FROM t3;
168COUNT(c1)
1691
170DELETE FROM t3 WHERE c1 = 'a';
171SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
172COUNT(c1)
1730
174SELECT COUNT(c1) FROM t3;
175COUNT(c1)
1761
177DROP TABLE t1,t2,t3;
178CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
179CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
180INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
181CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
182INSERT INTO t3 (c1) VALUES('a');
183SELECT COUNT(c1) FROM t3;
184COUNT(c1)
1851
186DELETE FROM t3 WHERE c1 = 'a';
187SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
188COUNT(c1)
1890
190SELECT COUNT(c1) FROM t3;
191COUNT(c1)
1920
193DROP TABLE t1,t2,t3;
194CREATE TABLE t1(c1 CHAR(10) NOT NULL);
195CREATE TABLE t2(c1 CHAR(10) NOT NULL);
196INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
197CREATE TABLE t3(c1 CHAR(10) NOT NULL);
198INSERT INTO t3 (c1) VALUES('a');
199SELECT COUNT(c1) FROM t1;
200COUNT(c1)
2010
202DELETE FROM t1 WHERE c1 = 'b';
203SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
204COUNT(c1)
2050
206SELECT COUNT(c1) FROM t1;
207COUNT(c1)
2080
209DROP TABLE t1,t2,t3;
210CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
211CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
212INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
213CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
214INSERT INTO t3 (c1) VALUES('a');
215SELECT COUNT(c1) FROM t1;
216COUNT(c1)
2170
218DELETE FROM t1 WHERE c1 = 'b';
219SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
220COUNT(c1)
2210
222SELECT COUNT(c1) FROM t1;
223COUNT(c1)
2240
225DROP TABLE t1,t2,t3;
226CREATE TABLE t1(c1 BINARY(10) NOT NULL);
227CREATE TABLE t2(c1 BINARY(10) NOT NULL);
228INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
229CREATE TABLE t3(c1 BINARY(10) NOT NULL);
230INSERT INTO t3 (c1) VALUES('a');
231SELECT COUNT(c1) FROM t1;
232COUNT(c1)
2330
234DELETE FROM t1 WHERE c1 = 'b';
235SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
236COUNT(c1)
2370
238SELECT COUNT(c1) FROM t1;
239COUNT(c1)
2400
241DROP TABLE t1,t2,t3;
242CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
243CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
244INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
245CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
246INSERT INTO t3 (c1) VALUES('a');
247SELECT COUNT(c1) FROM t1;
248COUNT(c1)
2490
250DELETE FROM t1 WHERE c1 = 'b';
251SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
252COUNT(c1)
2530
254SELECT COUNT(c1) FROM t1;
255COUNT(c1)
2560
257DROP TABLE t1,t2,t3;
258CREATE TABLE t1(c1 CHAR(10) NOT NULL);
259CREATE TABLE t2(c1 CHAR(10) NOT NULL);
260INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
261CREATE TABLE t3(c1 CHAR(10) NOT NULL);
262INSERT INTO t3 (c1) VALUES('a');
263SELECT COUNT(c1) FROM t2;
264COUNT(c1)
2657
266DELETE FROM t2 WHERE c1 = 'b';
267SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
268COUNT(c1)
2690
270SELECT COUNT(c1) FROM t2;
271COUNT(c1)
2725
273DROP TABLE t1,t2,t3;
274CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
275CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
276INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
277CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
278INSERT INTO t3 (c1) VALUES('a');
279SELECT COUNT(c1) FROM t2;
280COUNT(c1)
2817
282DELETE FROM t2 WHERE c1 = 'b';
283SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
284COUNT(c1)
2850
286SELECT COUNT(c1) FROM t2;
287COUNT(c1)
2885
289DROP TABLE t1,t2,t3;
290CREATE TABLE t1(c1 BINARY(10) NOT NULL);
291CREATE TABLE t2(c1 BINARY(10) NOT NULL);
292INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
293CREATE TABLE t3(c1 BINARY(10) NOT NULL);
294INSERT INTO t3 (c1) VALUES('a');
295SELECT COUNT(c1) FROM t2;
296COUNT(c1)
2977
298DELETE FROM t2 WHERE c1 = 'b';
299SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
300COUNT(c1)
3010
302SELECT COUNT(c1) FROM t2;
303COUNT(c1)
3047
305DROP TABLE t1,t2,t3;
306CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
307CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
308INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
309CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
310INSERT INTO t3 (c1) VALUES('a');
311SELECT COUNT(c1) FROM t2;
312COUNT(c1)
3137
314DELETE FROM t2 WHERE c1 = 'b';
315SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
316COUNT(c1)
3170
318SELECT COUNT(c1) FROM t2;
319COUNT(c1)
3205
321DROP TABLE t1,t2,t3;
322CREATE TABLE t1(c1 CHAR(10) NOT NULL);
323CREATE TABLE t2(c1 CHAR(10) NOT NULL);
324INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
325CREATE TABLE t3(c1 CHAR(10) NOT NULL);
326INSERT INTO t3 (c1) VALUES('a');
327SELECT COUNT(c1) FROM t3;
328COUNT(c1)
3291
330DELETE FROM t3 WHERE c1 = 'b';
331SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
332COUNT(c1)
3330
334SELECT COUNT(c1) FROM t3;
335COUNT(c1)
3361
337DROP TABLE t1,t2,t3;
338CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
339CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
340INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
341CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
342INSERT INTO t3 (c1) VALUES('a');
343SELECT COUNT(c1) FROM t3;
344COUNT(c1)
3451
346DELETE FROM t3 WHERE c1 = 'b';
347SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
348COUNT(c1)
3490
350SELECT COUNT(c1) FROM t3;
351COUNT(c1)
3521
353DROP TABLE t1,t2,t3;
354CREATE TABLE t1(c1 BINARY(10) NOT NULL);
355CREATE TABLE t2(c1 BINARY(10) NOT NULL);
356INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
357CREATE TABLE t3(c1 BINARY(10) NOT NULL);
358INSERT INTO t3 (c1) VALUES('a');
359SELECT COUNT(c1) FROM t3;
360COUNT(c1)
3611
362DELETE FROM t3 WHERE c1 = 'b';
363SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
364COUNT(c1)
3650
366SELECT COUNT(c1) FROM t3;
367COUNT(c1)
3681
369DROP TABLE t1,t2,t3;
370CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
371CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
372INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
373CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
374INSERT INTO t3 (c1) VALUES('a');
375SELECT COUNT(c1) FROM t3;
376COUNT(c1)
3771
378DELETE FROM t3 WHERE c1 = 'b';
379SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
380COUNT(c1)
3810
382SELECT COUNT(c1) FROM t3;
383COUNT(c1)
3841
385DROP TABLE t1,t2,t3;
386CREATE TABLE t1(c1 CHAR(10) NOT NULL);
387CREATE TABLE t2(c1 CHAR(10) NOT NULL);
388INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
389CREATE TABLE t3(c1 CHAR(10) NOT NULL);
390INSERT INTO t3 (c1) VALUES('a');
391SELECT COUNT(c1) FROM t1;
392COUNT(c1)
3930
394DELETE FROM t1 WHERE c1 = 'c';
395SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
396COUNT(c1)
3970
398SELECT COUNT(c1) FROM t1;
399COUNT(c1)
4000
401DROP TABLE t1,t2,t3;
402CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
403CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
404INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
405CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
406INSERT INTO t3 (c1) VALUES('a');
407SELECT COUNT(c1) FROM t1;
408COUNT(c1)
4090
410DELETE FROM t1 WHERE c1 = 'c';
411SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
412COUNT(c1)
4130
414SELECT COUNT(c1) FROM t1;
415COUNT(c1)
4160
417DROP TABLE t1,t2,t3;
418CREATE TABLE t1(c1 BINARY(10) NOT NULL);
419CREATE TABLE t2(c1 BINARY(10) NOT NULL);
420INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
421CREATE TABLE t3(c1 BINARY(10) NOT NULL);
422INSERT INTO t3 (c1) VALUES('a');
423SELECT COUNT(c1) FROM t1;
424COUNT(c1)
4250
426DELETE FROM t1 WHERE c1 = 'c';
427SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
428COUNT(c1)
4290
430SELECT COUNT(c1) FROM t1;
431COUNT(c1)
4320
433DROP TABLE t1,t2,t3;
434CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
435CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
436INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
437CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
438INSERT INTO t3 (c1) VALUES('a');
439SELECT COUNT(c1) FROM t1;
440COUNT(c1)
4410
442DELETE FROM t1 WHERE c1 = 'c';
443SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
444COUNT(c1)
4450
446SELECT COUNT(c1) FROM t1;
447COUNT(c1)
4480
449DROP TABLE t1,t2,t3;
450CREATE TABLE t1(c1 CHAR(10) NOT NULL);
451CREATE TABLE t2(c1 CHAR(10) NOT NULL);
452INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
453CREATE TABLE t3(c1 CHAR(10) NOT NULL);
454INSERT INTO t3 (c1) VALUES('a');
455SELECT COUNT(c1) FROM t2;
456COUNT(c1)
4577
458DELETE FROM t2 WHERE c1 = 'c';
459SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
460COUNT(c1)
4610
462SELECT COUNT(c1) FROM t2;
463COUNT(c1)
4646
465DROP TABLE t1,t2,t3;
466CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
467CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
468INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
469CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
470INSERT INTO t3 (c1) VALUES('a');
471SELECT COUNT(c1) FROM t2;
472COUNT(c1)
4737
474DELETE FROM t2 WHERE c1 = 'c';
475SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
476COUNT(c1)
4770
478SELECT COUNT(c1) FROM t2;
479COUNT(c1)
4806
481DROP TABLE t1,t2,t3;
482CREATE TABLE t1(c1 BINARY(10) NOT NULL);
483CREATE TABLE t2(c1 BINARY(10) NOT NULL);
484INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
485CREATE TABLE t3(c1 BINARY(10) NOT NULL);
486INSERT INTO t3 (c1) VALUES('a');
487SELECT COUNT(c1) FROM t2;
488COUNT(c1)
4897
490DELETE FROM t2 WHERE c1 = 'c';
491SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
492COUNT(c1)
4930
494SELECT COUNT(c1) FROM t2;
495COUNT(c1)
4967
497DROP TABLE t1,t2,t3;
498CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
499CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
500INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
501CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
502INSERT INTO t3 (c1) VALUES('a');
503SELECT COUNT(c1) FROM t2;
504COUNT(c1)
5057
506DELETE FROM t2 WHERE c1 = 'c';
507SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
508COUNT(c1)
5090
510SELECT COUNT(c1) FROM t2;
511COUNT(c1)
5126
513DROP TABLE t1,t2,t3;
514CREATE TABLE t1(c1 CHAR(10) NOT NULL);
515CREATE TABLE t2(c1 CHAR(10) NOT NULL);
516INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
517CREATE TABLE t3(c1 CHAR(10) NOT NULL);
518INSERT INTO t3 (c1) VALUES('a');
519SELECT COUNT(c1) FROM t3;
520COUNT(c1)
5211
522DELETE FROM t3 WHERE c1 = 'c';
523SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
524COUNT(c1)
5250
526SELECT COUNT(c1) FROM t3;
527COUNT(c1)
5281
529DROP TABLE t1,t2,t3;
530CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
531CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
532INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
533CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
534INSERT INTO t3 (c1) VALUES('a');
535SELECT COUNT(c1) FROM t3;
536COUNT(c1)
5371
538DELETE FROM t3 WHERE c1 = 'c';
539SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
540COUNT(c1)
5410
542SELECT COUNT(c1) FROM t3;
543COUNT(c1)
5441
545DROP TABLE t1,t2,t3;
546CREATE TABLE t1(c1 BINARY(10) NOT NULL);
547CREATE TABLE t2(c1 BINARY(10) NOT NULL);
548INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
549CREATE TABLE t3(c1 BINARY(10) NOT NULL);
550INSERT INTO t3 (c1) VALUES('a');
551SELECT COUNT(c1) FROM t3;
552COUNT(c1)
5531
554DELETE FROM t3 WHERE c1 = 'c';
555SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
556COUNT(c1)
5570
558SELECT COUNT(c1) FROM t3;
559COUNT(c1)
5601
561DROP TABLE t1,t2,t3;
562CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
563CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
564INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
565CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
566INSERT INTO t3 (c1) VALUES('a');
567SELECT COUNT(c1) FROM t3;
568COUNT(c1)
5691
570DELETE FROM t3 WHERE c1 = 'c';
571SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
572COUNT(c1)
5730
574SELECT COUNT(c1) FROM t3;
575COUNT(c1)
5761
577DROP TABLE t1,t2,t3;
578CREATE TABLE t1(c1 CHAR(10) NOT NULL);
579CREATE TABLE t2(c1 CHAR(10) NOT NULL);
580INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
581CREATE TABLE t3(c1 CHAR(10) NOT NULL);
582INSERT INTO t3 (c1) VALUES('a');
583SELECT COUNT(c1) FROM t1;
584COUNT(c1)
5850
586DELETE FROM t1 WHERE c1 = 'd';
587SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
588COUNT(c1)
5890
590SELECT COUNT(c1) FROM t1;
591COUNT(c1)
5920
593DROP TABLE t1,t2,t3;
594CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
595CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
596INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
597CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
598INSERT INTO t3 (c1) VALUES('a');
599SELECT COUNT(c1) FROM t1;
600COUNT(c1)
6010
602DELETE FROM t1 WHERE c1 = 'd';
603SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
604COUNT(c1)
6050
606SELECT COUNT(c1) FROM t1;
607COUNT(c1)
6080
609DROP TABLE t1,t2,t3;
610CREATE TABLE t1(c1 BINARY(10) NOT NULL);
611CREATE TABLE t2(c1 BINARY(10) NOT NULL);
612INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
613CREATE TABLE t3(c1 BINARY(10) NOT NULL);
614INSERT INTO t3 (c1) VALUES('a');
615SELECT COUNT(c1) FROM t1;
616COUNT(c1)
6170
618DELETE FROM t1 WHERE c1 = 'd';
619SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
620COUNT(c1)
6210
622SELECT COUNT(c1) FROM t1;
623COUNT(c1)
6240
625DROP TABLE t1,t2,t3;
626CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
627CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
628INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
629CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
630INSERT INTO t3 (c1) VALUES('a');
631SELECT COUNT(c1) FROM t1;
632COUNT(c1)
6330
634DELETE FROM t1 WHERE c1 = 'd';
635SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
636COUNT(c1)
6370
638SELECT COUNT(c1) FROM t1;
639COUNT(c1)
6400
641DROP TABLE t1,t2,t3;
642CREATE TABLE t1(c1 CHAR(10) NOT NULL);
643CREATE TABLE t2(c1 CHAR(10) NOT NULL);
644INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
645CREATE TABLE t3(c1 CHAR(10) NOT NULL);
646INSERT INTO t3 (c1) VALUES('a');
647SELECT COUNT(c1) FROM t2;
648COUNT(c1)
6497
650DELETE FROM t2 WHERE c1 = 'd';
651SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
652COUNT(c1)
6530
654SELECT COUNT(c1) FROM t2;
655COUNT(c1)
6567
657DROP TABLE t1,t2,t3;
658CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
659CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
660INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
661CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
662INSERT INTO t3 (c1) VALUES('a');
663SELECT COUNT(c1) FROM t2;
664COUNT(c1)
6657
666DELETE FROM t2 WHERE c1 = 'd';
667SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
668COUNT(c1)
6690
670SELECT COUNT(c1) FROM t2;
671COUNT(c1)
6727
673DROP TABLE t1,t2,t3;
674CREATE TABLE t1(c1 BINARY(10) NOT NULL);
675CREATE TABLE t2(c1 BINARY(10) NOT NULL);
676INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
677CREATE TABLE t3(c1 BINARY(10) NOT NULL);
678INSERT INTO t3 (c1) VALUES('a');
679SELECT COUNT(c1) FROM t2;
680COUNT(c1)
6817
682DELETE FROM t2 WHERE c1 = 'd';
683SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
684COUNT(c1)
6850
686SELECT COUNT(c1) FROM t2;
687COUNT(c1)
6887
689DROP TABLE t1,t2,t3;
690CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
691CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
692INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
693CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
694INSERT INTO t3 (c1) VALUES('a');
695SELECT COUNT(c1) FROM t2;
696COUNT(c1)
6977
698DELETE FROM t2 WHERE c1 = 'd';
699SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
700COUNT(c1)
7010
702SELECT COUNT(c1) FROM t2;
703COUNT(c1)
7047
705DROP TABLE t1,t2,t3;
706CREATE TABLE t1(c1 CHAR(10) NOT NULL);
707CREATE TABLE t2(c1 CHAR(10) NOT NULL);
708INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
709CREATE TABLE t3(c1 CHAR(10) NOT NULL);
710INSERT INTO t3 (c1) VALUES('a');
711SELECT COUNT(c1) FROM t3;
712COUNT(c1)
7131
714DELETE FROM t3 WHERE c1 = 'd';
715SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
716COUNT(c1)
7170
718SELECT COUNT(c1) FROM t3;
719COUNT(c1)
7201
721DROP TABLE t1,t2,t3;
722CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
723CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
724INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
725CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
726INSERT INTO t3 (c1) VALUES('a');
727SELECT COUNT(c1) FROM t3;
728COUNT(c1)
7291
730DELETE FROM t3 WHERE c1 = 'd';
731SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
732COUNT(c1)
7330
734SELECT COUNT(c1) FROM t3;
735COUNT(c1)
7361
737DROP TABLE t1,t2,t3;
738CREATE TABLE t1(c1 BINARY(10) NOT NULL);
739CREATE TABLE t2(c1 BINARY(10) NOT NULL);
740INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
741CREATE TABLE t3(c1 BINARY(10) NOT NULL);
742INSERT INTO t3 (c1) VALUES('a');
743SELECT COUNT(c1) FROM t3;
744COUNT(c1)
7451
746DELETE FROM t3 WHERE c1 = 'd';
747SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
748COUNT(c1)
7490
750SELECT COUNT(c1) FROM t3;
751COUNT(c1)
7521
753DROP TABLE t1,t2,t3;
754CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
755CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
756INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
757CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
758INSERT INTO t3 (c1) VALUES('a');
759SELECT COUNT(c1) FROM t3;
760COUNT(c1)
7611
762DELETE FROM t3 WHERE c1 = 'd';
763SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
764COUNT(c1)
7650
766SELECT COUNT(c1) FROM t3;
767COUNT(c1)
7681
769DROP TABLE t1,t2,t3;
770