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 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
804 SET @a=0;
805 EXECUTE stmt4 USING @a;
806 SET @a=1.0;
807 EXECUTE stmt4 USING @a;
808 SET @a=-9.0;
809 EXECUTE stmt4 USING @a;
810 DEALLOCATE PREPARE stmt4;
811 SELECT * FROM t4;
812 c1
813 -9
814 0
815 1
816 SELECT COUNT(c1) AS total_rows FROM t4;
817 total_rows
818 3
819 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
820 positive_rows
821 1
822 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
823 negative_rows
824 1
825 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
826 zero_rows
827 1
828 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
829 SET @a=0;
830 EXECUTE stmt4 USING @a;
831 c1
832 0
833 SET @a=1.0;
834 EXECUTE stmt4 USING @a;
835 c1
836 1
837 SET @a=-9.0;
838 EXECUTE stmt4 USING @a;
839 c1
840 -9
841 DEALLOCATE PREPARE stmt4;
842 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
843 SET @a=0;
844 SET @b=1.0;
845 EXECUTE stmt4 USING @a,@b;
846 SET @a=1.0;
847 SET @b=0;
848 EXECUTE stmt4 USING @a,@b;
849 SET @a=-9.0;
850 SET @b=7.0;
851 EXECUTE stmt4 USING @a,@b;
852 DEALLOCATE PREPARE stmt4;
853 SELECT * FROM t4;
854 c1
855 -9
856 1
857 1
858 SELECT COUNT(c1) AS total_rows FROM t4;
859 total_rows
860 3
861 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
862 positive_rows
863 2
864 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
865 negative_rows
866 1
867 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
868 zero_rows
869 0
870 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
871 SET @a=0;
872 EXECUTE stmt4 USING @a;
873 SET @a=1.0;
874 EXECUTE stmt4 USING @a;
875 SET @a=-9.0;
876 EXECUTE stmt4 USING @a;
877 DEALLOCATE PREPARE stmt4;
878 SELECT * FROM t4;
879 c1
880 SELECT COUNT(c1) AS total_rows FROM t4;
881 total_rows
882 0
883 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
884 positive_rows
885 0
886 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
887 negative_rows
888 0
889 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
890 zero_rows
891 0
892 DROP TABLE t4;
893 CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
894 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
895 SET @a=0;
896 EXECUTE stmt5 USING @a;
897 SET @a=1.0;
898 EXECUTE stmt5 USING @a;
899 SET @a=1.2345;
900 EXECUTE stmt5 USING @a;
901 SET @a=-9.0;
902 EXECUTE stmt5 USING @a;
903 SET @a=-9.12345;
904 EXECUTE stmt5 USING @a;
905 SELECT * FROM t5;
906 c1
907 -9.0000
908 -9.1234
909 0.0000
910 1.0000
911 1.2345
912 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
913 positive_rows
914 2
915 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
916 negative_rows
917 2
918 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
919 zero_rows
920 1
921 DEALLOCATE PREPARE stmt5;
922 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
923 SET @a=0;
924 EXECUTE stmt5 USING @a;
925 c1
926 0.0000
927 SET @a=1.0;
928 EXECUTE stmt5 USING @a;
929 c1
930 1.0000
931 SET @a=1.2345;
932 EXECUTE stmt5 USING @a;
933 c1
934 1.2345
935 SET @a=-9.0;
936 EXECUTE stmt5 USING @a;
937 c1
938 -9.0000
939 SET @a=-9.12345;
940 EXECUTE stmt5 USING @a;
941 c1
942 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
943 SET @a=0;
944 SET @b=1.0;
945 EXECUTE stmt5 USING @a,@b;
946 SET @a=1.0;
947 SET @a=0;
948 EXECUTE stmt5 USING @a,@b;
949 SET @a=1.2345;
950 SET @a=3.5432;
951 EXECUTE stmt5 USING @a,@b;
952 SET @a=-9.0;
953 SET @a=-9.1;
954 EXECUTE stmt5 USING @a,@b;
955 SET @a=-9.12345;
956 SET @a=-8.54321;
957 EXECUTE stmt5 USING @a,@b;
958 SELECT * FROM t5;
959 c1
960 -9.0000
961 -9.1234
962 0.0000
963 0.0000
964 1.2345
965 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
966 positive_rows
967 1
968 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
969 negative_rows
970 2
971 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
972 zero_rows
973 2
974 DEALLOCATE PREPARE stmt5;
975 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
976 SET @a=0;
977 EXECUTE stmt5 USING @a;
978 SET @a=1.0;
979 EXECUTE stmt5 USING @a;
980 SET @a=1.2345;
981 EXECUTE stmt5 USING @a;
982 SET @a=-9.0;
983 EXECUTE stmt5 USING @a;
984 SET @a=-9.12345;
985 EXECUTE stmt5 USING @a;
986 SELECT * FROM t5;
987 c1
988 -9.1234
989 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
990 positive_rows
991 0
992 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
993 negative_rows
994 1
995 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
996 zero_rows
997 0
998 DEALLOCATE PREPARE stmt5;
999 DROP TABLE t5;
1000 CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
1001 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1002 SET @a=0;
1003 EXECUTE stmt4 USING @a;
1004 SET @a=1.0;
1005 EXECUTE stmt4 USING @a;
1006 SET @a=-9.0;
1007 EXECUTE stmt4 USING @a;
1008 DEALLOCATE PREPARE stmt4;
1009 SELECT * FROM t4;
1010 c1
1011 -9
1012 0
1013 1
1014 SELECT COUNT(c1) AS total_rows FROM t4;
1015 total_rows
1016 3
1017 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1018 positive_rows
1019 1
1020 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1021 negative_rows
1022 1
1023 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1024 zero_rows
1025 1
1026 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1027 SET @a=0;
1028 EXECUTE stmt4 USING @a;
1029 c1
1030 0
1031 SET @a=1.0;
1032 EXECUTE stmt4 USING @a;
1033 c1
1034 1
1035 SET @a=-9.0;
1036 EXECUTE stmt4 USING @a;
1037 c1
1038 -9
1039 DEALLOCATE PREPARE stmt4;
1040 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1041 SET @a=0;
1042 SET @b=1.0;
1043 EXECUTE stmt4 USING @a,@b;
1044 SET @a=1.0;
1045 SET @b=0;
1046 EXECUTE stmt4 USING @a,@b;
1047 SET @a=-9.0;
1048 SET @b=7.0;
1049 EXECUTE stmt4 USING @a,@b;
1050 DEALLOCATE PREPARE stmt4;
1051 SELECT * FROM t4;
1052 c1
1053 -9
1054 1
1055 1
1056 SELECT COUNT(c1) AS total_rows FROM t4;
1057 total_rows
1058 3
1059 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1060 positive_rows
1061 2
1062 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1063 negative_rows
1064 1
1065 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1066 zero_rows
1067 0
1068 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1069 SET @a=0;
1070 EXECUTE stmt4 USING @a;
1071 SET @a=1.0;
1072 EXECUTE stmt4 USING @a;
1073 SET @a=-9.0;
1074 EXECUTE stmt4 USING @a;
1075 DEALLOCATE PREPARE stmt4;
1076 SELECT * FROM t4;
1077 c1
1078 SELECT COUNT(c1) AS total_rows FROM t4;
1079 total_rows
1080 0
1081 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1082 positive_rows
1083 0
1084 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1085 negative_rows
1086 0
1087 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1088 zero_rows
1089 0
1090 DROP TABLE t4;
1091 CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
1092 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1093 SET @a=0;
1094 EXECUTE stmt5 USING @a;
1095 SET @a=1.0;
1096 EXECUTE stmt5 USING @a;
1097 SET @a=1.2345;
1098 EXECUTE stmt5 USING @a;
1099 SET @a=-9.0;
1100 EXECUTE stmt5 USING @a;
1101 SET @a=-9.12345;
1102 EXECUTE stmt5 USING @a;
1103 SELECT * FROM t5;
1104 c1
1105 -9.0000
1106 -9.1234
1107 0.0000
1108 1.0000
1109 1.2345
1110 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1111 positive_rows
1112 2
1113 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1114 negative_rows
1115 2
1116 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1117 zero_rows
1118 1
1119 DEALLOCATE PREPARE stmt5;
1120 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1121 SET @a=0;
1122 EXECUTE stmt5 USING @a;
1123 c1
1124 0.0000
1125 SET @a=1.0;
1126 EXECUTE stmt5 USING @a;
1127 c1
1128 1.0000
1129 SET @a=1.2345;
1130 EXECUTE stmt5 USING @a;
1131 c1
1132 1.2345
1133 SET @a=-9.0;
1134 EXECUTE stmt5 USING @a;
1135 c1
1136 -9.0000
1137 SET @a=-9.12345;
1138 EXECUTE stmt5 USING @a;
1139 c1
1140 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1141 SET @a=0;
1142 SET @b=1.0;
1143 EXECUTE stmt5 USING @a,@b;
1144 SET @a=1.0;
1145 SET @a=0;
1146 EXECUTE stmt5 USING @a,@b;
1147 SET @a=1.2345;
1148 SET @a=3.5432;
1149 EXECUTE stmt5 USING @a,@b;
1150 SET @a=-9.0;
1151 SET @a=-9.1;
1152 EXECUTE stmt5 USING @a,@b;
1153 SET @a=-9.12345;
1154 SET @a=-8.54321;
1155 EXECUTE stmt5 USING @a,@b;
1156 SELECT * FROM t5;
1157 c1
1158 -9.0000
1159 -9.1234
1160 0.0000
1161 0.0000
1162 1.2345
1163 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1164 positive_rows
1165 1
1166 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1167 negative_rows
1168 2
1169 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1170 zero_rows
1171 2
1172 DEALLOCATE PREPARE stmt5;
1173 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1174 SET @a=0;
1175 EXECUTE stmt5 USING @a;
1176 SET @a=1.0;
1177 EXECUTE stmt5 USING @a;
1178 SET @a=1.2345;
1179 EXECUTE stmt5 USING @a;
1180 SET @a=-9.0;
1181 EXECUTE stmt5 USING @a;
1182 SET @a=-9.12345;
1183 EXECUTE stmt5 USING @a;
1184 SELECT * FROM t5;
1185 c1
1186 -9.1234
1187 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1188 positive_rows
1189 0
1190 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1191 negative_rows
1192 1
1193 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1194 zero_rows
1195 0
1196 DEALLOCATE PREPARE stmt5;
1197 DROP TABLE t5;
1198 CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
1199 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1200 SET @a=0;
1201 EXECUTE stmt4 USING @a;
1202 SET @a=1.0;
1203 EXECUTE stmt4 USING @a;
1204 SET @a=-9.0;
1205 EXECUTE stmt4 USING @a;
1206 DEALLOCATE PREPARE stmt4;
1207 SELECT * FROM t4;
1208 c1
1209 -9
1210 0
1211 1
1212 SELECT COUNT(c1) AS total_rows FROM t4;
1213 total_rows
1214 3
1215 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1216 positive_rows
1217 1
1218 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1219 negative_rows
1220 1
1221 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1222 zero_rows
1223 1
1224 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1225 SET @a=0;
1226 EXECUTE stmt4 USING @a;
1227 c1
1228 0
1229 SET @a=1.0;
1230 EXECUTE stmt4 USING @a;
1231 c1
1232 1
1233 SET @a=-9.0;
1234 EXECUTE stmt4 USING @a;
1235 c1
1236 -9
1237 DEALLOCATE PREPARE stmt4;
1238 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1239 SET @a=0;
1240 SET @b=1.0;
1241 EXECUTE stmt4 USING @a,@b;
1242 SET @a=1.0;
1243 SET @b=0;
1244 EXECUTE stmt4 USING @a,@b;
1245 SET @a=-9.0;
1246 SET @b=7.0;
1247 EXECUTE stmt4 USING @a,@b;
1248 DEALLOCATE PREPARE stmt4;
1249 SELECT * FROM t4;
1250 c1
1251 -9
1252 1
1253 1
1254 SELECT COUNT(c1) AS total_rows FROM t4;
1255 total_rows
1256 3
1257 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1258 positive_rows
1259 2
1260 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1261 negative_rows
1262 1
1263 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1264 zero_rows
1265 0
1266 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1267 SET @a=0;
1268 EXECUTE stmt4 USING @a;
1269 SET @a=1.0;
1270 EXECUTE stmt4 USING @a;
1271 SET @a=-9.0;
1272 EXECUTE stmt4 USING @a;
1273 DEALLOCATE PREPARE stmt4;
1274 SELECT * FROM t4;
1275 c1
1276 SELECT COUNT(c1) AS total_rows FROM t4;
1277 total_rows
1278 0
1279 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1280 positive_rows
1281 0
1282 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1283 negative_rows
1284 0
1285 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1286 zero_rows
1287 0
1288 DROP TABLE t4;
1289 CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
1290 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1291 SET @a=0;
1292 EXECUTE stmt5 USING @a;
1293 SET @a=1.0;
1294 EXECUTE stmt5 USING @a;
1295 SET @a=1.2345;
1296 EXECUTE stmt5 USING @a;
1297 SET @a=-9.0;
1298 EXECUTE stmt5 USING @a;
1299 SET @a=-9.12345;
1300 EXECUTE stmt5 USING @a;
1301 SELECT * FROM t5;
1302 c1
1303 -9.0000
1304 -9.1234
1305 0.0000
1306 1.0000
1307 1.2345
1308 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1309 positive_rows
1310 2
1311 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1312 negative_rows
1313 2
1314 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1315 zero_rows
1316 1
1317 DEALLOCATE PREPARE stmt5;
1318 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1319 SET @a=0;
1320 EXECUTE stmt5 USING @a;
1321 c1
1322 0.0000
1323 SET @a=1.0;
1324 EXECUTE stmt5 USING @a;
1325 c1
1326 1.0000
1327 SET @a=1.2345;
1328 EXECUTE stmt5 USING @a;
1329 c1
1330 1.2345
1331 SET @a=-9.0;
1332 EXECUTE stmt5 USING @a;
1333 c1
1334 -9.0000
1335 SET @a=-9.12345;
1336 EXECUTE stmt5 USING @a;
1337 c1
1338 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1339 SET @a=0;
1340 SET @b=1.0;
1341 EXECUTE stmt5 USING @a,@b;
1342 SET @a=1.0;
1343 SET @a=0;
1344 EXECUTE stmt5 USING @a,@b;
1345 SET @a=1.2345;
1346 SET @a=3.5432;
1347 EXECUTE stmt5 USING @a,@b;
1348 SET @a=-9.0;
1349 SET @a=-9.1;
1350 EXECUTE stmt5 USING @a,@b;
1351 SET @a=-9.12345;
1352 SET @a=-8.54321;
1353 EXECUTE stmt5 USING @a,@b;
1354 SELECT * FROM t5;
1355 c1
1356 -9.0000
1357 -9.1234
1358 0.0000
1359 0.0000
1360 1.2345
1361 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1362 positive_rows
1363 1
1364 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1365 negative_rows
1366 2
1367 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1368 zero_rows
1369 2
1370 DEALLOCATE PREPARE stmt5;
1371 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1372 SET @a=0;
1373 EXECUTE stmt5 USING @a;
1374 SET @a=1.0;
1375 EXECUTE stmt5 USING @a;
1376 SET @a=1.2345;
1377 EXECUTE stmt5 USING @a;
1378 SET @a=-9.0;
1379 EXECUTE stmt5 USING @a;
1380 SET @a=-9.12345;
1381 EXECUTE stmt5 USING @a;
1382 SELECT * FROM t5;
1383 c1
1384 -9.1234
1385 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1386 positive_rows
1387 0
1388 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1389 negative_rows
1390 1
1391 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1392 zero_rows
1393 0
1394 DEALLOCATE PREPARE stmt5;
1395 DROP TABLE t5;
1396 CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
1397 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1398 SET @a=0;
1399 EXECUTE stmt4 USING @a;
1400 SET @a=1.0;
1401 EXECUTE stmt4 USING @a;
1402 SET @a=-9.0;
1403 EXECUTE stmt4 USING @a;
1404 DEALLOCATE PREPARE stmt4;
1405 SELECT * FROM t4;
1406 c1
1407 -9
1408 0
1409 1
1410 SELECT COUNT(c1) AS total_rows FROM t4;
1411 total_rows
1412 3
1413 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1414 positive_rows
1415 1
1416 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1417 negative_rows
1418 1
1419 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1420 zero_rows
1421 1
1422 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1423 SET @a=0;
1424 EXECUTE stmt4 USING @a;
1425 c1
1426 0
1427 SET @a=1.0;
1428 EXECUTE stmt4 USING @a;
1429 c1
1430 1
1431 SET @a=-9.0;
1432 EXECUTE stmt4 USING @a;
1433 c1
1434 -9
1435 DEALLOCATE PREPARE stmt4;
1436 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1437 SET @a=0;
1438 SET @b=1.0;
1439 EXECUTE stmt4 USING @a,@b;
1440 SET @a=1.0;
1441 SET @b=0;
1442 EXECUTE stmt4 USING @a,@b;
1443 SET @a=-9.0;
1444 SET @b=7.0;
1445 EXECUTE stmt4 USING @a,@b;
1446 DEALLOCATE PREPARE stmt4;
1447 SELECT * FROM t4;
1448 c1
1449 -9
1450 1
1451 1
1452 SELECT COUNT(c1) AS total_rows FROM t4;
1453 total_rows
1454 3
1455 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1456 positive_rows
1457 2
1458 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1459 negative_rows
1460 1
1461 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1462 zero_rows
1463 0
1464 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1465 SET @a=0;
1466 EXECUTE stmt4 USING @a;
1467 SET @a=1.0;
1468 EXECUTE stmt4 USING @a;
1469 SET @a=-9.0;
1470 EXECUTE stmt4 USING @a;
1471 DEALLOCATE PREPARE stmt4;
1472 SELECT * FROM t4;
1473 c1
1474 SELECT COUNT(c1) AS total_rows FROM t4;
1475 total_rows
1476 0
1477 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1478 positive_rows
1479 0
1480 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1481 negative_rows
1482 0
1483 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1484 zero_rows
1485 0
1486 DROP TABLE t4;
1487 CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
1488 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1489 SET @a=0;
1490 EXECUTE stmt5 USING @a;
1491 SET @a=1.0;
1492 EXECUTE stmt5 USING @a;
1493 SET @a=1.2345;
1494 EXECUTE stmt5 USING @a;
1495 SET @a=-9.0;
1496 EXECUTE stmt5 USING @a;
1497 SET @a=-9.12345;
1498 EXECUTE stmt5 USING @a;
1499 SELECT * FROM t5;
1500 c1
1501 -9.0000
1502 -9.1234
1503 0.0000
1504 1.0000
1505 1.2345
1506 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1507 positive_rows
1508 2
1509 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1510 negative_rows
1511 2
1512 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1513 zero_rows
1514 1
1515 DEALLOCATE PREPARE stmt5;
1516 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1517 SET @a=0;
1518 EXECUTE stmt5 USING @a;
1519 c1
1520 0.0000
1521 SET @a=1.0;
1522 EXECUTE stmt5 USING @a;
1523 c1
1524 1.0000
1525 SET @a=1.2345;
1526 EXECUTE stmt5 USING @a;
1527 c1
1528 1.2345
1529 SET @a=-9.0;
1530 EXECUTE stmt5 USING @a;
1531 c1
1532 -9.0000
1533 SET @a=-9.12345;
1534 EXECUTE stmt5 USING @a;
1535 c1
1536 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1537 SET @a=0;
1538 SET @b=1.0;
1539 EXECUTE stmt5 USING @a,@b;
1540 SET @a=1.0;
1541 SET @a=0;
1542 EXECUTE stmt5 USING @a,@b;
1543 SET @a=1.2345;
1544 SET @a=3.5432;
1545 EXECUTE stmt5 USING @a,@b;
1546 SET @a=-9.0;
1547 SET @a=-9.1;
1548 EXECUTE stmt5 USING @a,@b;
1549 SET @a=-9.12345;
1550 SET @a=-8.54321;
1551 EXECUTE stmt5 USING @a,@b;
1552 SELECT * FROM t5;
1553 c1
1554 -9.0000
1555 -9.1234
1556 0.0000
1557 0.0000
1558 1.2345
1559 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1560 positive_rows
1561 1
1562 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1563 negative_rows
1564 2
1565 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1566 zero_rows
1567 2
1568 DEALLOCATE PREPARE stmt5;
1569 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1570 SET @a=0;
1571 EXECUTE stmt5 USING @a;
1572 SET @a=1.0;
1573 EXECUTE stmt5 USING @a;
1574 SET @a=1.2345;
1575 EXECUTE stmt5 USING @a;
1576 SET @a=-9.0;
1577 EXECUTE stmt5 USING @a;
1578 SET @a=-9.12345;
1579 EXECUTE stmt5 USING @a;
1580 SELECT * FROM t5;
1581 c1
1582 -9.1234
1583 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1584 positive_rows
1585 0
1586 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1587 negative_rows
1588 1
1589 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1590 zero_rows
1591 0
1592 DEALLOCATE PREPARE stmt5;
1593 DROP TABLE t5;