Debian Codegraph @

mysql-test/suite/engines/funcs/t/de_ignore.test

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