1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
3 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
4 DELETE FROM t1 WHERE c1 >= 3;
5 SELECT * FROM t1 ORDER BY c1;
9 INSERT INTO t1 VALUES (null),(null),(null);
10 SELECT * FROM t1 ORDER BY c1;
18 SELECT * FROM t1 ORDER BY c1;
20 INSERT INTO t1 VALUES (null),(null),(null);
21 SELECT * FROM t1 ORDER BY c1;
27 CREATE TABLE t1(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
28 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
29 DELETE FROM t1 WHERE c1 >= 3;
30 SELECT * FROM t1 ORDER BY c1;
34 INSERT INTO t1 VALUES (null),(null),(null);
35 SELECT * FROM t1 ORDER BY c1;
43 SELECT * FROM t1 ORDER BY c1;
45 INSERT INTO t1 VALUES (null),(null),(null);
46 SELECT * FROM t1 ORDER BY c1;
52 CREATE TABLE t1(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
53 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
54 DELETE FROM t1 WHERE c1 >= 3;
55 SELECT * FROM t1 ORDER BY c1;
59 INSERT INTO t1 VALUES (null),(null),(null);
60 SELECT * FROM t1 ORDER BY c1;
68 SELECT * FROM t1 ORDER BY c1;
70 INSERT INTO t1 VALUES (null),(null),(null);
71 SELECT * FROM t1 ORDER BY c1;
77 CREATE TABLE t1(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
78 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
79 DELETE FROM t1 WHERE c1 >= 3;
80 SELECT * FROM t1 ORDER BY c1;
84 INSERT INTO t1 VALUES (null),(null),(null);
85 SELECT * FROM t1 ORDER BY c1;
93 SELECT * FROM t1 ORDER BY c1;
95 INSERT INTO t1 VALUES (null),(null),(null);
96 SELECT * FROM t1 ORDER BY c1;
102 CREATE TABLE t1(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
103 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
104 DELETE FROM t1 WHERE c1 >= 3;
105 SELECT * FROM t1 ORDER BY c1;
109 INSERT INTO t1 VALUES (null),(null),(null);
110 SELECT * FROM t1 ORDER BY c1;
118 SELECT * FROM t1 ORDER BY c1;
120 INSERT INTO t1 VALUES (null),(null),(null);
121 SELECT * FROM t1 ORDER BY c1;
127 CREATE TABLE t1(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
128 INSERT INTO t1 VALUES (null),(null),(null),(null),(null),(null);
129 DELETE FROM t1 WHERE c1 >= 3;
130 SELECT * FROM t1 ORDER BY c1;
134 INSERT INTO t1 VALUES (null),(null),(null);
135 SELECT * FROM t1 ORDER BY c1;
143 SELECT * FROM t1 ORDER BY c1;
145 INSERT INTO t1 VALUES (null),(null),(null);
146 SELECT * FROM t1 ORDER BY c1;