Debian Codegraph @

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