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;
10
DELETE FROM t1 WHERE c1 = 'a';
11
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
14
SELECT COUNT(c1) FROM t1;
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;
26
DELETE FROM t1 WHERE c1 = 'a';
27
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
30
SELECT COUNT(c1) FROM t1;
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;
42
DELETE FROM t1 WHERE c1 = 'a';
43
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
46
SELECT COUNT(c1) FROM t1;
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;
58
DELETE FROM t1 WHERE c1 = 'a';
59
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
62
SELECT COUNT(c1) FROM t1;
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;
74
DELETE FROM t2 WHERE c1 = 'a';
75
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
78
SELECT COUNT(c1) FROM t2;
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;
90
DELETE FROM t2 WHERE c1 = 'a';
91
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
94
SELECT COUNT(c1) FROM t2;
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;
106
DELETE FROM t2 WHERE c1 = 'a';
107
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
110
SELECT COUNT(c1) FROM t2;
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;
122
DELETE FROM t2 WHERE c1 = 'a';
123
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
126
SELECT COUNT(c1) FROM t2;
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;
138
DELETE FROM t3 WHERE c1 = 'a';
139
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
142
SELECT COUNT(c1) FROM 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;
154
DELETE FROM t3 WHERE c1 = 'a';
155
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
158
SELECT COUNT(c1) FROM 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;
170
DELETE FROM t3 WHERE c1 = 'a';
171
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
174
SELECT COUNT(c1) FROM 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;
186
DELETE FROM t3 WHERE c1 = 'a';
187
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
190
SELECT COUNT(c1) FROM 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;
202
DELETE FROM t1 WHERE c1 = 'b';
203
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
206
SELECT COUNT(c1) FROM t1;
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;
218
DELETE FROM t1 WHERE c1 = 'b';
219
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
222
SELECT COUNT(c1) FROM t1;
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;
234
DELETE FROM t1 WHERE c1 = 'b';
235
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
238
SELECT COUNT(c1) FROM t1;
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;
250
DELETE FROM t1 WHERE c1 = 'b';
251
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
254
SELECT COUNT(c1) FROM t1;
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;
266
DELETE FROM t2 WHERE c1 = 'b';
267
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
270
SELECT COUNT(c1) FROM t2;
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;
282
DELETE FROM t2 WHERE c1 = 'b';
283
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
286
SELECT COUNT(c1) FROM t2;
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;
298
DELETE FROM t2 WHERE c1 = 'b';
299
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
302
SELECT COUNT(c1) FROM t2;
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;
314
DELETE FROM t2 WHERE c1 = 'b';
315
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
318
SELECT COUNT(c1) FROM t2;
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;
330
DELETE FROM t3 WHERE c1 = 'b';
331
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
334
SELECT COUNT(c1) FROM 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;
346
DELETE FROM t3 WHERE c1 = 'b';
347
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
350
SELECT COUNT(c1) FROM 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;
362
DELETE FROM t3 WHERE c1 = 'b';
363
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
366
SELECT COUNT(c1) FROM 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;
378
DELETE FROM t3 WHERE c1 = 'b';
379
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
382
SELECT COUNT(c1) FROM 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;
394
DELETE FROM t1 WHERE c1 = 'c';
395
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
398
SELECT COUNT(c1) FROM t1;
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;
410
DELETE FROM t1 WHERE c1 = 'c';
411
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
414
SELECT COUNT(c1) FROM t1;
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;
426
DELETE FROM t1 WHERE c1 = 'c';
427
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
430
SELECT COUNT(c1) FROM t1;
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;
442
DELETE FROM t1 WHERE c1 = 'c';
443
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
446
SELECT COUNT(c1) FROM t1;
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;
458
DELETE FROM t2 WHERE c1 = 'c';
459
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
462
SELECT COUNT(c1) FROM t2;
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;
474
DELETE FROM t2 WHERE c1 = 'c';
475
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
478
SELECT COUNT(c1) FROM t2;
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;
490
DELETE FROM t2 WHERE c1 = 'c';
491
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
494
SELECT COUNT(c1) FROM t2;
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;
506
DELETE FROM t2 WHERE c1 = 'c';
507
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
510
SELECT COUNT(c1) FROM t2;
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;
522
DELETE FROM t3 WHERE c1 = 'c';
523
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
526
SELECT COUNT(c1) FROM 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;
538
DELETE FROM t3 WHERE c1 = 'c';
539
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
542
SELECT COUNT(c1) FROM 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;
554
DELETE FROM t3 WHERE c1 = 'c';
555
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
558
SELECT COUNT(c1) FROM 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;
570
DELETE FROM t3 WHERE c1 = 'c';
571
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
574
SELECT COUNT(c1) FROM 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;
586
DELETE FROM t1 WHERE c1 = 'd';
587
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
590
SELECT COUNT(c1) FROM t1;
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;
602
DELETE FROM t1 WHERE c1 = 'd';
603
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
606
SELECT COUNT(c1) FROM t1;
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;
618
DELETE FROM t1 WHERE c1 = 'd';
619
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
622
SELECT COUNT(c1) FROM t1;
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;
634
DELETE FROM t1 WHERE c1 = 'd';
635
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
638
SELECT COUNT(c1) FROM t1;
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;
650
DELETE FROM t2 WHERE c1 = 'd';
651
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
654
SELECT COUNT(c1) FROM t2;
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;
666
DELETE FROM t2 WHERE c1 = 'd';
667
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
670
SELECT COUNT(c1) FROM t2;
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;
682
DELETE FROM t2 WHERE c1 = 'd';
683
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
686
SELECT COUNT(c1) FROM t2;
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;
698
DELETE FROM t2 WHERE c1 = 'd';
699
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
702
SELECT COUNT(c1) FROM t2;
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;
714
DELETE FROM t3 WHERE c1 = 'd';
715
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
718
SELECT COUNT(c1) FROM 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;
730
DELETE FROM t3 WHERE c1 = 'd';
731
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
734
SELECT COUNT(c1) FROM 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;
746
DELETE FROM t3 WHERE c1 = 'd';
747
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
750
SELECT COUNT(c1) FROM 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;
762
DELETE FROM t3 WHERE c1 = 'd';
763
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
766
SELECT COUNT(c1) FROM t3;