Debian Codegraph @

mysql-test/suite/engines/funcs/r/ps_number_null.result

raw
1 DROP TABLE IF EXISTS t6;
2 CREATE TABLE t6(c1 TINYINT UNSIGNED NULL);
3 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
4 SET @a=NULL;
5 EXECUTE stmt6 USING @a;
6 SET @a=0;
7 EXECUTE stmt6 USING @a;
8 SET @a=255;
9 EXECUTE stmt6 USING @a;
10 SELECT * FROM t6;
11 c1
12 0
13 255
14 NULL
15 SELECT COUNT(c1) AS total_rows FROM t6;
16 total_rows
17 2
18 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
19 positive_rows
20 1
21 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
22 null_rows
23 0
24 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
25 not_null_rows
26 2
27 DEALLOCATE PREPARE stmt6;
28 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
29 SET @a=NULL;
30 EXECUTE stmt6 USING @a;
31 c1
32 SET @a=0;
33 EXECUTE stmt6 USING @a;
34 c1
35 0
36 SET @a=255;
37 EXECUTE stmt6 USING @a;
38 c1
39 255
40 DEALLOCATE PREPARE stmt6;
41 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
42 SET @a=NULL;
43 SET @b=0;
44 EXECUTE stmt6 USING @a,@b;
45 SET @a=0;
46 SET @b=NULL;
47 EXECUTE stmt6 USING @a,@b;
48 SET @a=255;
49 SET @a=201;
50 EXECUTE stmt6 USING @a,@b;
51 SELECT * FROM t6;
52 c1
53 255
54 NULL
55 NULL
56 SELECT COUNT(c1) AS total_rows FROM t6;
57 total_rows
58 1
59 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
60 positive_rows
61 1
62 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
63 null_rows
64 0
65 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
66 not_null_rows
67 1
68 DEALLOCATE PREPARE stmt6;
69 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
70 SET @a=NULL;
71 EXECUTE stmt6 USING @a;
72 SET @a=0;
73 EXECUTE stmt6 USING @a;
74 SET @a=255;
75 EXECUTE stmt6 USING @a;
76 SELECT * FROM t6;
77 c1
78 NULL
79 NULL
80 SELECT COUNT(c1) AS total_rows FROM t6;
81 total_rows
82 0
83 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
84 positive_rows
85 0
86 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
87 null_rows
88 0
89 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
90 not_null_rows
91 0
92 DEALLOCATE PREPARE stmt6;
93 DROP TABLE t6;
94 CREATE TABLE t6(c1 SMALLINT UNSIGNED NULL);
95 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
96 SET @a=NULL;
97 EXECUTE stmt6 USING @a;
98 SET @a=0;
99 EXECUTE stmt6 USING @a;
100 SET @a=255;
101 EXECUTE stmt6 USING @a;
102 SELECT * FROM t6;
103 c1
104 0
105 255
106 NULL
107 SELECT COUNT(c1) AS total_rows FROM t6;
108 total_rows
109 2
110 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
111 positive_rows
112 1
113 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
114 null_rows
115 0
116 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
117 not_null_rows
118 2
119 DEALLOCATE PREPARE stmt6;
120 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
121 SET @a=NULL;
122 EXECUTE stmt6 USING @a;
123 c1
124 SET @a=0;
125 EXECUTE stmt6 USING @a;
126 c1
127 0
128 SET @a=255;
129 EXECUTE stmt6 USING @a;
130 c1
131 255
132 DEALLOCATE PREPARE stmt6;
133 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
134 SET @a=NULL;
135 SET @b=0;
136 EXECUTE stmt6 USING @a,@b;
137 SET @a=0;
138 SET @b=NULL;
139 EXECUTE stmt6 USING @a,@b;
140 SET @a=255;
141 SET @a=201;
142 EXECUTE stmt6 USING @a,@b;
143 SELECT * FROM t6;
144 c1
145 255
146 NULL
147 NULL
148 SELECT COUNT(c1) AS total_rows FROM t6;
149 total_rows
150 1
151 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
152 positive_rows
153 1
154 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
155 null_rows
156 0
157 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
158 not_null_rows
159 1
160 DEALLOCATE PREPARE stmt6;
161 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
162 SET @a=NULL;
163 EXECUTE stmt6 USING @a;
164 SET @a=0;
165 EXECUTE stmt6 USING @a;
166 SET @a=255;
167 EXECUTE stmt6 USING @a;
168 SELECT * FROM t6;
169 c1
170 NULL
171 NULL
172 SELECT COUNT(c1) AS total_rows FROM t6;
173 total_rows
174 0
175 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
176 positive_rows
177 0
178 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
179 null_rows
180 0
181 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
182 not_null_rows
183 0
184 DEALLOCATE PREPARE stmt6;
185 DROP TABLE t6;
186 CREATE TABLE t6(c1 MEDIUMINT UNSIGNED NULL);
187 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
188 SET @a=NULL;
189 EXECUTE stmt6 USING @a;
190 SET @a=0;
191 EXECUTE stmt6 USING @a;
192 SET @a=255;
193 EXECUTE stmt6 USING @a;
194 SELECT * FROM t6;
195 c1
196 0
197 255
198 NULL
199 SELECT COUNT(c1) AS total_rows FROM t6;
200 total_rows
201 2
202 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
203 positive_rows
204 1
205 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
206 null_rows
207 0
208 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
209 not_null_rows
210 2
211 DEALLOCATE PREPARE stmt6;
212 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
213 SET @a=NULL;
214 EXECUTE stmt6 USING @a;
215 c1
216 SET @a=0;
217 EXECUTE stmt6 USING @a;
218 c1
219 0
220 SET @a=255;
221 EXECUTE stmt6 USING @a;
222 c1
223 255
224 DEALLOCATE PREPARE stmt6;
225 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
226 SET @a=NULL;
227 SET @b=0;
228 EXECUTE stmt6 USING @a,@b;
229 SET @a=0;
230 SET @b=NULL;
231 EXECUTE stmt6 USING @a,@b;
232 SET @a=255;
233 SET @a=201;
234 EXECUTE stmt6 USING @a,@b;
235 SELECT * FROM t6;
236 c1
237 255
238 NULL
239 NULL
240 SELECT COUNT(c1) AS total_rows FROM t6;
241 total_rows
242 1
243 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
244 positive_rows
245 1
246 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
247 null_rows
248 0
249 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
250 not_null_rows
251 1
252 DEALLOCATE PREPARE stmt6;
253 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
254 SET @a=NULL;
255 EXECUTE stmt6 USING @a;
256 SET @a=0;
257 EXECUTE stmt6 USING @a;
258 SET @a=255;
259 EXECUTE stmt6 USING @a;
260 SELECT * FROM t6;
261 c1
262 NULL
263 NULL
264 SELECT COUNT(c1) AS total_rows FROM t6;
265 total_rows
266 0
267 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
268 positive_rows
269 0
270 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
271 null_rows
272 0
273 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
274 not_null_rows
275 0
276 DEALLOCATE PREPARE stmt6;
277 DROP TABLE t6;
278 CREATE TABLE t6(c1 INT UNSIGNED NULL);
279 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
280 SET @a=NULL;
281 EXECUTE stmt6 USING @a;
282 SET @a=0;
283 EXECUTE stmt6 USING @a;
284 SET @a=255;
285 EXECUTE stmt6 USING @a;
286 SELECT * FROM t6;
287 c1
288 0
289 255
290 NULL
291 SELECT COUNT(c1) AS total_rows FROM t6;
292 total_rows
293 2
294 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
295 positive_rows
296 1
297 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
298 null_rows
299 0
300 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
301 not_null_rows
302 2
303 DEALLOCATE PREPARE stmt6;
304 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
305 SET @a=NULL;
306 EXECUTE stmt6 USING @a;
307 c1
308 SET @a=0;
309 EXECUTE stmt6 USING @a;
310 c1
311 0
312 SET @a=255;
313 EXECUTE stmt6 USING @a;
314 c1
315 255
316 DEALLOCATE PREPARE stmt6;
317 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
318 SET @a=NULL;
319 SET @b=0;
320 EXECUTE stmt6 USING @a,@b;
321 SET @a=0;
322 SET @b=NULL;
323 EXECUTE stmt6 USING @a,@b;
324 SET @a=255;
325 SET @a=201;
326 EXECUTE stmt6 USING @a,@b;
327 SELECT * FROM t6;
328 c1
329 255
330 NULL
331 NULL
332 SELECT COUNT(c1) AS total_rows FROM t6;
333 total_rows
334 1
335 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
336 positive_rows
337 1
338 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
339 null_rows
340 0
341 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
342 not_null_rows
343 1
344 DEALLOCATE PREPARE stmt6;
345 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
346 SET @a=NULL;
347 EXECUTE stmt6 USING @a;
348 SET @a=0;
349 EXECUTE stmt6 USING @a;
350 SET @a=255;
351 EXECUTE stmt6 USING @a;
352 SELECT * FROM t6;
353 c1
354 NULL
355 NULL
356 SELECT COUNT(c1) AS total_rows FROM t6;
357 total_rows
358 0
359 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
360 positive_rows
361 0
362 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
363 null_rows
364 0
365 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
366 not_null_rows
367 0
368 DEALLOCATE PREPARE stmt6;
369 DROP TABLE t6;
370 CREATE TABLE t6(c1 INTEGER UNSIGNED NULL);
371 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
372 SET @a=NULL;
373 EXECUTE stmt6 USING @a;
374 SET @a=0;
375 EXECUTE stmt6 USING @a;
376 SET @a=255;
377 EXECUTE stmt6 USING @a;
378 SELECT * FROM t6;
379 c1
380 0
381 255
382 NULL
383 SELECT COUNT(c1) AS total_rows FROM t6;
384 total_rows
385 2
386 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
387 positive_rows
388 1
389 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
390 null_rows
391 0
392 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
393 not_null_rows
394 2
395 DEALLOCATE PREPARE stmt6;
396 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
397 SET @a=NULL;
398 EXECUTE stmt6 USING @a;
399 c1
400 SET @a=0;
401 EXECUTE stmt6 USING @a;
402 c1
403 0
404 SET @a=255;
405 EXECUTE stmt6 USING @a;
406 c1
407 255
408 DEALLOCATE PREPARE stmt6;
409 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
410 SET @a=NULL;
411 SET @b=0;
412 EXECUTE stmt6 USING @a,@b;
413 SET @a=0;
414 SET @b=NULL;
415 EXECUTE stmt6 USING @a,@b;
416 SET @a=255;
417 SET @a=201;
418 EXECUTE stmt6 USING @a,@b;
419 SELECT * FROM t6;
420 c1
421 255
422 NULL
423 NULL
424 SELECT COUNT(c1) AS total_rows FROM t6;
425 total_rows
426 1
427 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
428 positive_rows
429 1
430 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
431 null_rows
432 0
433 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
434 not_null_rows
435 1
436 DEALLOCATE PREPARE stmt6;
437 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
438 SET @a=NULL;
439 EXECUTE stmt6 USING @a;
440 SET @a=0;
441 EXECUTE stmt6 USING @a;
442 SET @a=255;
443 EXECUTE stmt6 USING @a;
444 SELECT * FROM t6;
445 c1
446 NULL
447 NULL
448 SELECT COUNT(c1) AS total_rows FROM t6;
449 total_rows
450 0
451 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
452 positive_rows
453 0
454 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
455 null_rows
456 0
457 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
458 not_null_rows
459 0
460 DEALLOCATE PREPARE stmt6;
461 DROP TABLE t6;
462 CREATE TABLE t6(c1 BIGINT UNSIGNED NULL);
463 PREPARE stmt6 FROM 'INSERT INTO t6 (c1) VALUES(?)';
464 SET @a=NULL;
465 EXECUTE stmt6 USING @a;
466 SET @a=0;
467 EXECUTE stmt6 USING @a;
468 SET @a=255;
469 EXECUTE stmt6 USING @a;
470 SELECT * FROM t6;
471 c1
472 0
473 255
474 NULL
475 SELECT COUNT(c1) AS total_rows FROM t6;
476 total_rows
477 2
478 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
479 positive_rows
480 1
481 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
482 null_rows
483 0
484 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
485 not_null_rows
486 2
487 DEALLOCATE PREPARE stmt6;
488 PREPARE stmt6 FROM 'SELECT * FROM t6 WHERE c1 = ?';
489 SET @a=NULL;
490 EXECUTE stmt6 USING @a;
491 c1
492 SET @a=0;
493 EXECUTE stmt6 USING @a;
494 c1
495 0
496 SET @a=255;
497 EXECUTE stmt6 USING @a;
498 c1
499 255
500 DEALLOCATE PREPARE stmt6;
501 PREPARE stmt6 FROM 'UPDATE t6 SET c1 = ? WHERE c1 = ?';
502 SET @a=NULL;
503 SET @b=0;
504 EXECUTE stmt6 USING @a,@b;
505 SET @a=0;
506 SET @b=NULL;
507 EXECUTE stmt6 USING @a,@b;
508 SET @a=255;
509 SET @a=201;
510 EXECUTE stmt6 USING @a,@b;
511 SELECT * FROM t6;
512 c1
513 255
514 NULL
515 NULL
516 SELECT COUNT(c1) AS total_rows FROM t6;
517 total_rows
518 1
519 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
520 positive_rows
521 1
522 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
523 null_rows
524 0
525 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
526 not_null_rows
527 1
528 DEALLOCATE PREPARE stmt6;
529 PREPARE stmt6 FROM 'DELETE FROM t6 WHERE c1 = ?';
530 SET @a=NULL;
531 EXECUTE stmt6 USING @a;
532 SET @a=0;
533 EXECUTE stmt6 USING @a;
534 SET @a=255;
535 EXECUTE stmt6 USING @a;
536 SELECT * FROM t6;
537 c1
538 NULL
539 NULL
540 SELECT COUNT(c1) AS total_rows FROM t6;
541 total_rows
542 0
543 SELECT COUNT(c1) AS positive_rows FROM t6 WHERE c1 > 0;
544 positive_rows
545 0
546 SELECT COUNT(c1) AS null_rows FROM t6 WHERE c1 IS NULL;
547 null_rows
548 0
549 SELECT COUNT(c1) AS not_null_rows FROM t6 WHERE c1 IS NOT NULL;
550 not_null_rows
551 0
552 DEALLOCATE PREPARE stmt6;
553 DROP TABLE t6;