2
DROP TABLE IF EXISTS t6;
4
CREATE TABLE t6(c1 TINYINT UNSIGNED NULL);
5
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
7
EXECUTE stmt6 USING @a;
9
EXECUTE stmt6 USING @a;
11
EXECUTE stmt6 USING @a;
15
SELECT COUNT(c1) AS total_rows FROM t6;
17
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
19
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
21
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
22
DEALLOCATE PREPARE stmt6;
24
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
26
EXECUTE stmt6 USING @a;
28
EXECUTE stmt6 USING @a;
30
EXECUTE stmt6 USING @a;
31
DEALLOCATE PREPARE stmt6;
32
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
35
EXECUTE stmt6 USING @a,@b;
38
EXECUTE stmt6 USING @a,@b;
41
EXECUTE stmt6 USING @a,@b;
45
SELECT COUNT(c1) AS total_rows FROM t6;
47
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
49
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
51
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
52
DEALLOCATE PREPARE stmt6;
53
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
55
EXECUTE stmt6 USING @a;
57
EXECUTE stmt6 USING @a;
59
EXECUTE stmt6 USING @a;
63
SELECT COUNT(c1) AS total_rows FROM t6;
65
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
67
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
69
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
70
DEALLOCATE PREPARE stmt6;
72
CREATE TABLE t6(c1 SMALLINT UNSIGNED NULL);
73
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
75
EXECUTE stmt6 USING @a;
77
EXECUTE stmt6 USING @a;
79
EXECUTE stmt6 USING @a;
83
SELECT COUNT(c1) AS total_rows FROM t6;
85
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
87
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
89
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
90
DEALLOCATE PREPARE stmt6;
92
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
94
EXECUTE stmt6 USING @a;
96
EXECUTE stmt6 USING @a;
98
EXECUTE stmt6 USING @a;
99
DEALLOCATE PREPARE stmt6;
100
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
103
EXECUTE stmt6 USING @a,@b;
106
EXECUTE stmt6 USING @a,@b;
109
EXECUTE stmt6 USING @a,@b;
113
SELECT COUNT(c1) AS total_rows FROM t6;
115
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
117
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
119
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
120
DEALLOCATE PREPARE stmt6;
121
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
123
EXECUTE stmt6 USING @a;
125
EXECUTE stmt6 USING @a;
127
EXECUTE stmt6 USING @a;
131
SELECT COUNT(c1) AS total_rows FROM t6;
133
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
135
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
137
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
138
DEALLOCATE PREPARE stmt6;
140
CREATE TABLE t6(c1 MEDIUMINT UNSIGNED NULL);
141
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
143
EXECUTE stmt6 USING @a;
145
EXECUTE stmt6 USING @a;
147
EXECUTE stmt6 USING @a;
151
SELECT COUNT(c1) AS total_rows FROM t6;
153
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
155
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
157
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
158
DEALLOCATE PREPARE stmt6;
160
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
162
EXECUTE stmt6 USING @a;
164
EXECUTE stmt6 USING @a;
166
EXECUTE stmt6 USING @a;
167
DEALLOCATE PREPARE stmt6;
168
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
171
EXECUTE stmt6 USING @a,@b;
174
EXECUTE stmt6 USING @a,@b;
177
EXECUTE stmt6 USING @a,@b;
181
SELECT COUNT(c1) AS total_rows FROM t6;
183
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
185
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
187
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
188
DEALLOCATE PREPARE stmt6;
189
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
191
EXECUTE stmt6 USING @a;
193
EXECUTE stmt6 USING @a;
195
EXECUTE stmt6 USING @a;
199
SELECT COUNT(c1) AS total_rows FROM t6;
201
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
203
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
205
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
206
DEALLOCATE PREPARE stmt6;
208
CREATE TABLE t6(c1 INT UNSIGNED NULL);
209
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
211
EXECUTE stmt6 USING @a;
213
EXECUTE stmt6 USING @a;
215
EXECUTE stmt6 USING @a;
219
SELECT COUNT(c1) AS total_rows FROM t6;
221
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
223
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
225
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
226
DEALLOCATE PREPARE stmt6;
228
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
230
EXECUTE stmt6 USING @a;
232
EXECUTE stmt6 USING @a;
234
EXECUTE stmt6 USING @a;
235
DEALLOCATE PREPARE stmt6;
236
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
239
EXECUTE stmt6 USING @a,@b;
242
EXECUTE stmt6 USING @a,@b;
245
EXECUTE stmt6 USING @a,@b;
249
SELECT COUNT(c1) AS total_rows FROM t6;
251
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
253
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
255
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
256
DEALLOCATE PREPARE stmt6;
257
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
259
EXECUTE stmt6 USING @a;
261
EXECUTE stmt6 USING @a;
263
EXECUTE stmt6 USING @a;
267
SELECT COUNT(c1) AS total_rows FROM t6;
269
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
271
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
273
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
274
DEALLOCATE PREPARE stmt6;
276
CREATE TABLE t6(c1 INTEGER UNSIGNED NULL);
277
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
279
EXECUTE stmt6 USING @a;
281
EXECUTE stmt6 USING @a;
283
EXECUTE stmt6 USING @a;
287
SELECT COUNT(c1) AS total_rows FROM t6;
289
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
291
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
293
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
294
DEALLOCATE PREPARE stmt6;
296
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
298
EXECUTE stmt6 USING @a;
300
EXECUTE stmt6 USING @a;
302
EXECUTE stmt6 USING @a;
303
DEALLOCATE PREPARE stmt6;
304
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
307
EXECUTE stmt6 USING @a,@b;
310
EXECUTE stmt6 USING @a,@b;
313
EXECUTE stmt6 USING @a,@b;
317
SELECT COUNT(c1) AS total_rows FROM t6;
319
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
321
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
323
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
324
DEALLOCATE PREPARE stmt6;
325
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
327
EXECUTE stmt6 USING @a;
329
EXECUTE stmt6 USING @a;
331
EXECUTE stmt6 USING @a;
335
SELECT COUNT(c1) AS total_rows FROM t6;
337
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
339
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
341
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
342
DEALLOCATE PREPARE stmt6;
344
CREATE TABLE t6(c1 BIGINT UNSIGNED NULL);
345
PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
347
EXECUTE stmt6 USING @a;
349
EXECUTE stmt6 USING @a;
351
EXECUTE stmt6 USING @a;
355
SELECT COUNT(c1) AS total_rows FROM t6;
357
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
359
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
361
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
362
DEALLOCATE PREPARE stmt6;
364
PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
366
EXECUTE stmt6 USING @a;
368
EXECUTE stmt6 USING @a;
370
EXECUTE stmt6 USING @a;
371
DEALLOCATE PREPARE stmt6;
372
PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
375
EXECUTE stmt6 USING @a,@b;
378
EXECUTE stmt6 USING @a,@b;
381
EXECUTE stmt6 USING @a,@b;
385
SELECT COUNT(c1) AS total_rows FROM t6;
387
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
389
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
391
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
392
DEALLOCATE PREPARE stmt6;
393
PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
395
EXECUTE stmt6 USING @a;
397
EXECUTE stmt6 USING @a;
399
EXECUTE stmt6 USING @a;
403
SELECT COUNT(c1) AS total_rows FROM t6;
405
SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
407
SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
409
SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
410
DEALLOCATE PREPARE stmt6;