Debian Codegraph @

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

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