Debian Codegraph @

mysql-test/suite/engines/funcs/r/de_quick.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NOT NULL);
3 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
4 DELETE FROM t1 WHERE c1 >= 5;
5 SELECT * FROM t1 ORDER BY c1;
6 c1
7 0
8 1
9 2
10 3
11 4
12 DELETE FROM t1;
13 SELECT * FROM t1 ORDER BY c1;
14 c1
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 SMALLINT NOT NULL);
17 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
18 DELETE FROM t1 WHERE c1 >= 5;
19 SELECT * FROM t1 ORDER BY c1;
20 c1
21 0
22 1
23 2
24 3
25 4
26 DELETE FROM t1;
27 SELECT * FROM t1 ORDER BY c1;
28 c1
29 DROP TABLE t1;
30 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
31 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
32 DELETE FROM t1 WHERE c1 >= 5;
33 SELECT * FROM t1 ORDER BY c1;
34 c1
35 0
36 1
37 2
38 3
39 4
40 DELETE FROM t1;
41 SELECT * FROM t1 ORDER BY c1;
42 c1
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 INT NOT NULL);
45 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
46 DELETE FROM t1 WHERE c1 >= 5;
47 SELECT * FROM t1 ORDER BY c1;
48 c1
49 0
50 1
51 2
52 3
53 4
54 DELETE FROM t1;
55 SELECT * FROM t1 ORDER BY c1;
56 c1
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 INTEGER NOT NULL);
59 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
60 DELETE FROM t1 WHERE c1 >= 5;
61 SELECT * FROM t1 ORDER BY c1;
62 c1
63 0
64 1
65 2
66 3
67 4
68 DELETE FROM t1;
69 SELECT * FROM t1 ORDER BY c1;
70 c1
71 DROP TABLE t1;
72 CREATE TABLE t1(c1 BIGINT NOT NULL);
73 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
74 DELETE FROM t1 WHERE c1 >= 5;
75 SELECT * FROM t1 ORDER BY c1;
76 c1
77 0
78 1
79 2
80 3
81 4
82 DELETE FROM t1;
83 SELECT * FROM t1 ORDER BY c1;
84 c1
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 TINYINT NOT NULL);
87 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
88 DELETE QUICK FROM t1 WHERE c1 >= 5;
89 SELECT * FROM t1 ORDER BY c1;
90 c1
91 0
92 1
93 2
94 3
95 4
96 DELETE QUICK FROM t1;
97 SELECT * FROM t1 ORDER BY c1;
98 c1
99 DROP TABLE t1;
100 CREATE TABLE t1(c1 SMALLINT NOT NULL);
101 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
102 DELETE QUICK FROM t1 WHERE c1 >= 5;
103 SELECT * FROM t1 ORDER BY c1;
104 c1
105 0
106 1
107 2
108 3
109 4
110 DELETE QUICK FROM t1;
111 SELECT * FROM t1 ORDER BY c1;
112 c1
113 DROP TABLE t1;
114 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
115 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
116 DELETE QUICK FROM t1 WHERE c1 >= 5;
117 SELECT * FROM t1 ORDER BY c1;
118 c1
119 0
120 1
121 2
122 3
123 4
124 DELETE QUICK FROM t1;
125 SELECT * FROM t1 ORDER BY c1;
126 c1
127 DROP TABLE t1;
128 CREATE TABLE t1(c1 INT NOT NULL);
129 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
130 DELETE QUICK FROM t1 WHERE c1 >= 5;
131 SELECT * FROM t1 ORDER BY c1;
132 c1
133 0
134 1
135 2
136 3
137 4
138 DELETE QUICK FROM t1;
139 SELECT * FROM t1 ORDER BY c1;
140 c1
141 DROP TABLE t1;
142 CREATE TABLE t1(c1 INTEGER NOT NULL);
143 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
144 DELETE QUICK FROM t1 WHERE c1 >= 5;
145 SELECT * FROM t1 ORDER BY c1;
146 c1
147 0
148 1
149 2
150 3
151 4
152 DELETE QUICK FROM t1;
153 SELECT * FROM t1 ORDER BY c1;
154 c1
155 DROP TABLE t1;
156 CREATE TABLE t1(c1 BIGINT NOT NULL);
157 INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
158 DELETE QUICK FROM t1 WHERE c1 >= 5;
159 SELECT * FROM t1 ORDER BY c1;
160 c1
161 0
162 1
163 2
164 3
165 4
166 DELETE QUICK FROM t1;
167 SELECT * FROM t1 ORDER BY c1;
168 c1
169 DROP TABLE t1;