Debian Codegraph @

mysql-test/suite/engines/funcs/t/re_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 PRIMARY KEY);
5 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
6 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
7 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
16 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
17 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
18 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
27 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
28 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
29 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
38 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
39 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
40 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
49 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
50 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
51 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
60 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
61 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
62 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
71 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
72 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
73 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
82 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
83 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
84 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
93 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
94 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
95 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
104 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
105 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
106 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
115 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
116 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
117 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
126 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
127 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
128 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
137 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
138 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
139 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
148 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
149 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
150 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
159 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
160 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
161 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
170 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
171 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
172 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
181 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
182 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
183 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
192 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
193 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
194 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
203 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
204 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
205 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
214 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
215 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
216 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
225 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
226 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
227 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
236 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
237 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
238 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
247 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
248 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
249 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
258 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
259 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
260 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
269 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
270 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
271 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
280 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
281 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
282 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
291 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
292 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
293 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
302 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
303 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
304 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
313 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
314 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
315 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
324 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
325 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
326 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
335 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
336 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
337 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
346 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
347 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
348 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
357 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
358 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
359 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
368 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
369 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
370 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
379 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
380 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
381 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
390 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
391 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
392 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
401 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
402 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
403 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
412 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
413 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
414 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
423 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
424 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
425 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
434 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
435 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
436 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
445 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
446 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
447 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
456 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
457 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
458 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
467 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
468 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
469 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
478 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
479 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
480 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
489 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
490 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
491 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
500 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
501 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
502 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
511 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
512 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
513 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
522 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
523 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
524 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
533 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
534 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
535 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
544 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
545 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
546 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
555 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
556 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
557 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
566 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
567 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
568 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
577 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
578 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
579 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
588 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
589 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
590 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
599 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
600 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
601 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
610 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
611 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
612 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
621 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
622 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
623 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
632 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
633 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
634 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
643 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
644 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
645 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
654 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
655 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
656 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
665 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
666 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
667 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
676 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
677 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
678 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
687 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
688 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
689 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
698 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
699 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
700 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
709 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
710 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
711 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
720 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
721 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
722 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
731 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
732 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
733 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
742 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
743 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
744 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
753 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
754 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
755 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
764 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
765 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
766 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
775 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
776 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
777 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
786 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
787 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
788 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
797 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
798 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
799 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
808 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
809 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
810 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
819 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
820 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
821 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
830 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
831 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
832 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
841 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
842 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
843 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
852 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
853 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
854 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
863 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
864 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
865 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
874 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
875 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
876 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
885 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
886 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
887 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
896 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
897 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
898 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
907 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
908 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
909 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
918 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
919 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
920 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
929 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
930 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
931 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
940 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
941 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
942 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
951 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
952 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
953 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
962 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
963 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
964 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
973 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
974 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
975 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
984 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
985 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
986 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
995 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
996 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
997 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1006 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1007 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1008 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1017 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1018 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1019 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1028 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1029 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1030 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1039 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1040 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1041 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1050 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1051 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1052 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1061 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1062 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1063 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1072 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1073 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1074 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1083 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1084 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1085 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1094 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1095 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1096 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1105 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1106 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1107 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1116 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1117 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1118 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1127 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1128 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1129 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1138 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1139 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1140 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1149 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1150 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1151 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1160 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1161 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1162 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1171 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1172 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1173 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1182 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1183 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1184 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1193 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1194 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1195 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1204 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1205 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1206 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1215 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1216 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1217 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1226 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1227 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1228 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1237 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1238 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1239 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1248 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1249 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1250 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t1 VALUES (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 PRIMARY KEY);
1259 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1260 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1261 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1270 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1271 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1272 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1281 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1282 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1283 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1292 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1293 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1294 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1303 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1304 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1305 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1314 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1315 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1316 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t2 VALUES (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 PRIMARY KEY);
1325 CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY);
1326 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1327 CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1336 CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY);
1337 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1338 CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1347 CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY);
1348 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1349 CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1358 CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY);
1359 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1360 CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1369 CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY);
1370 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1371 CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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 PRIMARY KEY);
1380 CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY);
1381 INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
1382 CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY);
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 REPLACE t3 VALUES (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