Debian Codegraph @

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

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