1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 TINYINT NOT NULL); 5INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 6DELETE FROM t1 WHERE c1 >= 5; 7SELECT * FROM t1 ORDER BY c1; 8DELETE FROM t1; 9SELECT * FROM t1 ORDER BY c1; 10DROP TABLE t1; 11CREATE TABLE t1(c1 SMALLINT NOT NULL); 12INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 13DELETE FROM t1 WHERE c1 >= 5; 14SELECT * FROM t1 ORDER BY c1; 15DELETE FROM t1; 16SELECT * FROM t1 ORDER BY c1; 17DROP TABLE t1; 18CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 19INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 20DELETE FROM t1 WHERE c1 >= 5; 21SELECT * FROM t1 ORDER BY c1; 22DELETE FROM t1; 23SELECT * FROM t1 ORDER BY c1; 24DROP TABLE t1; 25CREATE TABLE t1(c1 INT NOT NULL); 26INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 27DELETE FROM t1 WHERE c1 >= 5; 28SELECT * FROM t1 ORDER BY c1; 29DELETE FROM t1; 30SELECT * FROM t1 ORDER BY c1; 31DROP TABLE t1; 32CREATE TABLE t1(c1 INTEGER NOT NULL); 33INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 34DELETE FROM t1 WHERE c1 >= 5; 35SELECT * FROM t1 ORDER BY c1; 36DELETE FROM t1; 37SELECT * FROM t1 ORDER BY c1; 38DROP TABLE t1; 39CREATE TABLE t1(c1 BIGINT NOT NULL); 40INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 41DELETE FROM t1 WHERE c1 >= 5; 42SELECT * FROM t1 ORDER BY c1; 43DELETE FROM t1; 44SELECT * FROM t1 ORDER BY c1; 45DROP TABLE t1; 46CREATE TABLE t1(c1 TINYINT NOT NULL); 47INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 48DELETE IGNORE FROM t1 WHERE c1 >= 5; 49SELECT * FROM t1 ORDER BY c1; 50DELETE IGNORE FROM t1; 51SELECT * FROM t1 ORDER BY c1; 52DROP TABLE t1; 53CREATE TABLE t1(c1 SMALLINT NOT NULL); 54INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 55DELETE IGNORE FROM t1 WHERE c1 >= 5; 56SELECT * FROM t1 ORDER BY c1; 57DELETE IGNORE FROM t1; 58SELECT * FROM t1 ORDER BY c1; 59DROP TABLE t1; 60CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 61INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 62DELETE IGNORE FROM t1 WHERE c1 >= 5; 63SELECT * FROM t1 ORDER BY c1; 64DELETE IGNORE FROM t1; 65SELECT * FROM t1 ORDER BY c1; 66DROP TABLE t1; 67CREATE TABLE t1(c1 INT NOT NULL); 68INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 69DELETE IGNORE FROM t1 WHERE c1 >= 5; 70SELECT * FROM t1 ORDER BY c1; 71DELETE IGNORE FROM t1; 72SELECT * FROM t1 ORDER BY c1; 73DROP TABLE t1; 74CREATE TABLE t1(c1 INTEGER NOT NULL); 75INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 76DELETE IGNORE FROM t1 WHERE c1 >= 5; 77SELECT * FROM t1 ORDER BY c1; 78DELETE IGNORE FROM t1; 79SELECT * FROM t1 ORDER BY c1; 80DROP TABLE t1; 81CREATE TABLE t1(c1 BIGINT NOT NULL); 82INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 83DELETE IGNORE FROM t1 WHERE c1 >= 5; 84SELECT * FROM t1 ORDER BY c1; 85DELETE IGNORE FROM t1; 86SELECT * FROM t1 ORDER BY c1; 87DROP TABLE t1; 88 89