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