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(?)';
5
EXECUTE stmt4 USING @a;
7
EXECUTE stmt4 USING @a;
9
EXECUTE stmt4 USING @a;
10
DEALLOCATE PREPARE stmt4;
16
SELECT COUNT(c1) AS total_rows FROM t4;
19
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
22
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
25
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
28
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
30
EXECUTE stmt4 USING @a;
34
EXECUTE stmt4 USING @a;
38
EXECUTE stmt4 USING @a;
41
DEALLOCATE PREPARE stmt4;
42
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
45
EXECUTE stmt4 USING @a,@b;
48
EXECUTE stmt4 USING @a,@b;
51
EXECUTE stmt4 USING @a,@b;
52
DEALLOCATE PREPARE stmt4;
58
SELECT COUNT(c1) AS total_rows FROM t4;
61
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
64
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
67
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
70
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
72
EXECUTE stmt4 USING @a;
74
EXECUTE stmt4 USING @a;
76
EXECUTE stmt4 USING @a;
77
DEALLOCATE PREPARE stmt4;
80
SELECT COUNT(c1) AS total_rows FROM t4;
83
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
86
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
89
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
93
CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
94
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
96
EXECUTE stmt5 USING @a;
98
EXECUTE stmt5 USING @a;
100
EXECUTE stmt5 USING @a;
102
EXECUTE stmt5 USING @a;
104
EXECUTE stmt5 USING @a;
106
Note 1265 Data truncated for column 'c1' at row 1
114
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
117
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
120
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
123
DEALLOCATE PREPARE stmt5;
124
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
126
EXECUTE stmt5 USING @a;
130
EXECUTE stmt5 USING @a;
134
EXECUTE stmt5 USING @a;
138
EXECUTE stmt5 USING @a;
142
EXECUTE stmt5 USING @a;
144
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
147
EXECUTE stmt5 USING @a,@b;
150
EXECUTE stmt5 USING @a,@b;
153
EXECUTE stmt5 USING @a,@b;
156
EXECUTE stmt5 USING @a,@b;
159
EXECUTE stmt5 USING @a,@b;
167
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
170
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
173
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
176
DEALLOCATE PREPARE stmt5;
177
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
179
EXECUTE stmt5 USING @a;
181
EXECUTE stmt5 USING @a;
183
EXECUTE stmt5 USING @a;
185
EXECUTE stmt5 USING @a;
187
EXECUTE stmt5 USING @a;
191
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
194
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
197
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
200
DEALLOCATE PREPARE stmt5;
202
CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
203
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
205
EXECUTE stmt4 USING @a;
207
EXECUTE stmt4 USING @a;
209
EXECUTE stmt4 USING @a;
210
DEALLOCATE PREPARE stmt4;
216
SELECT COUNT(c1) AS total_rows FROM t4;
219
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
222
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
225
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
228
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
230
EXECUTE stmt4 USING @a;
234
EXECUTE stmt4 USING @a;
238
EXECUTE stmt4 USING @a;
241
DEALLOCATE PREPARE stmt4;
242
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
245
EXECUTE stmt4 USING @a,@b;
248
EXECUTE stmt4 USING @a,@b;
251
EXECUTE stmt4 USING @a,@b;
252
DEALLOCATE PREPARE stmt4;
258
SELECT COUNT(c1) AS total_rows FROM t4;
261
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
264
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
267
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
270
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
272
EXECUTE stmt4 USING @a;
274
EXECUTE stmt4 USING @a;
276
EXECUTE stmt4 USING @a;
277
DEALLOCATE PREPARE stmt4;
280
SELECT COUNT(c1) AS total_rows FROM t4;
283
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
286
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
289
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
293
CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
294
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
296
EXECUTE stmt5 USING @a;
298
EXECUTE stmt5 USING @a;
300
EXECUTE stmt5 USING @a;
302
EXECUTE stmt5 USING @a;
304
EXECUTE stmt5 USING @a;
306
Note 1265 Data truncated for column 'c1' at row 1
314
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
317
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
320
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
323
DEALLOCATE PREPARE stmt5;
324
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
326
EXECUTE stmt5 USING @a;
330
EXECUTE stmt5 USING @a;
334
EXECUTE stmt5 USING @a;
338
EXECUTE stmt5 USING @a;
342
EXECUTE stmt5 USING @a;
344
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
347
EXECUTE stmt5 USING @a,@b;
350
EXECUTE stmt5 USING @a,@b;
353
EXECUTE stmt5 USING @a,@b;
356
EXECUTE stmt5 USING @a,@b;
359
EXECUTE stmt5 USING @a,@b;
367
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
370
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
373
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
376
DEALLOCATE PREPARE stmt5;
377
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
379
EXECUTE stmt5 USING @a;
381
EXECUTE stmt5 USING @a;
383
EXECUTE stmt5 USING @a;
385
EXECUTE stmt5 USING @a;
387
EXECUTE stmt5 USING @a;
391
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
394
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
397
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
400
DEALLOCATE PREPARE stmt5;
402
CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
403
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
405
EXECUTE stmt4 USING @a;
407
EXECUTE stmt4 USING @a;
409
EXECUTE stmt4 USING @a;
410
DEALLOCATE PREPARE stmt4;
416
SELECT COUNT(c1) AS total_rows FROM t4;
419
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
422
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
425
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
428
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
430
EXECUTE stmt4 USING @a;
434
EXECUTE stmt4 USING @a;
438
EXECUTE stmt4 USING @a;
441
DEALLOCATE PREPARE stmt4;
442
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
445
EXECUTE stmt4 USING @a,@b;
448
EXECUTE stmt4 USING @a,@b;
451
EXECUTE stmt4 USING @a,@b;
452
DEALLOCATE PREPARE stmt4;
458
SELECT COUNT(c1) AS total_rows FROM t4;
461
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
464
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
467
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
470
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
472
EXECUTE stmt4 USING @a;
474
EXECUTE stmt4 USING @a;
476
EXECUTE stmt4 USING @a;
477
DEALLOCATE PREPARE stmt4;
480
SELECT COUNT(c1) AS total_rows FROM t4;
483
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
486
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
489
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
493
CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
494
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
496
EXECUTE stmt5 USING @a;
498
EXECUTE stmt5 USING @a;
500
EXECUTE stmt5 USING @a;
502
EXECUTE stmt5 USING @a;
504
EXECUTE stmt5 USING @a;
506
Note 1265 Data truncated for column 'c1' at row 1
514
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
517
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
520
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
523
DEALLOCATE PREPARE stmt5;
524
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
526
EXECUTE stmt5 USING @a;
530
EXECUTE stmt5 USING @a;
534
EXECUTE stmt5 USING @a;
538
EXECUTE stmt5 USING @a;
542
EXECUTE stmt5 USING @a;
544
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
547
EXECUTE stmt5 USING @a,@b;
550
EXECUTE stmt5 USING @a,@b;
553
EXECUTE stmt5 USING @a,@b;
556
EXECUTE stmt5 USING @a,@b;
559
EXECUTE stmt5 USING @a,@b;
567
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
570
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
573
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
576
DEALLOCATE PREPARE stmt5;
577
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
579
EXECUTE stmt5 USING @a;
581
EXECUTE stmt5 USING @a;
583
EXECUTE stmt5 USING @a;
585
EXECUTE stmt5 USING @a;
587
EXECUTE stmt5 USING @a;
591
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
594
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
597
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
600
DEALLOCATE PREPARE stmt5;
602
CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
603
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
605
EXECUTE stmt4 USING @a;
607
EXECUTE stmt4 USING @a;
609
EXECUTE stmt4 USING @a;
610
DEALLOCATE PREPARE stmt4;
616
SELECT COUNT(c1) AS total_rows FROM t4;
619
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
622
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
625
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
628
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
630
EXECUTE stmt4 USING @a;
634
EXECUTE stmt4 USING @a;
638
EXECUTE stmt4 USING @a;
641
DEALLOCATE PREPARE stmt4;
642
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
645
EXECUTE stmt4 USING @a,@b;
648
EXECUTE stmt4 USING @a,@b;
651
EXECUTE stmt4 USING @a,@b;
652
DEALLOCATE PREPARE stmt4;
658
SELECT COUNT(c1) AS total_rows FROM t4;
661
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
664
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
667
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
670
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
672
EXECUTE stmt4 USING @a;
674
EXECUTE stmt4 USING @a;
676
EXECUTE stmt4 USING @a;
677
DEALLOCATE PREPARE stmt4;
680
SELECT COUNT(c1) AS total_rows FROM t4;
683
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
686
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
689
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
693
CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
694
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
696
EXECUTE stmt5 USING @a;
698
EXECUTE stmt5 USING @a;
700
EXECUTE stmt5 USING @a;
702
EXECUTE stmt5 USING @a;
704
EXECUTE stmt5 USING @a;
706
Note 1265 Data truncated for column 'c1' at row 1
714
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
717
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
720
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
723
DEALLOCATE PREPARE stmt5;
724
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
726
EXECUTE stmt5 USING @a;
730
EXECUTE stmt5 USING @a;
734
EXECUTE stmt5 USING @a;
738
EXECUTE stmt5 USING @a;
742
EXECUTE stmt5 USING @a;
744
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
747
EXECUTE stmt5 USING @a,@b;
750
EXECUTE stmt5 USING @a,@b;
753
EXECUTE stmt5 USING @a,@b;
756
EXECUTE stmt5 USING @a,@b;
759
EXECUTE stmt5 USING @a,@b;
767
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
770
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
773
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
776
DEALLOCATE PREPARE stmt5;
777
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
779
EXECUTE stmt5 USING @a;
781
EXECUTE stmt5 USING @a;
783
EXECUTE stmt5 USING @a;
785
EXECUTE stmt5 USING @a;
787
EXECUTE stmt5 USING @a;
791
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
794
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
797
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
800
DEALLOCATE PREPARE stmt5;
802
CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
803
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
805
EXECUTE stmt4 USING @a;
807
EXECUTE stmt4 USING @a;
809
EXECUTE stmt4 USING @a;
810
DEALLOCATE PREPARE stmt4;
816
SELECT COUNT(c1) AS total_rows FROM t4;
819
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
822
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
825
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
828
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
830
EXECUTE stmt4 USING @a;
834
EXECUTE stmt4 USING @a;
838
EXECUTE stmt4 USING @a;
841
DEALLOCATE PREPARE stmt4;
842
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
845
EXECUTE stmt4 USING @a,@b;
848
EXECUTE stmt4 USING @a,@b;
851
EXECUTE stmt4 USING @a,@b;
852
DEALLOCATE PREPARE stmt4;
858
SELECT COUNT(c1) AS total_rows FROM t4;
861
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
864
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
867
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
870
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
872
EXECUTE stmt4 USING @a;
874
EXECUTE stmt4 USING @a;
876
EXECUTE stmt4 USING @a;
877
DEALLOCATE PREPARE stmt4;
880
SELECT COUNT(c1) AS total_rows FROM t4;
883
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
886
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
889
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
893
CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
894
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
896
EXECUTE stmt5 USING @a;
898
EXECUTE stmt5 USING @a;
900
EXECUTE stmt5 USING @a;
902
EXECUTE stmt5 USING @a;
904
EXECUTE stmt5 USING @a;
912
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
915
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
918
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
921
DEALLOCATE PREPARE stmt5;
922
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
924
EXECUTE stmt5 USING @a;
928
EXECUTE stmt5 USING @a;
932
EXECUTE stmt5 USING @a;
936
EXECUTE stmt5 USING @a;
940
EXECUTE stmt5 USING @a;
942
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
945
EXECUTE stmt5 USING @a,@b;
948
EXECUTE stmt5 USING @a,@b;
951
EXECUTE stmt5 USING @a,@b;
954
EXECUTE stmt5 USING @a,@b;
957
EXECUTE stmt5 USING @a,@b;
965
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
968
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
971
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
974
DEALLOCATE PREPARE stmt5;
975
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
977
EXECUTE stmt5 USING @a;
979
EXECUTE stmt5 USING @a;
981
EXECUTE stmt5 USING @a;
983
EXECUTE stmt5 USING @a;
985
EXECUTE stmt5 USING @a;
989
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
992
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
995
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
998
DEALLOCATE PREPARE stmt5;
1000
CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
1001
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1003
EXECUTE stmt4 USING @a;
1005
EXECUTE stmt4 USING @a;
1007
EXECUTE stmt4 USING @a;
1008
DEALLOCATE PREPARE stmt4;
1014
SELECT COUNT(c1) AS total_rows FROM t4;
1017
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1020
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1023
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1026
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1028
EXECUTE stmt4 USING @a;
1032
EXECUTE stmt4 USING @a;
1036
EXECUTE stmt4 USING @a;
1039
DEALLOCATE PREPARE stmt4;
1040
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1043
EXECUTE stmt4 USING @a,@b;
1046
EXECUTE stmt4 USING @a,@b;
1049
EXECUTE stmt4 USING @a,@b;
1050
DEALLOCATE PREPARE stmt4;
1056
SELECT COUNT(c1) AS total_rows FROM t4;
1059
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1062
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1065
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1068
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1070
EXECUTE stmt4 USING @a;
1072
EXECUTE stmt4 USING @a;
1074
EXECUTE stmt4 USING @a;
1075
DEALLOCATE PREPARE stmt4;
1078
SELECT COUNT(c1) AS total_rows FROM t4;
1081
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1084
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1087
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1091
CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
1092
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1094
EXECUTE stmt5 USING @a;
1096
EXECUTE stmt5 USING @a;
1098
EXECUTE stmt5 USING @a;
1100
EXECUTE stmt5 USING @a;
1102
EXECUTE stmt5 USING @a;
1110
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1113
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1116
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1119
DEALLOCATE PREPARE stmt5;
1120
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1122
EXECUTE stmt5 USING @a;
1126
EXECUTE stmt5 USING @a;
1130
EXECUTE stmt5 USING @a;
1134
EXECUTE stmt5 USING @a;
1138
EXECUTE stmt5 USING @a;
1140
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1143
EXECUTE stmt5 USING @a,@b;
1146
EXECUTE stmt5 USING @a,@b;
1149
EXECUTE stmt5 USING @a,@b;
1152
EXECUTE stmt5 USING @a,@b;
1155
EXECUTE stmt5 USING @a,@b;
1163
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1166
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1169
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1172
DEALLOCATE PREPARE stmt5;
1173
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1175
EXECUTE stmt5 USING @a;
1177
EXECUTE stmt5 USING @a;
1179
EXECUTE stmt5 USING @a;
1181
EXECUTE stmt5 USING @a;
1183
EXECUTE stmt5 USING @a;
1187
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1190
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1193
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1196
DEALLOCATE PREPARE stmt5;
1198
CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
1199
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1201
EXECUTE stmt4 USING @a;
1203
EXECUTE stmt4 USING @a;
1205
EXECUTE stmt4 USING @a;
1206
DEALLOCATE PREPARE stmt4;
1212
SELECT COUNT(c1) AS total_rows FROM t4;
1215
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1218
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1221
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1224
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1226
EXECUTE stmt4 USING @a;
1230
EXECUTE stmt4 USING @a;
1234
EXECUTE stmt4 USING @a;
1237
DEALLOCATE PREPARE stmt4;
1238
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1241
EXECUTE stmt4 USING @a,@b;
1244
EXECUTE stmt4 USING @a,@b;
1247
EXECUTE stmt4 USING @a,@b;
1248
DEALLOCATE PREPARE stmt4;
1254
SELECT COUNT(c1) AS total_rows FROM t4;
1257
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1260
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1263
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1266
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1268
EXECUTE stmt4 USING @a;
1270
EXECUTE stmt4 USING @a;
1272
EXECUTE stmt4 USING @a;
1273
DEALLOCATE PREPARE stmt4;
1276
SELECT COUNT(c1) AS total_rows FROM t4;
1279
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1282
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1285
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1289
CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
1290
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1292
EXECUTE stmt5 USING @a;
1294
EXECUTE stmt5 USING @a;
1296
EXECUTE stmt5 USING @a;
1298
EXECUTE stmt5 USING @a;
1300
EXECUTE stmt5 USING @a;
1308
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1311
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1314
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1317
DEALLOCATE PREPARE stmt5;
1318
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1320
EXECUTE stmt5 USING @a;
1324
EXECUTE stmt5 USING @a;
1328
EXECUTE stmt5 USING @a;
1332
EXECUTE stmt5 USING @a;
1336
EXECUTE stmt5 USING @a;
1338
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1341
EXECUTE stmt5 USING @a,@b;
1344
EXECUTE stmt5 USING @a,@b;
1347
EXECUTE stmt5 USING @a,@b;
1350
EXECUTE stmt5 USING @a,@b;
1353
EXECUTE stmt5 USING @a,@b;
1361
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1364
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1367
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1370
DEALLOCATE PREPARE stmt5;
1371
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1373
EXECUTE stmt5 USING @a;
1375
EXECUTE stmt5 USING @a;
1377
EXECUTE stmt5 USING @a;
1379
EXECUTE stmt5 USING @a;
1381
EXECUTE stmt5 USING @a;
1385
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1388
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1391
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1394
DEALLOCATE PREPARE stmt5;
1396
CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
1397
PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1399
EXECUTE stmt4 USING @a;
1401
EXECUTE stmt4 USING @a;
1403
EXECUTE stmt4 USING @a;
1404
DEALLOCATE PREPARE stmt4;
1410
SELECT COUNT(c1) AS total_rows FROM t4;
1413
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1416
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1419
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1422
PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1424
EXECUTE stmt4 USING @a;
1428
EXECUTE stmt4 USING @a;
1432
EXECUTE stmt4 USING @a;
1435
DEALLOCATE PREPARE stmt4;
1436
PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1439
EXECUTE stmt4 USING @a,@b;
1442
EXECUTE stmt4 USING @a,@b;
1445
EXECUTE stmt4 USING @a,@b;
1446
DEALLOCATE PREPARE stmt4;
1452
SELECT COUNT(c1) AS total_rows FROM t4;
1455
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1458
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1461
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1464
PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1466
EXECUTE stmt4 USING @a;
1468
EXECUTE stmt4 USING @a;
1470
EXECUTE stmt4 USING @a;
1471
DEALLOCATE PREPARE stmt4;
1474
SELECT COUNT(c1) AS total_rows FROM t4;
1477
SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1480
SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1483
SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1487
CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
1488
PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1490
EXECUTE stmt5 USING @a;
1492
EXECUTE stmt5 USING @a;
1494
EXECUTE stmt5 USING @a;
1496
EXECUTE stmt5 USING @a;
1498
EXECUTE stmt5 USING @a;
1506
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1509
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1512
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1515
DEALLOCATE PREPARE stmt5;
1516
PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1518
EXECUTE stmt5 USING @a;
1522
EXECUTE stmt5 USING @a;
1526
EXECUTE stmt5 USING @a;
1530
EXECUTE stmt5 USING @a;
1534
EXECUTE stmt5 USING @a;
1536
PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1539
EXECUTE stmt5 USING @a,@b;
1542
EXECUTE stmt5 USING @a,@b;
1545
EXECUTE stmt5 USING @a,@b;
1548
EXECUTE stmt5 USING @a,@b;
1551
EXECUTE stmt5 USING @a,@b;
1559
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1562
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1565
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1568
DEALLOCATE PREPARE stmt5;
1569
PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1571
EXECUTE stmt5 USING @a;
1573
EXECUTE stmt5 USING @a;
1575
EXECUTE stmt5 USING @a;
1577
EXECUTE stmt5 USING @a;
1579
EXECUTE stmt5 USING @a;
1583
SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1586
SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1589
SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1592
DEALLOCATE PREPARE stmt5;