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