Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1,t2,t3;
3 --enable_warnings
4 CREATE TABLE t1(c1 TINYINT NOT NULL);
5 CREATE TABLE t2(c1 TINYINT NOT NULL);
6 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7 CREATE TABLE t3(c1 TINYINT NOT NULL);
8 INSERT INTO t3 (c1) VALUES(5);
9 SELECT COUNT(c1),SUM(c1) FROM t1;
10 DELETE FROM t1 WHERE c1 < 5;
11 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
12 SELECT COUNT(c1),SUM(c1) FROM t1;
13 DROP TABLE t1,t2,t3;
14 CREATE TABLE t1(c1 SMALLINT NOT NULL);
15 CREATE TABLE t2(c1 SMALLINT NOT NULL);
16 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
17 CREATE TABLE t3(c1 SMALLINT NOT NULL);
18 INSERT INTO t3 (c1) VALUES(5);
19 SELECT COUNT(c1),SUM(c1) FROM t1;
20 DELETE FROM t1 WHERE c1 < 5;
21 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
22 SELECT COUNT(c1),SUM(c1) FROM t1;
23 DROP TABLE t1,t2,t3;
24 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
25 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
26 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
27 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
28 INSERT INTO t3 (c1) VALUES(5);
29 SELECT COUNT(c1),SUM(c1) FROM t1;
30 DELETE FROM t1 WHERE c1 < 5;
31 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
32 SELECT COUNT(c1),SUM(c1) FROM t1;
33 DROP TABLE t1,t2,t3;
34 CREATE TABLE t1(c1 INT NOT NULL);
35 CREATE TABLE t2(c1 INT NOT NULL);
36 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
37 CREATE TABLE t3(c1 INT NOT NULL);
38 INSERT INTO t3 (c1) VALUES(5);
39 SELECT COUNT(c1),SUM(c1) FROM t1;
40 DELETE FROM t1 WHERE c1 < 5;
41 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
42 SELECT COUNT(c1),SUM(c1) FROM t1;
43 DROP TABLE t1,t2,t3;
44 CREATE TABLE t1(c1 INTEGER NOT NULL);
45 CREATE TABLE t2(c1 INTEGER NOT NULL);
46 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
47 CREATE TABLE t3(c1 INTEGER NOT NULL);
48 INSERT INTO t3 (c1) VALUES(5);
49 SELECT COUNT(c1),SUM(c1) FROM t1;
50 DELETE FROM t1 WHERE c1 < 5;
51 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
52 SELECT COUNT(c1),SUM(c1) FROM t1;
53 DROP TABLE t1,t2,t3;
54 CREATE TABLE t1(c1 BIGINT NOT NULL);
55 CREATE TABLE t2(c1 BIGINT NOT NULL);
56 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
57 CREATE TABLE t3(c1 BIGINT NOT NULL);
58 INSERT INTO t3 (c1) VALUES(5);
59 SELECT COUNT(c1),SUM(c1) FROM t1;
60 DELETE FROM t1 WHERE c1 < 5;
61 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5;
62 SELECT COUNT(c1),SUM(c1) FROM t1;
63 DROP TABLE t1,t2,t3;
64 CREATE TABLE t1(c1 TINYINT NOT NULL);
65 CREATE TABLE t2(c1 TINYINT NOT NULL);
66 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
67 CREATE TABLE t3(c1 TINYINT NOT NULL);
68 INSERT INTO t3 (c1) VALUES(5);
69 SELECT COUNT(c1),SUM(c1) FROM t2;
70 DELETE FROM t2 WHERE c1 < 5;
71 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
72 SELECT COUNT(c1),SUM(c1) FROM t2;
73 DROP TABLE t1,t2,t3;
74 CREATE TABLE t1(c1 SMALLINT NOT NULL);
75 CREATE TABLE t2(c1 SMALLINT NOT NULL);
76 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
77 CREATE TABLE t3(c1 SMALLINT NOT NULL);
78 INSERT INTO t3 (c1) VALUES(5);
79 SELECT COUNT(c1),SUM(c1) FROM t2;
80 DELETE FROM t2 WHERE c1 < 5;
81 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
82 SELECT COUNT(c1),SUM(c1) FROM t2;
83 DROP TABLE t1,t2,t3;
84 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
85 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
86 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
87 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
88 INSERT INTO t3 (c1) VALUES(5);
89 SELECT COUNT(c1),SUM(c1) FROM t2;
90 DELETE FROM t2 WHERE c1 < 5;
91 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
92 SELECT COUNT(c1),SUM(c1) FROM t2;
93 DROP TABLE t1,t2,t3;
94 CREATE TABLE t1(c1 INT NOT NULL);
95 CREATE TABLE t2(c1 INT NOT NULL);
96 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
97 CREATE TABLE t3(c1 INT NOT NULL);
98 INSERT INTO t3 (c1) VALUES(5);
99 SELECT COUNT(c1),SUM(c1) FROM t2;
100 DELETE FROM t2 WHERE c1 < 5;
101 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
102 SELECT COUNT(c1),SUM(c1) FROM t2;
103 DROP TABLE t1,t2,t3;
104 CREATE TABLE t1(c1 INTEGER NOT NULL);
105 CREATE TABLE t2(c1 INTEGER NOT NULL);
106 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
107 CREATE TABLE t3(c1 INTEGER NOT NULL);
108 INSERT INTO t3 (c1) VALUES(5);
109 SELECT COUNT(c1),SUM(c1) FROM t2;
110 DELETE FROM t2 WHERE c1 < 5;
111 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
112 SELECT COUNT(c1),SUM(c1) FROM t2;
113 DROP TABLE t1,t2,t3;
114 CREATE TABLE t1(c1 BIGINT NOT NULL);
115 CREATE TABLE t2(c1 BIGINT NOT NULL);
116 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
117 CREATE TABLE t3(c1 BIGINT NOT NULL);
118 INSERT INTO t3 (c1) VALUES(5);
119 SELECT COUNT(c1),SUM(c1) FROM t2;
120 DELETE FROM t2 WHERE c1 < 5;
121 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5;
122 SELECT COUNT(c1),SUM(c1) FROM t2;
123 DROP TABLE t1,t2,t3;
124 CREATE TABLE t1(c1 TINYINT NOT NULL);
125 CREATE TABLE t2(c1 TINYINT NOT NULL);
126 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
127 CREATE TABLE t3(c1 TINYINT NOT NULL);
128 INSERT INTO t3 (c1) VALUES(5);
129 SELECT COUNT(c1),SUM(c1) FROM t3;
130 DELETE FROM t3 WHERE c1 < 5;
131 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
132 SELECT COUNT(c1),SUM(c1) FROM t3;
133 DROP TABLE t1,t2,t3;
134 CREATE TABLE t1(c1 SMALLINT NOT NULL);
135 CREATE TABLE t2(c1 SMALLINT NOT NULL);
136 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
137 CREATE TABLE t3(c1 SMALLINT NOT NULL);
138 INSERT INTO t3 (c1) VALUES(5);
139 SELECT COUNT(c1),SUM(c1) FROM t3;
140 DELETE FROM t3 WHERE c1 < 5;
141 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
142 SELECT COUNT(c1),SUM(c1) FROM t3;
143 DROP TABLE t1,t2,t3;
144 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
145 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
146 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
147 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
148 INSERT INTO t3 (c1) VALUES(5);
149 SELECT COUNT(c1),SUM(c1) FROM t3;
150 DELETE FROM t3 WHERE c1 < 5;
151 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
152 SELECT COUNT(c1),SUM(c1) FROM t3;
153 DROP TABLE t1,t2,t3;
154 CREATE TABLE t1(c1 INT NOT NULL);
155 CREATE TABLE t2(c1 INT NOT NULL);
156 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
157 CREATE TABLE t3(c1 INT NOT NULL);
158 INSERT INTO t3 (c1) VALUES(5);
159 SELECT COUNT(c1),SUM(c1) FROM t3;
160 DELETE FROM t3 WHERE c1 < 5;
161 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
162 SELECT COUNT(c1),SUM(c1) FROM t3;
163 DROP TABLE t1,t2,t3;
164 CREATE TABLE t1(c1 INTEGER NOT NULL);
165 CREATE TABLE t2(c1 INTEGER NOT NULL);
166 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
167 CREATE TABLE t3(c1 INTEGER NOT NULL);
168 INSERT INTO t3 (c1) VALUES(5);
169 SELECT COUNT(c1),SUM(c1) FROM t3;
170 DELETE FROM t3 WHERE c1 < 5;
171 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
172 SELECT COUNT(c1),SUM(c1) FROM t3;
173 DROP TABLE t1,t2,t3;
174 CREATE TABLE t1(c1 BIGINT NOT NULL);
175 CREATE TABLE t2(c1 BIGINT NOT NULL);
176 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
177 CREATE TABLE t3(c1 BIGINT NOT NULL);
178 INSERT INTO t3 (c1) VALUES(5);
179 SELECT COUNT(c1),SUM(c1) FROM t3;
180 DELETE FROM t3 WHERE c1 < 5;
181 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5;
182 SELECT COUNT(c1),SUM(c1) FROM t3;
183 DROP TABLE t1,t2,t3;
184 CREATE TABLE t1(c1 TINYINT NOT NULL);
185 CREATE TABLE t2(c1 TINYINT NOT NULL);
186 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
187 CREATE TABLE t3(c1 TINYINT NOT NULL);
188 INSERT INTO t3 (c1) VALUES(5);
189 SELECT COUNT(c1),SUM(c1) FROM t1;
190 DELETE FROM t1 WHERE c1 <= 5;
191 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
192 SELECT COUNT(c1),SUM(c1) FROM t1;
193 DROP TABLE t1,t2,t3;
194 CREATE TABLE t1(c1 SMALLINT NOT NULL);
195 CREATE TABLE t2(c1 SMALLINT NOT NULL);
196 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
197 CREATE TABLE t3(c1 SMALLINT NOT NULL);
198 INSERT INTO t3 (c1) VALUES(5);
199 SELECT COUNT(c1),SUM(c1) FROM t1;
200 DELETE FROM t1 WHERE c1 <= 5;
201 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
202 SELECT COUNT(c1),SUM(c1) FROM t1;
203 DROP TABLE t1,t2,t3;
204 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
205 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
206 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
207 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
208 INSERT INTO t3 (c1) VALUES(5);
209 SELECT COUNT(c1),SUM(c1) FROM t1;
210 DELETE FROM t1 WHERE c1 <= 5;
211 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
212 SELECT COUNT(c1),SUM(c1) FROM t1;
213 DROP TABLE t1,t2,t3;
214 CREATE TABLE t1(c1 INT NOT NULL);
215 CREATE TABLE t2(c1 INT NOT NULL);
216 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
217 CREATE TABLE t3(c1 INT NOT NULL);
218 INSERT INTO t3 (c1) VALUES(5);
219 SELECT COUNT(c1),SUM(c1) FROM t1;
220 DELETE FROM t1 WHERE c1 <= 5;
221 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
222 SELECT COUNT(c1),SUM(c1) FROM t1;
223 DROP TABLE t1,t2,t3;
224 CREATE TABLE t1(c1 INTEGER NOT NULL);
225 CREATE TABLE t2(c1 INTEGER NOT NULL);
226 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
227 CREATE TABLE t3(c1 INTEGER NOT NULL);
228 INSERT INTO t3 (c1) VALUES(5);
229 SELECT COUNT(c1),SUM(c1) FROM t1;
230 DELETE FROM t1 WHERE c1 <= 5;
231 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
232 SELECT COUNT(c1),SUM(c1) FROM t1;
233 DROP TABLE t1,t2,t3;
234 CREATE TABLE t1(c1 BIGINT NOT NULL);
235 CREATE TABLE t2(c1 BIGINT NOT NULL);
236 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
237 CREATE TABLE t3(c1 BIGINT NOT NULL);
238 INSERT INTO t3 (c1) VALUES(5);
239 SELECT COUNT(c1),SUM(c1) FROM t1;
240 DELETE FROM t1 WHERE c1 <= 5;
241 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5;
242 SELECT COUNT(c1),SUM(c1) FROM t1;
243 DROP TABLE t1,t2,t3;
244 CREATE TABLE t1(c1 TINYINT NOT NULL);
245 CREATE TABLE t2(c1 TINYINT NOT NULL);
246 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
247 CREATE TABLE t3(c1 TINYINT NOT NULL);
248 INSERT INTO t3 (c1) VALUES(5);
249 SELECT COUNT(c1),SUM(c1) FROM t2;
250 DELETE FROM t2 WHERE c1 <= 5;
251 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
252 SELECT COUNT(c1),SUM(c1) FROM t2;
253 DROP TABLE t1,t2,t3;
254 CREATE TABLE t1(c1 SMALLINT NOT NULL);
255 CREATE TABLE t2(c1 SMALLINT NOT NULL);
256 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
257 CREATE TABLE t3(c1 SMALLINT NOT NULL);
258 INSERT INTO t3 (c1) VALUES(5);
259 SELECT COUNT(c1),SUM(c1) FROM t2;
260 DELETE FROM t2 WHERE c1 <= 5;
261 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
262 SELECT COUNT(c1),SUM(c1) FROM t2;
263 DROP TABLE t1,t2,t3;
264 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
265 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
266 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
267 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
268 INSERT INTO t3 (c1) VALUES(5);
269 SELECT COUNT(c1),SUM(c1) FROM t2;
270 DELETE FROM t2 WHERE c1 <= 5;
271 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
272 SELECT COUNT(c1),SUM(c1) FROM t2;
273 DROP TABLE t1,t2,t3;
274 CREATE TABLE t1(c1 INT NOT NULL);
275 CREATE TABLE t2(c1 INT NOT NULL);
276 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
277 CREATE TABLE t3(c1 INT NOT NULL);
278 INSERT INTO t3 (c1) VALUES(5);
279 SELECT COUNT(c1),SUM(c1) FROM t2;
280 DELETE FROM t2 WHERE c1 <= 5;
281 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
282 SELECT COUNT(c1),SUM(c1) FROM t2;
283 DROP TABLE t1,t2,t3;
284 CREATE TABLE t1(c1 INTEGER NOT NULL);
285 CREATE TABLE t2(c1 INTEGER NOT NULL);
286 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
287 CREATE TABLE t3(c1 INTEGER NOT NULL);
288 INSERT INTO t3 (c1) VALUES(5);
289 SELECT COUNT(c1),SUM(c1) FROM t2;
290 DELETE FROM t2 WHERE c1 <= 5;
291 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
292 SELECT COUNT(c1),SUM(c1) FROM t2;
293 DROP TABLE t1,t2,t3;
294 CREATE TABLE t1(c1 BIGINT NOT NULL);
295 CREATE TABLE t2(c1 BIGINT NOT NULL);
296 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
297 CREATE TABLE t3(c1 BIGINT NOT NULL);
298 INSERT INTO t3 (c1) VALUES(5);
299 SELECT COUNT(c1),SUM(c1) FROM t2;
300 DELETE FROM t2 WHERE c1 <= 5;
301 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5;
302 SELECT COUNT(c1),SUM(c1) FROM t2;
303 DROP TABLE t1,t2,t3;
304 CREATE TABLE t1(c1 TINYINT NOT NULL);
305 CREATE TABLE t2(c1 TINYINT NOT NULL);
306 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
307 CREATE TABLE t3(c1 TINYINT NOT NULL);
308 INSERT INTO t3 (c1) VALUES(5);
309 SELECT COUNT(c1),SUM(c1) FROM t3;
310 DELETE FROM t3 WHERE c1 <= 5;
311 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
312 SELECT COUNT(c1),SUM(c1) FROM t3;
313 DROP TABLE t1,t2,t3;
314 CREATE TABLE t1(c1 SMALLINT NOT NULL);
315 CREATE TABLE t2(c1 SMALLINT NOT NULL);
316 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
317 CREATE TABLE t3(c1 SMALLINT NOT NULL);
318 INSERT INTO t3 (c1) VALUES(5);
319 SELECT COUNT(c1),SUM(c1) FROM t3;
320 DELETE FROM t3 WHERE c1 <= 5;
321 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
322 SELECT COUNT(c1),SUM(c1) FROM t3;
323 DROP TABLE t1,t2,t3;
324 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
325 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
326 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
327 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
328 INSERT INTO t3 (c1) VALUES(5);
329 SELECT COUNT(c1),SUM(c1) FROM t3;
330 DELETE FROM t3 WHERE c1 <= 5;
331 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
332 SELECT COUNT(c1),SUM(c1) FROM t3;
333 DROP TABLE t1,t2,t3;
334 CREATE TABLE t1(c1 INT NOT NULL);
335 CREATE TABLE t2(c1 INT NOT NULL);
336 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
337 CREATE TABLE t3(c1 INT NOT NULL);
338 INSERT INTO t3 (c1) VALUES(5);
339 SELECT COUNT(c1),SUM(c1) FROM t3;
340 DELETE FROM t3 WHERE c1 <= 5;
341 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
342 SELECT COUNT(c1),SUM(c1) FROM t3;
343 DROP TABLE t1,t2,t3;
344 CREATE TABLE t1(c1 INTEGER NOT NULL);
345 CREATE TABLE t2(c1 INTEGER NOT NULL);
346 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
347 CREATE TABLE t3(c1 INTEGER NOT NULL);
348 INSERT INTO t3 (c1) VALUES(5);
349 SELECT COUNT(c1),SUM(c1) FROM t3;
350 DELETE FROM t3 WHERE c1 <= 5;
351 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
352 SELECT COUNT(c1),SUM(c1) FROM t3;
353 DROP TABLE t1,t2,t3;
354 CREATE TABLE t1(c1 BIGINT NOT NULL);
355 CREATE TABLE t2(c1 BIGINT NOT NULL);
356 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
357 CREATE TABLE t3(c1 BIGINT NOT NULL);
358 INSERT INTO t3 (c1) VALUES(5);
359 SELECT COUNT(c1),SUM(c1) FROM t3;
360 DELETE FROM t3 WHERE c1 <= 5;
361 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5;
362 SELECT COUNT(c1),SUM(c1) FROM t3;
363 DROP TABLE t1,t2,t3;
364 CREATE TABLE t1(c1 TINYINT NOT NULL);
365 CREATE TABLE t2(c1 TINYINT NOT NULL);
366 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
367 CREATE TABLE t3(c1 TINYINT NOT NULL);
368 INSERT INTO t3 (c1) VALUES(5);
369 SELECT COUNT(c1),SUM(c1) FROM t1;
370 DELETE FROM t1 WHERE c1 = 5;
371 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
372 SELECT COUNT(c1),SUM(c1) FROM t1;
373 DROP TABLE t1,t2,t3;
374 CREATE TABLE t1(c1 SMALLINT NOT NULL);
375 CREATE TABLE t2(c1 SMALLINT NOT NULL);
376 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
377 CREATE TABLE t3(c1 SMALLINT NOT NULL);
378 INSERT INTO t3 (c1) VALUES(5);
379 SELECT COUNT(c1),SUM(c1) FROM t1;
380 DELETE FROM t1 WHERE c1 = 5;
381 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
382 SELECT COUNT(c1),SUM(c1) FROM t1;
383 DROP TABLE t1,t2,t3;
384 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
385 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
386 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
387 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
388 INSERT INTO t3 (c1) VALUES(5);
389 SELECT COUNT(c1),SUM(c1) FROM t1;
390 DELETE FROM t1 WHERE c1 = 5;
391 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
392 SELECT COUNT(c1),SUM(c1) FROM t1;
393 DROP TABLE t1,t2,t3;
394 CREATE TABLE t1(c1 INT NOT NULL);
395 CREATE TABLE t2(c1 INT NOT NULL);
396 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
397 CREATE TABLE t3(c1 INT NOT NULL);
398 INSERT INTO t3 (c1) VALUES(5);
399 SELECT COUNT(c1),SUM(c1) FROM t1;
400 DELETE FROM t1 WHERE c1 = 5;
401 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
402 SELECT COUNT(c1),SUM(c1) FROM t1;
403 DROP TABLE t1,t2,t3;
404 CREATE TABLE t1(c1 INTEGER NOT NULL);
405 CREATE TABLE t2(c1 INTEGER NOT NULL);
406 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
407 CREATE TABLE t3(c1 INTEGER NOT NULL);
408 INSERT INTO t3 (c1) VALUES(5);
409 SELECT COUNT(c1),SUM(c1) FROM t1;
410 DELETE FROM t1 WHERE c1 = 5;
411 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
412 SELECT COUNT(c1),SUM(c1) FROM t1;
413 DROP TABLE t1,t2,t3;
414 CREATE TABLE t1(c1 BIGINT NOT NULL);
415 CREATE TABLE t2(c1 BIGINT NOT NULL);
416 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
417 CREATE TABLE t3(c1 BIGINT NOT NULL);
418 INSERT INTO t3 (c1) VALUES(5);
419 SELECT COUNT(c1),SUM(c1) FROM t1;
420 DELETE FROM t1 WHERE c1 = 5;
421 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5;
422 SELECT COUNT(c1),SUM(c1) FROM t1;
423 DROP TABLE t1,t2,t3;
424 CREATE TABLE t1(c1 TINYINT NOT NULL);
425 CREATE TABLE t2(c1 TINYINT NOT NULL);
426 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
427 CREATE TABLE t3(c1 TINYINT NOT NULL);
428 INSERT INTO t3 (c1) VALUES(5);
429 SELECT COUNT(c1),SUM(c1) FROM t2;
430 DELETE FROM t2 WHERE c1 = 5;
431 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
432 SELECT COUNT(c1),SUM(c1) FROM t2;
433 DROP TABLE t1,t2,t3;
434 CREATE TABLE t1(c1 SMALLINT NOT NULL);
435 CREATE TABLE t2(c1 SMALLINT NOT NULL);
436 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
437 CREATE TABLE t3(c1 SMALLINT NOT NULL);
438 INSERT INTO t3 (c1) VALUES(5);
439 SELECT COUNT(c1),SUM(c1) FROM t2;
440 DELETE FROM t2 WHERE c1 = 5;
441 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
442 SELECT COUNT(c1),SUM(c1) FROM t2;
443 DROP TABLE t1,t2,t3;
444 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
445 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
446 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
448 INSERT INTO t3 (c1) VALUES(5);
449 SELECT COUNT(c1),SUM(c1) FROM t2;
450 DELETE FROM t2 WHERE c1 = 5;
451 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
452 SELECT COUNT(c1),SUM(c1) FROM t2;
453 DROP TABLE t1,t2,t3;
454 CREATE TABLE t1(c1 INT NOT NULL);
455 CREATE TABLE t2(c1 INT NOT NULL);
456 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
457 CREATE TABLE t3(c1 INT NOT NULL);
458 INSERT INTO t3 (c1) VALUES(5);
459 SELECT COUNT(c1),SUM(c1) FROM t2;
460 DELETE FROM t2 WHERE c1 = 5;
461 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
462 SELECT COUNT(c1),SUM(c1) FROM t2;
463 DROP TABLE t1,t2,t3;
464 CREATE TABLE t1(c1 INTEGER NOT NULL);
465 CREATE TABLE t2(c1 INTEGER NOT NULL);
466 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
467 CREATE TABLE t3(c1 INTEGER NOT NULL);
468 INSERT INTO t3 (c1) VALUES(5);
469 SELECT COUNT(c1),SUM(c1) FROM t2;
470 DELETE FROM t2 WHERE c1 = 5;
471 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
472 SELECT COUNT(c1),SUM(c1) FROM t2;
473 DROP TABLE t1,t2,t3;
474 CREATE TABLE t1(c1 BIGINT NOT NULL);
475 CREATE TABLE t2(c1 BIGINT NOT NULL);
476 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
477 CREATE TABLE t3(c1 BIGINT NOT NULL);
478 INSERT INTO t3 (c1) VALUES(5);
479 SELECT COUNT(c1),SUM(c1) FROM t2;
480 DELETE FROM t2 WHERE c1 = 5;
481 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5;
482 SELECT COUNT(c1),SUM(c1) FROM t2;
483 DROP TABLE t1,t2,t3;
484 CREATE TABLE t1(c1 TINYINT NOT NULL);
485 CREATE TABLE t2(c1 TINYINT NOT NULL);
486 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
487 CREATE TABLE t3(c1 TINYINT NOT NULL);
488 INSERT INTO t3 (c1) VALUES(5);
489 SELECT COUNT(c1),SUM(c1) FROM t3;
490 DELETE FROM t3 WHERE c1 = 5;
491 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
492 SELECT COUNT(c1),SUM(c1) FROM t3;
493 DROP TABLE t1,t2,t3;
494 CREATE TABLE t1(c1 SMALLINT NOT NULL);
495 CREATE TABLE t2(c1 SMALLINT NOT NULL);
496 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
497 CREATE TABLE t3(c1 SMALLINT NOT NULL);
498 INSERT INTO t3 (c1) VALUES(5);
499 SELECT COUNT(c1),SUM(c1) FROM t3;
500 DELETE FROM t3 WHERE c1 = 5;
501 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
502 SELECT COUNT(c1),SUM(c1) FROM t3;
503 DROP TABLE t1,t2,t3;
504 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
505 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
506 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
507 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
508 INSERT INTO t3 (c1) VALUES(5);
509 SELECT COUNT(c1),SUM(c1) FROM t3;
510 DELETE FROM t3 WHERE c1 = 5;
511 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
512 SELECT COUNT(c1),SUM(c1) FROM t3;
513 DROP TABLE t1,t2,t3;
514 CREATE TABLE t1(c1 INT NOT NULL);
515 CREATE TABLE t2(c1 INT NOT NULL);
516 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
517 CREATE TABLE t3(c1 INT NOT NULL);
518 INSERT INTO t3 (c1) VALUES(5);
519 SELECT COUNT(c1),SUM(c1) FROM t3;
520 DELETE FROM t3 WHERE c1 = 5;
521 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
522 SELECT COUNT(c1),SUM(c1) FROM t3;
523 DROP TABLE t1,t2,t3;
524 CREATE TABLE t1(c1 INTEGER NOT NULL);
525 CREATE TABLE t2(c1 INTEGER NOT NULL);
526 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
527 CREATE TABLE t3(c1 INTEGER NOT NULL);
528 INSERT INTO t3 (c1) VALUES(5);
529 SELECT COUNT(c1),SUM(c1) FROM t3;
530 DELETE FROM t3 WHERE c1 = 5;
531 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
532 SELECT COUNT(c1),SUM(c1) FROM t3;
533 DROP TABLE t1,t2,t3;
534 CREATE TABLE t1(c1 BIGINT NOT NULL);
535 CREATE TABLE t2(c1 BIGINT NOT NULL);
536 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
537 CREATE TABLE t3(c1 BIGINT NOT NULL);
538 INSERT INTO t3 (c1) VALUES(5);
539 SELECT COUNT(c1),SUM(c1) FROM t3;
540 DELETE FROM t3 WHERE c1 = 5;
541 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5;
542 SELECT COUNT(c1),SUM(c1) FROM t3;
543 DROP TABLE t1,t2,t3;
544 CREATE TABLE t1(c1 TINYINT NOT NULL);
545 CREATE TABLE t2(c1 TINYINT NOT NULL);
546 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
547 CREATE TABLE t3(c1 TINYINT NOT NULL);
548 INSERT INTO t3 (c1) VALUES(5);
549 SELECT COUNT(c1),SUM(c1) FROM t1;
550 DELETE FROM t1 WHERE c1 >= 5;
551 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
552 SELECT COUNT(c1),SUM(c1) FROM t1;
553 DROP TABLE t1,t2,t3;
554 CREATE TABLE t1(c1 SMALLINT NOT NULL);
555 CREATE TABLE t2(c1 SMALLINT NOT NULL);
556 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
557 CREATE TABLE t3(c1 SMALLINT NOT NULL);
558 INSERT INTO t3 (c1) VALUES(5);
559 SELECT COUNT(c1),SUM(c1) FROM t1;
560 DELETE FROM t1 WHERE c1 >= 5;
561 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
562 SELECT COUNT(c1),SUM(c1) FROM t1;
563 DROP TABLE t1,t2,t3;
564 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
565 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
566 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
567 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
568 INSERT INTO t3 (c1) VALUES(5);
569 SELECT COUNT(c1),SUM(c1) FROM t1;
570 DELETE FROM t1 WHERE c1 >= 5;
571 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
572 SELECT COUNT(c1),SUM(c1) FROM t1;
573 DROP TABLE t1,t2,t3;
574 CREATE TABLE t1(c1 INT NOT NULL);
575 CREATE TABLE t2(c1 INT NOT NULL);
576 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
577 CREATE TABLE t3(c1 INT NOT NULL);
578 INSERT INTO t3 (c1) VALUES(5);
579 SELECT COUNT(c1),SUM(c1) FROM t1;
580 DELETE FROM t1 WHERE c1 >= 5;
581 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
582 SELECT COUNT(c1),SUM(c1) FROM t1;
583 DROP TABLE t1,t2,t3;
584 CREATE TABLE t1(c1 INTEGER NOT NULL);
585 CREATE TABLE t2(c1 INTEGER NOT NULL);
586 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
587 CREATE TABLE t3(c1 INTEGER NOT NULL);
588 INSERT INTO t3 (c1) VALUES(5);
589 SELECT COUNT(c1),SUM(c1) FROM t1;
590 DELETE FROM t1 WHERE c1 >= 5;
591 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
592 SELECT COUNT(c1),SUM(c1) FROM t1;
593 DROP TABLE t1,t2,t3;
594 CREATE TABLE t1(c1 BIGINT NOT NULL);
595 CREATE TABLE t2(c1 BIGINT NOT NULL);
596 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
597 CREATE TABLE t3(c1 BIGINT NOT NULL);
598 INSERT INTO t3 (c1) VALUES(5);
599 SELECT COUNT(c1),SUM(c1) FROM t1;
600 DELETE FROM t1 WHERE c1 >= 5;
601 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5;
602 SELECT COUNT(c1),SUM(c1) FROM t1;
603 DROP TABLE t1,t2,t3;
604 CREATE TABLE t1(c1 TINYINT NOT NULL);
605 CREATE TABLE t2(c1 TINYINT NOT NULL);
606 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
607 CREATE TABLE t3(c1 TINYINT NOT NULL);
608 INSERT INTO t3 (c1) VALUES(5);
609 SELECT COUNT(c1),SUM(c1) FROM t2;
610 DELETE FROM t2 WHERE c1 >= 5;
611 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
612 SELECT COUNT(c1),SUM(c1) FROM t2;
613 DROP TABLE t1,t2,t3;
614 CREATE TABLE t1(c1 SMALLINT NOT NULL);
615 CREATE TABLE t2(c1 SMALLINT NOT NULL);
616 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
617 CREATE TABLE t3(c1 SMALLINT NOT NULL);
618 INSERT INTO t3 (c1) VALUES(5);
619 SELECT COUNT(c1),SUM(c1) FROM t2;
620 DELETE FROM t2 WHERE c1 >= 5;
621 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
622 SELECT COUNT(c1),SUM(c1) FROM t2;
623 DROP TABLE t1,t2,t3;
624 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
625 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
626 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
627 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
628 INSERT INTO t3 (c1) VALUES(5);
629 SELECT COUNT(c1),SUM(c1) FROM t2;
630 DELETE FROM t2 WHERE c1 >= 5;
631 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
632 SELECT COUNT(c1),SUM(c1) FROM t2;
633 DROP TABLE t1,t2,t3;
634 CREATE TABLE t1(c1 INT NOT NULL);
635 CREATE TABLE t2(c1 INT NOT NULL);
636 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
637 CREATE TABLE t3(c1 INT NOT NULL);
638 INSERT INTO t3 (c1) VALUES(5);
639 SELECT COUNT(c1),SUM(c1) FROM t2;
640 DELETE FROM t2 WHERE c1 >= 5;
641 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
642 SELECT COUNT(c1),SUM(c1) FROM t2;
643 DROP TABLE t1,t2,t3;
644 CREATE TABLE t1(c1 INTEGER NOT NULL);
645 CREATE TABLE t2(c1 INTEGER NOT NULL);
646 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
647 CREATE TABLE t3(c1 INTEGER NOT NULL);
648 INSERT INTO t3 (c1) VALUES(5);
649 SELECT COUNT(c1),SUM(c1) FROM t2;
650 DELETE FROM t2 WHERE c1 >= 5;
651 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
652 SELECT COUNT(c1),SUM(c1) FROM t2;
653 DROP TABLE t1,t2,t3;
654 CREATE TABLE t1(c1 BIGINT NOT NULL);
655 CREATE TABLE t2(c1 BIGINT NOT NULL);
656 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
657 CREATE TABLE t3(c1 BIGINT NOT NULL);
658 INSERT INTO t3 (c1) VALUES(5);
659 SELECT COUNT(c1),SUM(c1) FROM t2;
660 DELETE FROM t2 WHERE c1 >= 5;
661 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5;
662 SELECT COUNT(c1),SUM(c1) FROM t2;
663 DROP TABLE t1,t2,t3;
664 CREATE TABLE t1(c1 TINYINT NOT NULL);
665 CREATE TABLE t2(c1 TINYINT NOT NULL);
666 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
667 CREATE TABLE t3(c1 TINYINT NOT NULL);
668 INSERT INTO t3 (c1) VALUES(5);
669 SELECT COUNT(c1),SUM(c1) FROM t3;
670 DELETE FROM t3 WHERE c1 >= 5;
671 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
672 SELECT COUNT(c1),SUM(c1) FROM t3;
673 DROP TABLE t1,t2,t3;
674 CREATE TABLE t1(c1 SMALLINT NOT NULL);
675 CREATE TABLE t2(c1 SMALLINT NOT NULL);
676 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
677 CREATE TABLE t3(c1 SMALLINT NOT NULL);
678 INSERT INTO t3 (c1) VALUES(5);
679 SELECT COUNT(c1),SUM(c1) FROM t3;
680 DELETE FROM t3 WHERE c1 >= 5;
681 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
682 SELECT COUNT(c1),SUM(c1) FROM t3;
683 DROP TABLE t1,t2,t3;
684 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
685 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
686 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
687 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
688 INSERT INTO t3 (c1) VALUES(5);
689 SELECT COUNT(c1),SUM(c1) FROM t3;
690 DELETE FROM t3 WHERE c1 >= 5;
691 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
692 SELECT COUNT(c1),SUM(c1) FROM t3;
693 DROP TABLE t1,t2,t3;
694 CREATE TABLE t1(c1 INT NOT NULL);
695 CREATE TABLE t2(c1 INT NOT NULL);
696 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
697 CREATE TABLE t3(c1 INT NOT NULL);
698 INSERT INTO t3 (c1) VALUES(5);
699 SELECT COUNT(c1),SUM(c1) FROM t3;
700 DELETE FROM t3 WHERE c1 >= 5;
701 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
702 SELECT COUNT(c1),SUM(c1) FROM t3;
703 DROP TABLE t1,t2,t3;
704 CREATE TABLE t1(c1 INTEGER NOT NULL);
705 CREATE TABLE t2(c1 INTEGER NOT NULL);
706 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
707 CREATE TABLE t3(c1 INTEGER NOT NULL);
708 INSERT INTO t3 (c1) VALUES(5);
709 SELECT COUNT(c1),SUM(c1) FROM t3;
710 DELETE FROM t3 WHERE c1 >= 5;
711 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
712 SELECT COUNT(c1),SUM(c1) FROM t3;
713 DROP TABLE t1,t2,t3;
714 CREATE TABLE t1(c1 BIGINT NOT NULL);
715 CREATE TABLE t2(c1 BIGINT NOT NULL);
716 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
717 CREATE TABLE t3(c1 BIGINT NOT NULL);
718 INSERT INTO t3 (c1) VALUES(5);
719 SELECT COUNT(c1),SUM(c1) FROM t3;
720 DELETE FROM t3 WHERE c1 >= 5;
721 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5;
722 SELECT COUNT(c1),SUM(c1) FROM t3;
723 DROP TABLE t1,t2,t3;
724 CREATE TABLE t1(c1 TINYINT NOT NULL);
725 CREATE TABLE t2(c1 TINYINT NOT NULL);
726 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
727 CREATE TABLE t3(c1 TINYINT NOT NULL);
728 INSERT INTO t3 (c1) VALUES(5);
729 SELECT COUNT(c1),SUM(c1) FROM t1;
730 DELETE FROM t1 WHERE c1 != 5;
731 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
732 SELECT COUNT(c1),SUM(c1) FROM t1;
733 DROP TABLE t1,t2,t3;
734 CREATE TABLE t1(c1 SMALLINT NOT NULL);
735 CREATE TABLE t2(c1 SMALLINT NOT NULL);
736 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
737 CREATE TABLE t3(c1 SMALLINT NOT NULL);
738 INSERT INTO t3 (c1) VALUES(5);
739 SELECT COUNT(c1),SUM(c1) FROM t1;
740 DELETE FROM t1 WHERE c1 != 5;
741 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
742 SELECT COUNT(c1),SUM(c1) FROM t1;
743 DROP TABLE t1,t2,t3;
744 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
745 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
746 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
747 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
748 INSERT INTO t3 (c1) VALUES(5);
749 SELECT COUNT(c1),SUM(c1) FROM t1;
750 DELETE FROM t1 WHERE c1 != 5;
751 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
752 SELECT COUNT(c1),SUM(c1) FROM t1;
753 DROP TABLE t1,t2,t3;
754 CREATE TABLE t1(c1 INT NOT NULL);
755 CREATE TABLE t2(c1 INT NOT NULL);
756 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
757 CREATE TABLE t3(c1 INT NOT NULL);
758 INSERT INTO t3 (c1) VALUES(5);
759 SELECT COUNT(c1),SUM(c1) FROM t1;
760 DELETE FROM t1 WHERE c1 != 5;
761 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
762 SELECT COUNT(c1),SUM(c1) FROM t1;
763 DROP TABLE t1,t2,t3;
764 CREATE TABLE t1(c1 INTEGER NOT NULL);
765 CREATE TABLE t2(c1 INTEGER NOT NULL);
766 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
767 CREATE TABLE t3(c1 INTEGER NOT NULL);
768 INSERT INTO t3 (c1) VALUES(5);
769 SELECT COUNT(c1),SUM(c1) FROM t1;
770 DELETE FROM t1 WHERE c1 != 5;
771 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
772 SELECT COUNT(c1),SUM(c1) FROM t1;
773 DROP TABLE t1,t2,t3;
774 CREATE TABLE t1(c1 BIGINT NOT NULL);
775 CREATE TABLE t2(c1 BIGINT NOT NULL);
776 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
777 CREATE TABLE t3(c1 BIGINT NOT NULL);
778 INSERT INTO t3 (c1) VALUES(5);
779 SELECT COUNT(c1),SUM(c1) FROM t1;
780 DELETE FROM t1 WHERE c1 != 5;
781 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5;
782 SELECT COUNT(c1),SUM(c1) FROM t1;
783 DROP TABLE t1,t2,t3;
784 CREATE TABLE t1(c1 TINYINT NOT NULL);
785 CREATE TABLE t2(c1 TINYINT NOT NULL);
786 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
787 CREATE TABLE t3(c1 TINYINT NOT NULL);
788 INSERT INTO t3 (c1) VALUES(5);
789 SELECT COUNT(c1),SUM(c1) FROM t2;
790 DELETE FROM t2 WHERE c1 != 5;
791 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
792 SELECT COUNT(c1),SUM(c1) FROM t2;
793 DROP TABLE t1,t2,t3;
794 CREATE TABLE t1(c1 SMALLINT NOT NULL);
795 CREATE TABLE t2(c1 SMALLINT NOT NULL);
796 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
797 CREATE TABLE t3(c1 SMALLINT NOT NULL);
798 INSERT INTO t3 (c1) VALUES(5);
799 SELECT COUNT(c1),SUM(c1) FROM t2;
800 DELETE FROM t2 WHERE c1 != 5;
801 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
802 SELECT COUNT(c1),SUM(c1) FROM t2;
803 DROP TABLE t1,t2,t3;
804 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
805 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
806 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
807 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
808 INSERT INTO t3 (c1) VALUES(5);
809 SELECT COUNT(c1),SUM(c1) FROM t2;
810 DELETE FROM t2 WHERE c1 != 5;
811 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
812 SELECT COUNT(c1),SUM(c1) FROM t2;
813 DROP TABLE t1,t2,t3;
814 CREATE TABLE t1(c1 INT NOT NULL);
815 CREATE TABLE t2(c1 INT NOT NULL);
816 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
817 CREATE TABLE t3(c1 INT NOT NULL);
818 INSERT INTO t3 (c1) VALUES(5);
819 SELECT COUNT(c1),SUM(c1) FROM t2;
820 DELETE FROM t2 WHERE c1 != 5;
821 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
822 SELECT COUNT(c1),SUM(c1) FROM t2;
823 DROP TABLE t1,t2,t3;
824 CREATE TABLE t1(c1 INTEGER NOT NULL);
825 CREATE TABLE t2(c1 INTEGER NOT NULL);
826 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
827 CREATE TABLE t3(c1 INTEGER NOT NULL);
828 INSERT INTO t3 (c1) VALUES(5);
829 SELECT COUNT(c1),SUM(c1) FROM t2;
830 DELETE FROM t2 WHERE c1 != 5;
831 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
832 SELECT COUNT(c1),SUM(c1) FROM t2;
833 DROP TABLE t1,t2,t3;
834 CREATE TABLE t1(c1 BIGINT NOT NULL);
835 CREATE TABLE t2(c1 BIGINT NOT NULL);
836 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
837 CREATE TABLE t3(c1 BIGINT NOT NULL);
838 INSERT INTO t3 (c1) VALUES(5);
839 SELECT COUNT(c1),SUM(c1) FROM t2;
840 DELETE FROM t2 WHERE c1 != 5;
841 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5;
842 SELECT COUNT(c1),SUM(c1) FROM t2;
843 DROP TABLE t1,t2,t3;
844 CREATE TABLE t1(c1 TINYINT NOT NULL);
845 CREATE TABLE t2(c1 TINYINT NOT NULL);
846 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
847 CREATE TABLE t3(c1 TINYINT NOT NULL);
848 INSERT INTO t3 (c1) VALUES(5);
849 SELECT COUNT(c1),SUM(c1) FROM t3;
850 DELETE FROM t3 WHERE c1 != 5;
851 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
852 SELECT COUNT(c1),SUM(c1) FROM t3;
853 DROP TABLE t1,t2,t3;
854 CREATE TABLE t1(c1 SMALLINT NOT NULL);
855 CREATE TABLE t2(c1 SMALLINT NOT NULL);
856 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
857 CREATE TABLE t3(c1 SMALLINT NOT NULL);
858 INSERT INTO t3 (c1) VALUES(5);
859 SELECT COUNT(c1),SUM(c1) FROM t3;
860 DELETE FROM t3 WHERE c1 != 5;
861 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
862 SELECT COUNT(c1),SUM(c1) FROM t3;
863 DROP TABLE t1,t2,t3;
864 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
865 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
866 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
867 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
868 INSERT INTO t3 (c1) VALUES(5);
869 SELECT COUNT(c1),SUM(c1) FROM t3;
870 DELETE FROM t3 WHERE c1 != 5;
871 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
872 SELECT COUNT(c1),SUM(c1) FROM t3;
873 DROP TABLE t1,t2,t3;
874 CREATE TABLE t1(c1 INT NOT NULL);
875 CREATE TABLE t2(c1 INT NOT NULL);
876 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
877 CREATE TABLE t3(c1 INT NOT NULL);
878 INSERT INTO t3 (c1) VALUES(5);
879 SELECT COUNT(c1),SUM(c1) FROM t3;
880 DELETE FROM t3 WHERE c1 != 5;
881 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
882 SELECT COUNT(c1),SUM(c1) FROM t3;
883 DROP TABLE t1,t2,t3;
884 CREATE TABLE t1(c1 INTEGER NOT NULL);
885 CREATE TABLE t2(c1 INTEGER NOT NULL);
886 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
887 CREATE TABLE t3(c1 INTEGER NOT NULL);
888 INSERT INTO t3 (c1) VALUES(5);
889 SELECT COUNT(c1),SUM(c1) FROM t3;
890 DELETE FROM t3 WHERE c1 != 5;
891 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
892 SELECT COUNT(c1),SUM(c1) FROM t3;
893 DROP TABLE t1,t2,t3;
894 CREATE TABLE t1(c1 BIGINT NOT NULL);
895 CREATE TABLE t2(c1 BIGINT NOT NULL);
896 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
897 CREATE TABLE t3(c1 BIGINT NOT NULL);
898 INSERT INTO t3 (c1) VALUES(5);
899 SELECT COUNT(c1),SUM(c1) FROM t3;
900 DELETE FROM t3 WHERE c1 != 5;
901 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5;
902 SELECT COUNT(c1),SUM(c1) FROM t3;
903 DROP TABLE t1,t2,t3;
904 CREATE TABLE t1(c1 TINYINT NOT NULL);
905 CREATE TABLE t2(c1 TINYINT NOT NULL);
906 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
907 CREATE TABLE t3(c1 TINYINT NOT NULL);
908 INSERT INTO t3 (c1) VALUES(5);
909 SELECT COUNT(c1),SUM(c1) FROM t1;
910 DELETE FROM t1 WHERE c1 <> 5;
911 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
912 SELECT COUNT(c1),SUM(c1) FROM t1;
913 DROP TABLE t1,t2,t3;
914 CREATE TABLE t1(c1 SMALLINT NOT NULL);
915 CREATE TABLE t2(c1 SMALLINT NOT NULL);
916 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
917 CREATE TABLE t3(c1 SMALLINT NOT NULL);
918 INSERT INTO t3 (c1) VALUES(5);
919 SELECT COUNT(c1),SUM(c1) FROM t1;
920 DELETE FROM t1 WHERE c1 <> 5;
921 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
922 SELECT COUNT(c1),SUM(c1) FROM t1;
923 DROP TABLE t1,t2,t3;
924 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
925 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
926 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
927 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
928 INSERT INTO t3 (c1) VALUES(5);
929 SELECT COUNT(c1),SUM(c1) FROM t1;
930 DELETE FROM t1 WHERE c1 <> 5;
931 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
932 SELECT COUNT(c1),SUM(c1) FROM t1;
933 DROP TABLE t1,t2,t3;
934 CREATE TABLE t1(c1 INT NOT NULL);
935 CREATE TABLE t2(c1 INT NOT NULL);
936 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
937 CREATE TABLE t3(c1 INT NOT NULL);
938 INSERT INTO t3 (c1) VALUES(5);
939 SELECT COUNT(c1),SUM(c1) FROM t1;
940 DELETE FROM t1 WHERE c1 <> 5;
941 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
942 SELECT COUNT(c1),SUM(c1) FROM t1;
943 DROP TABLE t1,t2,t3;
944 CREATE TABLE t1(c1 INTEGER NOT NULL);
945 CREATE TABLE t2(c1 INTEGER NOT NULL);
946 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
947 CREATE TABLE t3(c1 INTEGER NOT NULL);
948 INSERT INTO t3 (c1) VALUES(5);
949 SELECT COUNT(c1),SUM(c1) FROM t1;
950 DELETE FROM t1 WHERE c1 <> 5;
951 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
952 SELECT COUNT(c1),SUM(c1) FROM t1;
953 DROP TABLE t1,t2,t3;
954 CREATE TABLE t1(c1 BIGINT NOT NULL);
955 CREATE TABLE t2(c1 BIGINT NOT NULL);
956 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
957 CREATE TABLE t3(c1 BIGINT NOT NULL);
958 INSERT INTO t3 (c1) VALUES(5);
959 SELECT COUNT(c1),SUM(c1) FROM t1;
960 DELETE FROM t1 WHERE c1 <> 5;
961 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5;
962 SELECT COUNT(c1),SUM(c1) FROM t1;
963 DROP TABLE t1,t2,t3;
964 CREATE TABLE t1(c1 TINYINT NOT NULL);
965 CREATE TABLE t2(c1 TINYINT NOT NULL);
966 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
967 CREATE TABLE t3(c1 TINYINT NOT NULL);
968 INSERT INTO t3 (c1) VALUES(5);
969 SELECT COUNT(c1),SUM(c1) FROM t2;
970 DELETE FROM t2 WHERE c1 <> 5;
971 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
972 SELECT COUNT(c1),SUM(c1) FROM t2;
973 DROP TABLE t1,t2,t3;
974 CREATE TABLE t1(c1 SMALLINT NOT NULL);
975 CREATE TABLE t2(c1 SMALLINT NOT NULL);
976 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
977 CREATE TABLE t3(c1 SMALLINT NOT NULL);
978 INSERT INTO t3 (c1) VALUES(5);
979 SELECT COUNT(c1),SUM(c1) FROM t2;
980 DELETE FROM t2 WHERE c1 <> 5;
981 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
982 SELECT COUNT(c1),SUM(c1) FROM t2;
983 DROP TABLE t1,t2,t3;
984 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
985 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
986 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
987 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
988 INSERT INTO t3 (c1) VALUES(5);
989 SELECT COUNT(c1),SUM(c1) FROM t2;
990 DELETE FROM t2 WHERE c1 <> 5;
991 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
992 SELECT COUNT(c1),SUM(c1) FROM t2;
993 DROP TABLE t1,t2,t3;
994 CREATE TABLE t1(c1 INT NOT NULL);
995 CREATE TABLE t2(c1 INT NOT NULL);
996 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
997 CREATE TABLE t3(c1 INT NOT NULL);
998 INSERT INTO t3 (c1) VALUES(5);
999 SELECT COUNT(c1),SUM(c1) FROM t2;
1000 DELETE FROM t2 WHERE c1 <> 5;
1001 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1002 SELECT COUNT(c1),SUM(c1) FROM t2;
1003 DROP TABLE t1,t2,t3;
1004 CREATE TABLE t1(c1 INTEGER NOT NULL);
1005 CREATE TABLE t2(c1 INTEGER NOT NULL);
1006 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1007 CREATE TABLE t3(c1 INTEGER NOT NULL);
1008 INSERT INTO t3 (c1) VALUES(5);
1009 SELECT COUNT(c1),SUM(c1) FROM t2;
1010 DELETE FROM t2 WHERE c1 <> 5;
1011 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1012 SELECT COUNT(c1),SUM(c1) FROM t2;
1013 DROP TABLE t1,t2,t3;
1014 CREATE TABLE t1(c1 BIGINT NOT NULL);
1015 CREATE TABLE t2(c1 BIGINT NOT NULL);
1016 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1017 CREATE TABLE t3(c1 BIGINT NOT NULL);
1018 INSERT INTO t3 (c1) VALUES(5);
1019 SELECT COUNT(c1),SUM(c1) FROM t2;
1020 DELETE FROM t2 WHERE c1 <> 5;
1021 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5;
1022 SELECT COUNT(c1),SUM(c1) FROM t2;
1023 DROP TABLE t1,t2,t3;
1024 CREATE TABLE t1(c1 TINYINT NOT NULL);
1025 CREATE TABLE t2(c1 TINYINT NOT NULL);
1026 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1027 CREATE TABLE t3(c1 TINYINT NOT NULL);
1028 INSERT INTO t3 (c1) VALUES(5);
1029 SELECT COUNT(c1),SUM(c1) FROM t3;
1030 DELETE FROM t3 WHERE c1 <> 5;
1031 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1032 SELECT COUNT(c1),SUM(c1) FROM t3;
1033 DROP TABLE t1,t2,t3;
1034 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1035 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1036 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1037 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1038 INSERT INTO t3 (c1) VALUES(5);
1039 SELECT COUNT(c1),SUM(c1) FROM t3;
1040 DELETE FROM t3 WHERE c1 <> 5;
1041 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1042 SELECT COUNT(c1),SUM(c1) FROM t3;
1043 DROP TABLE t1,t2,t3;
1044 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1045 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1046 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1047 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1048 INSERT INTO t3 (c1) VALUES(5);
1049 SELECT COUNT(c1),SUM(c1) FROM t3;
1050 DELETE FROM t3 WHERE c1 <> 5;
1051 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1052 SELECT COUNT(c1),SUM(c1) FROM t3;
1053 DROP TABLE t1,t2,t3;
1054 CREATE TABLE t1(c1 INT NOT NULL);
1055 CREATE TABLE t2(c1 INT NOT NULL);
1056 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1057 CREATE TABLE t3(c1 INT NOT NULL);
1058 INSERT INTO t3 (c1) VALUES(5);
1059 SELECT COUNT(c1),SUM(c1) FROM t3;
1060 DELETE FROM t3 WHERE c1 <> 5;
1061 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1062 SELECT COUNT(c1),SUM(c1) FROM t3;
1063 DROP TABLE t1,t2,t3;
1064 CREATE TABLE t1(c1 INTEGER NOT NULL);
1065 CREATE TABLE t2(c1 INTEGER NOT NULL);
1066 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1067 CREATE TABLE t3(c1 INTEGER NOT NULL);
1068 INSERT INTO t3 (c1) VALUES(5);
1069 SELECT COUNT(c1),SUM(c1) FROM t3;
1070 DELETE FROM t3 WHERE c1 <> 5;
1071 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1072 SELECT COUNT(c1),SUM(c1) FROM t3;
1073 DROP TABLE t1,t2,t3;
1074 CREATE TABLE t1(c1 BIGINT NOT NULL);
1075 CREATE TABLE t2(c1 BIGINT NOT NULL);
1076 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1077 CREATE TABLE t3(c1 BIGINT NOT NULL);
1078 INSERT INTO t3 (c1) VALUES(5);
1079 SELECT COUNT(c1),SUM(c1) FROM t3;
1080 DELETE FROM t3 WHERE c1 <> 5;
1081 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5;
1082 SELECT COUNT(c1),SUM(c1) FROM t3;
1083 DROP TABLE t1,t2,t3;
1084 CREATE TABLE t1(c1 TINYINT NOT NULL);
1085 CREATE TABLE t2(c1 TINYINT NOT NULL);
1086 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1087 CREATE TABLE t3(c1 TINYINT NOT NULL);
1088 INSERT INTO t3 (c1) VALUES(5);
1089 SELECT COUNT(c1),SUM(c1) FROM t1;
1090 DELETE FROM t1 WHERE c1 <=> 5;
1091 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1092 SELECT COUNT(c1),SUM(c1) FROM t1;
1093 DROP TABLE t1,t2,t3;
1094 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1095 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1096 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1097 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1098 INSERT INTO t3 (c1) VALUES(5);
1099 SELECT COUNT(c1),SUM(c1) FROM t1;
1100 DELETE FROM t1 WHERE c1 <=> 5;
1101 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1102 SELECT COUNT(c1),SUM(c1) FROM t1;
1103 DROP TABLE t1,t2,t3;
1104 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1105 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1106 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1107 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1108 INSERT INTO t3 (c1) VALUES(5);
1109 SELECT COUNT(c1),SUM(c1) FROM t1;
1110 DELETE FROM t1 WHERE c1 <=> 5;
1111 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1112 SELECT COUNT(c1),SUM(c1) FROM t1;
1113 DROP TABLE t1,t2,t3;
1114 CREATE TABLE t1(c1 INT NOT NULL);
1115 CREATE TABLE t2(c1 INT NOT NULL);
1116 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1117 CREATE TABLE t3(c1 INT NOT NULL);
1118 INSERT INTO t3 (c1) VALUES(5);
1119 SELECT COUNT(c1),SUM(c1) FROM t1;
1120 DELETE FROM t1 WHERE c1 <=> 5;
1121 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1122 SELECT COUNT(c1),SUM(c1) FROM t1;
1123 DROP TABLE t1,t2,t3;
1124 CREATE TABLE t1(c1 INTEGER NOT NULL);
1125 CREATE TABLE t2(c1 INTEGER NOT NULL);
1126 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1127 CREATE TABLE t3(c1 INTEGER NOT NULL);
1128 INSERT INTO t3 (c1) VALUES(5);
1129 SELECT COUNT(c1),SUM(c1) FROM t1;
1130 DELETE FROM t1 WHERE c1 <=> 5;
1131 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1132 SELECT COUNT(c1),SUM(c1) FROM t1;
1133 DROP TABLE t1,t2,t3;
1134 CREATE TABLE t1(c1 BIGINT NOT NULL);
1135 CREATE TABLE t2(c1 BIGINT NOT NULL);
1136 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1137 CREATE TABLE t3(c1 BIGINT NOT NULL);
1138 INSERT INTO t3 (c1) VALUES(5);
1139 SELECT COUNT(c1),SUM(c1) FROM t1;
1140 DELETE FROM t1 WHERE c1 <=> 5;
1141 SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5;
1142 SELECT COUNT(c1),SUM(c1) FROM t1;
1143 DROP TABLE t1,t2,t3;
1144 CREATE TABLE t1(c1 TINYINT NOT NULL);
1145 CREATE TABLE t2(c1 TINYINT NOT NULL);
1146 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1147 CREATE TABLE t3(c1 TINYINT NOT NULL);
1148 INSERT INTO t3 (c1) VALUES(5);
1149 SELECT COUNT(c1),SUM(c1) FROM t2;
1150 DELETE FROM t2 WHERE c1 <=> 5;
1151 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1152 SELECT COUNT(c1),SUM(c1) FROM t2;
1153 DROP TABLE t1,t2,t3;
1154 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1155 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1156 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1157 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1158 INSERT INTO t3 (c1) VALUES(5);
1159 SELECT COUNT(c1),SUM(c1) FROM t2;
1160 DELETE FROM t2 WHERE c1 <=> 5;
1161 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1162 SELECT COUNT(c1),SUM(c1) FROM t2;
1163 DROP TABLE t1,t2,t3;
1164 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1165 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1166 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1167 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1168 INSERT INTO t3 (c1) VALUES(5);
1169 SELECT COUNT(c1),SUM(c1) FROM t2;
1170 DELETE FROM t2 WHERE c1 <=> 5;
1171 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1172 SELECT COUNT(c1),SUM(c1) FROM t2;
1173 DROP TABLE t1,t2,t3;
1174 CREATE TABLE t1(c1 INT NOT NULL);
1175 CREATE TABLE t2(c1 INT NOT NULL);
1176 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1177 CREATE TABLE t3(c1 INT NOT NULL);
1178 INSERT INTO t3 (c1) VALUES(5);
1179 SELECT COUNT(c1),SUM(c1) FROM t2;
1180 DELETE FROM t2 WHERE c1 <=> 5;
1181 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1182 SELECT COUNT(c1),SUM(c1) FROM t2;
1183 DROP TABLE t1,t2,t3;
1184 CREATE TABLE t1(c1 INTEGER NOT NULL);
1185 CREATE TABLE t2(c1 INTEGER NOT NULL);
1186 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1187 CREATE TABLE t3(c1 INTEGER NOT NULL);
1188 INSERT INTO t3 (c1) VALUES(5);
1189 SELECT COUNT(c1),SUM(c1) FROM t2;
1190 DELETE FROM t2 WHERE c1 <=> 5;
1191 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1192 SELECT COUNT(c1),SUM(c1) FROM t2;
1193 DROP TABLE t1,t2,t3;
1194 CREATE TABLE t1(c1 BIGINT NOT NULL);
1195 CREATE TABLE t2(c1 BIGINT NOT NULL);
1196 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1197 CREATE TABLE t3(c1 BIGINT NOT NULL);
1198 INSERT INTO t3 (c1) VALUES(5);
1199 SELECT COUNT(c1),SUM(c1) FROM t2;
1200 DELETE FROM t2 WHERE c1 <=> 5;
1201 SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5;
1202 SELECT COUNT(c1),SUM(c1) FROM t2;
1203 DROP TABLE t1,t2,t3;
1204 CREATE TABLE t1(c1 TINYINT NOT NULL);
1205 CREATE TABLE t2(c1 TINYINT NOT NULL);
1206 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1207 CREATE TABLE t3(c1 TINYINT NOT NULL);
1208 INSERT INTO t3 (c1) VALUES(5);
1209 SELECT COUNT(c1),SUM(c1) FROM t3;
1210 DELETE FROM t3 WHERE c1 <=> 5;
1211 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1212 SELECT COUNT(c1),SUM(c1) FROM t3;
1213 DROP TABLE t1,t2,t3;
1214 CREATE TABLE t1(c1 SMALLINT NOT NULL);
1215 CREATE TABLE t2(c1 SMALLINT NOT NULL);
1216 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1217 CREATE TABLE t3(c1 SMALLINT NOT NULL);
1218 INSERT INTO t3 (c1) VALUES(5);
1219 SELECT COUNT(c1),SUM(c1) FROM t3;
1220 DELETE FROM t3 WHERE c1 <=> 5;
1221 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1222 SELECT COUNT(c1),SUM(c1) FROM t3;
1223 DROP TABLE t1,t2,t3;
1224 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
1225 CREATE TABLE t2(c1 MEDIUMINT NOT NULL);
1226 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1227 CREATE TABLE t3(c1 MEDIUMINT NOT NULL);
1228 INSERT INTO t3 (c1) VALUES(5);
1229 SELECT COUNT(c1),SUM(c1) FROM t3;
1230 DELETE FROM t3 WHERE c1 <=> 5;
1231 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1232 SELECT COUNT(c1),SUM(c1) FROM t3;
1233 DROP TABLE t1,t2,t3;
1234 CREATE TABLE t1(c1 INT NOT NULL);
1235 CREATE TABLE t2(c1 INT NOT NULL);
1236 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1237 CREATE TABLE t3(c1 INT NOT NULL);
1238 INSERT INTO t3 (c1) VALUES(5);
1239 SELECT COUNT(c1),SUM(c1) FROM t3;
1240 DELETE FROM t3 WHERE c1 <=> 5;
1241 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1242 SELECT COUNT(c1),SUM(c1) FROM t3;
1243 DROP TABLE t1,t2,t3;
1244 CREATE TABLE t1(c1 INTEGER NOT NULL);
1245 CREATE TABLE t2(c1 INTEGER NOT NULL);
1246 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1247 CREATE TABLE t3(c1 INTEGER NOT NULL);
1248 INSERT INTO t3 (c1) VALUES(5);
1249 SELECT COUNT(c1),SUM(c1) FROM t3;
1250 DELETE FROM t3 WHERE c1 <=> 5;
1251 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1252 SELECT COUNT(c1),SUM(c1) FROM t3;
1253 DROP TABLE t1,t2,t3;
1254 CREATE TABLE t1(c1 BIGINT NOT NULL);
1255 CREATE TABLE t2(c1 BIGINT NOT NULL);
1256 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1257 CREATE TABLE t3(c1 BIGINT NOT NULL);
1258 INSERT INTO t3 (c1) VALUES(5);
1259 SELECT COUNT(c1),SUM(c1) FROM t3;
1260 DELETE FROM t3 WHERE c1 <=> 5;
1261 SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5;
1262 SELECT COUNT(c1),SUM(c1) FROM t3;
1263 DROP TABLE t1,t2,t3;
1264