Debian Codegraph @

mysql-test/suite/engines/funcs/t/ps_number_length.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t4,t5;
3 --enable_warnings
4 CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL);
5 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
6 SET @a=0;
7 EXECUTE stmt4 USING @a;
8 SET @a=1.0;
9 EXECUTE stmt4 USING @a;
10 SET @a=-9.0;
11 EXECUTE stmt4 USING @a;
12 DEALLOCATE PREPARE stmt4;
13 --sorted_result
14 SELECT * FROM t4;
15 --sorted_result
16 SELECT COUNT(c1) AS total_rows FROM t4;
17 --sorted_result
18 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
19 --sorted_result
20 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
21 --sorted_result
22 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
23 --sorted_result
24 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
25 SET @a=0;
26 EXECUTE stmt4 USING @a;
27 SET @a=1.0;
28 EXECUTE stmt4 USING @a;
29 SET @a=-9.0;
30 EXECUTE stmt4 USING @a;
31 DEALLOCATE PREPARE stmt4;
32 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
33 SET @a=0;
34 SET @b=1.0;
35 EXECUTE stmt4 USING @a,@b;
36 SET @a=1.0;
37 SET @b=0;
38 EXECUTE stmt4 USING @a,@b;
39 SET @a=-9.0;
40 SET @b=7.0;
41 EXECUTE stmt4 USING @a,@b;
42 DEALLOCATE PREPARE stmt4;
43 --sorted_result
44 SELECT * FROM t4;
45 --sorted_result
46 SELECT COUNT(c1) AS total_rows FROM t4;
47 --sorted_result
48 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
49 --sorted_result
50 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
51 --sorted_result
52 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
53 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
54 SET @a=0;
55 EXECUTE stmt4 USING @a;
56 SET @a=1.0;
57 EXECUTE stmt4 USING @a;
58 SET @a=-9.0;
59 EXECUTE stmt4 USING @a;
60 DEALLOCATE PREPARE stmt4;
61 --sorted_result
62 SELECT * FROM t4;
63 --sorted_result
64 SELECT COUNT(c1) AS total_rows FROM t4;
65 --sorted_result
66 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
67 --sorted_result
68 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
69 --sorted_result
70 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
71 DROP TABLE t4;
72 CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL);
73 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
74 SET @a=0;
75 EXECUTE stmt5 USING @a;
76 SET @a=1.0;
77 EXECUTE stmt5 USING @a;
78 SET @a=1.2345;
79 EXECUTE stmt5 USING @a;
80 SET @a=-9.0;
81 EXECUTE stmt5 USING @a;
82 SET @a=-9.12345;
83 EXECUTE stmt5 USING @a;
84 --sorted_result
85 SELECT * FROM t5;
86 --sorted_result
87 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
88 --sorted_result
89 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
90 --sorted_result
91 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
92 DEALLOCATE PREPARE stmt5;
93 --sorted_result
94 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
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 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
106 SET @a=0;
107 SET @b=1.0;
108 EXECUTE stmt5 USING @a,@b;
109 SET @a=1.0;
110 SET @a=0;
111 EXECUTE stmt5 USING @a,@b;
112 SET @a=1.2345;
113 SET @a=3.5432;
114 EXECUTE stmt5 USING @a,@b;
115 SET @a=-9.0;
116 SET @a=-9.1;
117 EXECUTE stmt5 USING @a,@b;
118 SET @a=-9.12345;
119 SET @a=-8.54321;
120 EXECUTE stmt5 USING @a,@b;
121 --sorted_result
122 SELECT * FROM t5;
123 --sorted_result
124 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
125 --sorted_result
126 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
127 --sorted_result
128 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
129 DEALLOCATE PREPARE stmt5;
130 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
131 SET @a=0;
132 EXECUTE stmt5 USING @a;
133 SET @a=1.0;
134 EXECUTE stmt5 USING @a;
135 SET @a=1.2345;
136 EXECUTE stmt5 USING @a;
137 SET @a=-9.0;
138 EXECUTE stmt5 USING @a;
139 SET @a=-9.12345;
140 EXECUTE stmt5 USING @a;
141 --sorted_result
142 SELECT * FROM t5;
143 --sorted_result
144 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
145 --sorted_result
146 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
147 --sorted_result
148 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
149 DEALLOCATE PREPARE stmt5;
150 DROP TABLE t5;
151 CREATE TABLE t4(c1 DEC(1,0) NOT NULL);
152 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
153 SET @a=0;
154 EXECUTE stmt4 USING @a;
155 SET @a=1.0;
156 EXECUTE stmt4 USING @a;
157 SET @a=-9.0;
158 EXECUTE stmt4 USING @a;
159 DEALLOCATE PREPARE stmt4;
160 --sorted_result
161 SELECT * FROM t4;
162 --sorted_result
163 SELECT COUNT(c1) AS total_rows FROM t4;
164 --sorted_result
165 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
166 --sorted_result
167 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
168 --sorted_result
169 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
170 --sorted_result
171 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
172 SET @a=0;
173 EXECUTE stmt4 USING @a;
174 SET @a=1.0;
175 EXECUTE stmt4 USING @a;
176 SET @a=-9.0;
177 EXECUTE stmt4 USING @a;
178 DEALLOCATE PREPARE stmt4;
179 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
180 SET @a=0;
181 SET @b=1.0;
182 EXECUTE stmt4 USING @a,@b;
183 SET @a=1.0;
184 SET @b=0;
185 EXECUTE stmt4 USING @a,@b;
186 SET @a=-9.0;
187 SET @b=7.0;
188 EXECUTE stmt4 USING @a,@b;
189 DEALLOCATE PREPARE stmt4;
190 --sorted_result
191 SELECT * FROM t4;
192 --sorted_result
193 SELECT COUNT(c1) AS total_rows FROM t4;
194 --sorted_result
195 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
196 --sorted_result
197 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
198 --sorted_result
199 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
200 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
201 SET @a=0;
202 EXECUTE stmt4 USING @a;
203 SET @a=1.0;
204 EXECUTE stmt4 USING @a;
205 SET @a=-9.0;
206 EXECUTE stmt4 USING @a;
207 DEALLOCATE PREPARE stmt4;
208 --sorted_result
209 SELECT * FROM t4;
210 --sorted_result
211 SELECT COUNT(c1) AS total_rows FROM t4;
212 --sorted_result
213 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
214 --sorted_result
215 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
216 --sorted_result
217 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
218 DROP TABLE t4;
219 CREATE TABLE t5(c1 DEC(5,4) NOT NULL);
220 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
221 SET @a=0;
222 EXECUTE stmt5 USING @a;
223 SET @a=1.0;
224 EXECUTE stmt5 USING @a;
225 SET @a=1.2345;
226 EXECUTE stmt5 USING @a;
227 SET @a=-9.0;
228 EXECUTE stmt5 USING @a;
229 SET @a=-9.12345;
230 EXECUTE stmt5 USING @a;
231 --sorted_result
232 SELECT * FROM t5;
233 --sorted_result
234 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
235 --sorted_result
236 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
237 --sorted_result
238 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
239 DEALLOCATE PREPARE stmt5;
240 --sorted_result
241 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
242 SET @a=0;
243 EXECUTE stmt5 USING @a;
244 SET @a=1.0;
245 EXECUTE stmt5 USING @a;
246 SET @a=1.2345;
247 EXECUTE stmt5 USING @a;
248 SET @a=-9.0;
249 EXECUTE stmt5 USING @a;
250 SET @a=-9.12345;
251 EXECUTE stmt5 USING @a;
252 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
253 SET @a=0;
254 SET @b=1.0;
255 EXECUTE stmt5 USING @a,@b;
256 SET @a=1.0;
257 SET @a=0;
258 EXECUTE stmt5 USING @a,@b;
259 SET @a=1.2345;
260 SET @a=3.5432;
261 EXECUTE stmt5 USING @a,@b;
262 SET @a=-9.0;
263 SET @a=-9.1;
264 EXECUTE stmt5 USING @a,@b;
265 SET @a=-9.12345;
266 SET @a=-8.54321;
267 EXECUTE stmt5 USING @a,@b;
268 --sorted_result
269 SELECT * FROM t5;
270 --sorted_result
271 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
272 --sorted_result
273 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
274 --sorted_result
275 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
276 DEALLOCATE PREPARE stmt5;
277 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
278 SET @a=0;
279 EXECUTE stmt5 USING @a;
280 SET @a=1.0;
281 EXECUTE stmt5 USING @a;
282 SET @a=1.2345;
283 EXECUTE stmt5 USING @a;
284 SET @a=-9.0;
285 EXECUTE stmt5 USING @a;
286 SET @a=-9.12345;
287 EXECUTE stmt5 USING @a;
288 --sorted_result
289 SELECT * FROM t5;
290 --sorted_result
291 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
292 --sorted_result
293 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
294 --sorted_result
295 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
296 DEALLOCATE PREPARE stmt5;
297 DROP TABLE t5;
298 CREATE TABLE t4(c1 FIXED(1,0) NOT NULL);
299 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
300 SET @a=0;
301 EXECUTE stmt4 USING @a;
302 SET @a=1.0;
303 EXECUTE stmt4 USING @a;
304 SET @a=-9.0;
305 EXECUTE stmt4 USING @a;
306 DEALLOCATE PREPARE stmt4;
307 --sorted_result
308 SELECT * FROM t4;
309 --sorted_result
310 SELECT COUNT(c1) AS total_rows FROM t4;
311 --sorted_result
312 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
313 --sorted_result
314 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
315 --sorted_result
316 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
317 --sorted_result
318 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
319 SET @a=0;
320 EXECUTE stmt4 USING @a;
321 SET @a=1.0;
322 EXECUTE stmt4 USING @a;
323 SET @a=-9.0;
324 EXECUTE stmt4 USING @a;
325 DEALLOCATE PREPARE stmt4;
326 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
327 SET @a=0;
328 SET @b=1.0;
329 EXECUTE stmt4 USING @a,@b;
330 SET @a=1.0;
331 SET @b=0;
332 EXECUTE stmt4 USING @a,@b;
333 SET @a=-9.0;
334 SET @b=7.0;
335 EXECUTE stmt4 USING @a,@b;
336 DEALLOCATE PREPARE stmt4;
337 --sorted_result
338 SELECT * FROM t4;
339 --sorted_result
340 SELECT COUNT(c1) AS total_rows FROM t4;
341 --sorted_result
342 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
343 --sorted_result
344 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
345 --sorted_result
346 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
347 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
348 SET @a=0;
349 EXECUTE stmt4 USING @a;
350 SET @a=1.0;
351 EXECUTE stmt4 USING @a;
352 SET @a=-9.0;
353 EXECUTE stmt4 USING @a;
354 DEALLOCATE PREPARE stmt4;
355 --sorted_result
356 SELECT * FROM t4;
357 --sorted_result
358 SELECT COUNT(c1) AS total_rows FROM t4;
359 --sorted_result
360 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
361 --sorted_result
362 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
363 --sorted_result
364 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
365 DROP TABLE t4;
366 CREATE TABLE t5(c1 FIXED(5,4) NOT NULL);
367 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
368 SET @a=0;
369 EXECUTE stmt5 USING @a;
370 SET @a=1.0;
371 EXECUTE stmt5 USING @a;
372 SET @a=1.2345;
373 EXECUTE stmt5 USING @a;
374 SET @a=-9.0;
375 EXECUTE stmt5 USING @a;
376 SET @a=-9.12345;
377 EXECUTE stmt5 USING @a;
378 --sorted_result
379 SELECT * FROM t5;
380 --sorted_result
381 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
382 --sorted_result
383 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
384 --sorted_result
385 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
386 DEALLOCATE PREPARE stmt5;
387 --sorted_result
388 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
389 SET @a=0;
390 EXECUTE stmt5 USING @a;
391 SET @a=1.0;
392 EXECUTE stmt5 USING @a;
393 SET @a=1.2345;
394 EXECUTE stmt5 USING @a;
395 SET @a=-9.0;
396 EXECUTE stmt5 USING @a;
397 SET @a=-9.12345;
398 EXECUTE stmt5 USING @a;
399 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
400 SET @a=0;
401 SET @b=1.0;
402 EXECUTE stmt5 USING @a,@b;
403 SET @a=1.0;
404 SET @a=0;
405 EXECUTE stmt5 USING @a,@b;
406 SET @a=1.2345;
407 SET @a=3.5432;
408 EXECUTE stmt5 USING @a,@b;
409 SET @a=-9.0;
410 SET @a=-9.1;
411 EXECUTE stmt5 USING @a,@b;
412 SET @a=-9.12345;
413 SET @a=-8.54321;
414 EXECUTE stmt5 USING @a,@b;
415 --sorted_result
416 SELECT * FROM t5;
417 --sorted_result
418 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
419 --sorted_result
420 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
421 --sorted_result
422 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
423 DEALLOCATE PREPARE stmt5;
424 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
425 SET @a=0;
426 EXECUTE stmt5 USING @a;
427 SET @a=1.0;
428 EXECUTE stmt5 USING @a;
429 SET @a=1.2345;
430 EXECUTE stmt5 USING @a;
431 SET @a=-9.0;
432 EXECUTE stmt5 USING @a;
433 SET @a=-9.12345;
434 EXECUTE stmt5 USING @a;
435 --sorted_result
436 SELECT * FROM t5;
437 --sorted_result
438 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
439 --sorted_result
440 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
441 --sorted_result
442 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
443 DEALLOCATE PREPARE stmt5;
444 DROP TABLE t5;
445 CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL);
446 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
447 SET @a=0;
448 EXECUTE stmt4 USING @a;
449 SET @a=1.0;
450 EXECUTE stmt4 USING @a;
451 SET @a=-9.0;
452 EXECUTE stmt4 USING @a;
453 DEALLOCATE PREPARE stmt4;
454 --sorted_result
455 SELECT * FROM t4;
456 --sorted_result
457 SELECT COUNT(c1) AS total_rows FROM t4;
458 --sorted_result
459 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
460 --sorted_result
461 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
462 --sorted_result
463 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
464 --sorted_result
465 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
466 SET @a=0;
467 EXECUTE stmt4 USING @a;
468 SET @a=1.0;
469 EXECUTE stmt4 USING @a;
470 SET @a=-9.0;
471 EXECUTE stmt4 USING @a;
472 DEALLOCATE PREPARE stmt4;
473 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
474 SET @a=0;
475 SET @b=1.0;
476 EXECUTE stmt4 USING @a,@b;
477 SET @a=1.0;
478 SET @b=0;
479 EXECUTE stmt4 USING @a,@b;
480 SET @a=-9.0;
481 SET @b=7.0;
482 EXECUTE stmt4 USING @a,@b;
483 DEALLOCATE PREPARE stmt4;
484 --sorted_result
485 SELECT * FROM t4;
486 --sorted_result
487 SELECT COUNT(c1) AS total_rows FROM t4;
488 --sorted_result
489 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
490 --sorted_result
491 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
492 --sorted_result
493 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
494 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
495 SET @a=0;
496 EXECUTE stmt4 USING @a;
497 SET @a=1.0;
498 EXECUTE stmt4 USING @a;
499 SET @a=-9.0;
500 EXECUTE stmt4 USING @a;
501 DEALLOCATE PREPARE stmt4;
502 --sorted_result
503 SELECT * FROM t4;
504 --sorted_result
505 SELECT COUNT(c1) AS total_rows FROM t4;
506 --sorted_result
507 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
508 --sorted_result
509 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
510 --sorted_result
511 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
512 DROP TABLE t4;
513 CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL);
514 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
515 SET @a=0;
516 EXECUTE stmt5 USING @a;
517 SET @a=1.0;
518 EXECUTE stmt5 USING @a;
519 SET @a=1.2345;
520 EXECUTE stmt5 USING @a;
521 SET @a=-9.0;
522 EXECUTE stmt5 USING @a;
523 SET @a=-9.12345;
524 EXECUTE stmt5 USING @a;
525 --sorted_result
526 SELECT * FROM t5;
527 --sorted_result
528 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
529 --sorted_result
530 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
531 --sorted_result
532 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
533 DEALLOCATE PREPARE stmt5;
534 --sorted_result
535 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
536 SET @a=0;
537 EXECUTE stmt5 USING @a;
538 SET @a=1.0;
539 EXECUTE stmt5 USING @a;
540 SET @a=1.2345;
541 EXECUTE stmt5 USING @a;
542 SET @a=-9.0;
543 EXECUTE stmt5 USING @a;
544 SET @a=-9.12345;
545 EXECUTE stmt5 USING @a;
546 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
547 SET @a=0;
548 SET @b=1.0;
549 EXECUTE stmt5 USING @a,@b;
550 SET @a=1.0;
551 SET @a=0;
552 EXECUTE stmt5 USING @a,@b;
553 SET @a=1.2345;
554 SET @a=3.5432;
555 EXECUTE stmt5 USING @a,@b;
556 SET @a=-9.0;
557 SET @a=-9.1;
558 EXECUTE stmt5 USING @a,@b;
559 SET @a=-9.12345;
560 SET @a=-8.54321;
561 EXECUTE stmt5 USING @a,@b;
562 --sorted_result
563 SELECT * FROM t5;
564 --sorted_result
565 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
566 --sorted_result
567 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
568 --sorted_result
569 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
570 DEALLOCATE PREPARE stmt5;
571 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
572 SET @a=0;
573 EXECUTE stmt5 USING @a;
574 SET @a=1.0;
575 EXECUTE stmt5 USING @a;
576 SET @a=1.2345;
577 EXECUTE stmt5 USING @a;
578 SET @a=-9.0;
579 EXECUTE stmt5 USING @a;
580 SET @a=-9.12345;
581 EXECUTE stmt5 USING @a;
582 --sorted_result
583 SELECT * FROM t5;
584 --sorted_result
585 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
586 --sorted_result
587 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
588 --sorted_result
589 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
590 DEALLOCATE PREPARE stmt5;
591 DROP TABLE t5;
592 CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL);
593 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
594 SET @a=0;
595 EXECUTE stmt4 USING @a;
596 SET @a=1.0;
597 EXECUTE stmt4 USING @a;
598 SET @a=-9.0;
599 EXECUTE stmt4 USING @a;
600 DEALLOCATE PREPARE stmt4;
601 --sorted_result
602 SELECT * FROM t4;
603 --sorted_result
604 SELECT COUNT(c1) AS total_rows FROM t4;
605 --sorted_result
606 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
607 --sorted_result
608 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
609 --sorted_result
610 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
611 --sorted_result
612 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
613 SET @a=0;
614 EXECUTE stmt4 USING @a;
615 SET @a=1.0;
616 EXECUTE stmt4 USING @a;
617 SET @a=-9.0;
618 EXECUTE stmt4 USING @a;
619 DEALLOCATE PREPARE stmt4;
620 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
621 SET @a=0;
622 SET @b=1.0;
623 EXECUTE stmt4 USING @a,@b;
624 SET @a=1.0;
625 SET @b=0;
626 EXECUTE stmt4 USING @a,@b;
627 SET @a=-9.0;
628 SET @b=7.0;
629 EXECUTE stmt4 USING @a,@b;
630 DEALLOCATE PREPARE stmt4;
631 --sorted_result
632 SELECT * FROM t4;
633 --sorted_result
634 SELECT COUNT(c1) AS total_rows FROM t4;
635 --sorted_result
636 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
637 --sorted_result
638 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
639 --sorted_result
640 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
641 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
642 SET @a=0;
643 EXECUTE stmt4 USING @a;
644 SET @a=1.0;
645 EXECUTE stmt4 USING @a;
646 SET @a=-9.0;
647 EXECUTE stmt4 USING @a;
648 DEALLOCATE PREPARE stmt4;
649 --sorted_result
650 SELECT * FROM t4;
651 --sorted_result
652 SELECT COUNT(c1) AS total_rows FROM t4;
653 --sorted_result
654 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
655 --sorted_result
656 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
657 --sorted_result
658 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
659 DROP TABLE t4;
660 CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL);
661 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
662 SET @a=0;
663 EXECUTE stmt5 USING @a;
664 SET @a=1.0;
665 EXECUTE stmt5 USING @a;
666 SET @a=1.2345;
667 EXECUTE stmt5 USING @a;
668 SET @a=-9.0;
669 EXECUTE stmt5 USING @a;
670 SET @a=-9.12345;
671 EXECUTE stmt5 USING @a;
672 --sorted_result
673 SELECT * FROM t5;
674 --sorted_result
675 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
676 --sorted_result
677 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
678 --sorted_result
679 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
680 DEALLOCATE PREPARE stmt5;
681 --sorted_result
682 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
683 SET @a=0;
684 EXECUTE stmt5 USING @a;
685 SET @a=1.0;
686 EXECUTE stmt5 USING @a;
687 SET @a=1.2345;
688 EXECUTE stmt5 USING @a;
689 SET @a=-9.0;
690 EXECUTE stmt5 USING @a;
691 SET @a=-9.12345;
692 EXECUTE stmt5 USING @a;
693 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
694 SET @a=0;
695 SET @b=1.0;
696 EXECUTE stmt5 USING @a,@b;
697 SET @a=1.0;
698 SET @a=0;
699 EXECUTE stmt5 USING @a,@b;
700 SET @a=1.2345;
701 SET @a=3.5432;
702 EXECUTE stmt5 USING @a,@b;
703 SET @a=-9.0;
704 SET @a=-9.1;
705 EXECUTE stmt5 USING @a,@b;
706 SET @a=-9.12345;
707 SET @a=-8.54321;
708 EXECUTE stmt5 USING @a,@b;
709 --sorted_result
710 SELECT * FROM t5;
711 --sorted_result
712 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
713 --sorted_result
714 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
715 --sorted_result
716 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
717 DEALLOCATE PREPARE stmt5;
718 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
719 SET @a=0;
720 EXECUTE stmt5 USING @a;
721 SET @a=1.0;
722 EXECUTE stmt5 USING @a;
723 SET @a=1.2345;
724 EXECUTE stmt5 USING @a;
725 SET @a=-9.0;
726 EXECUTE stmt5 USING @a;
727 SET @a=-9.12345;
728 EXECUTE stmt5 USING @a;
729 --sorted_result
730 SELECT * FROM t5;
731 --sorted_result
732 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
733 --sorted_result
734 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
735 --sorted_result
736 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
737 DEALLOCATE PREPARE stmt5;
738 DROP TABLE t5;
739 CREATE TABLE t4(c1 REAL(1,0) NOT NULL);
740 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
741 SET @a=0;
742 EXECUTE stmt4 USING @a;
743 SET @a=1.0;
744 EXECUTE stmt4 USING @a;
745 SET @a=-9.0;
746 EXECUTE stmt4 USING @a;
747 DEALLOCATE PREPARE stmt4;
748 --sorted_result
749 SELECT * FROM t4;
750 --sorted_result
751 SELECT COUNT(c1) AS total_rows FROM t4;
752 --sorted_result
753 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
754 --sorted_result
755 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
756 --sorted_result
757 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
758 --sorted_result
759 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
760 SET @a=0;
761 EXECUTE stmt4 USING @a;
762 SET @a=1.0;
763 EXECUTE stmt4 USING @a;
764 SET @a=-9.0;
765 EXECUTE stmt4 USING @a;
766 DEALLOCATE PREPARE stmt4;
767 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
768 SET @a=0;
769 SET @b=1.0;
770 EXECUTE stmt4 USING @a,@b;
771 SET @a=1.0;
772 SET @b=0;
773 EXECUTE stmt4 USING @a,@b;
774 SET @a=-9.0;
775 SET @b=7.0;
776 EXECUTE stmt4 USING @a,@b;
777 DEALLOCATE PREPARE stmt4;
778 --sorted_result
779 SELECT * FROM t4;
780 --sorted_result
781 SELECT COUNT(c1) AS total_rows FROM t4;
782 --sorted_result
783 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
784 --sorted_result
785 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
786 --sorted_result
787 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
788 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
789 SET @a=0;
790 EXECUTE stmt4 USING @a;
791 SET @a=1.0;
792 EXECUTE stmt4 USING @a;
793 SET @a=-9.0;
794 EXECUTE stmt4 USING @a;
795 DEALLOCATE PREPARE stmt4;
796 --sorted_result
797 SELECT * FROM t4;
798 --sorted_result
799 SELECT COUNT(c1) AS total_rows FROM t4;
800 --sorted_result
801 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
802 --sorted_result
803 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
804 --sorted_result
805 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
806 DROP TABLE t4;
807 CREATE TABLE t5(c1 REAL(5,4) NOT NULL);
808 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
809 SET @a=0;
810 EXECUTE stmt5 USING @a;
811 SET @a=1.0;
812 EXECUTE stmt5 USING @a;
813 SET @a=1.2345;
814 EXECUTE stmt5 USING @a;
815 SET @a=-9.0;
816 EXECUTE stmt5 USING @a;
817 SET @a=-9.12345;
818 EXECUTE stmt5 USING @a;
819 --sorted_result
820 SELECT * FROM t5;
821 --sorted_result
822 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
823 --sorted_result
824 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
825 --sorted_result
826 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
827 DEALLOCATE PREPARE stmt5;
828 --sorted_result
829 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
830 SET @a=0;
831 EXECUTE stmt5 USING @a;
832 SET @a=1.0;
833 EXECUTE stmt5 USING @a;
834 SET @a=1.2345;
835 EXECUTE stmt5 USING @a;
836 SET @a=-9.0;
837 EXECUTE stmt5 USING @a;
838 SET @a=-9.12345;
839 EXECUTE stmt5 USING @a;
840 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
841 SET @a=0;
842 SET @b=1.0;
843 EXECUTE stmt5 USING @a,@b;
844 SET @a=1.0;
845 SET @a=0;
846 EXECUTE stmt5 USING @a,@b;
847 SET @a=1.2345;
848 SET @a=3.5432;
849 EXECUTE stmt5 USING @a,@b;
850 SET @a=-9.0;
851 SET @a=-9.1;
852 EXECUTE stmt5 USING @a,@b;
853 SET @a=-9.12345;
854 SET @a=-8.54321;
855 EXECUTE stmt5 USING @a,@b;
856 --sorted_result
857 SELECT * FROM t5;
858 --sorted_result
859 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
860 --sorted_result
861 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
862 --sorted_result
863 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
864 DEALLOCATE PREPARE stmt5;
865 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
866 SET @a=0;
867 EXECUTE stmt5 USING @a;
868 SET @a=1.0;
869 EXECUTE stmt5 USING @a;
870 SET @a=1.2345;
871 EXECUTE stmt5 USING @a;
872 SET @a=-9.0;
873 EXECUTE stmt5 USING @a;
874 SET @a=-9.12345;
875 EXECUTE stmt5 USING @a;
876 --sorted_result
877 SELECT * FROM t5;
878 --sorted_result
879 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
880 --sorted_result
881 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
882 --sorted_result
883 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
884 DEALLOCATE PREPARE stmt5;
885 DROP TABLE t5;
886 CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL);
887 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
888 SET @a=0;
889 EXECUTE stmt4 USING @a;
890 SET @a=1.0;
891 EXECUTE stmt4 USING @a;
892 SET @a=-9.0;
893 EXECUTE stmt4 USING @a;
894 DEALLOCATE PREPARE stmt4;
895 --sorted_result
896 SELECT * FROM t4;
897 --sorted_result
898 SELECT COUNT(c1) AS total_rows FROM t4;
899 --sorted_result
900 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
901 --sorted_result
902 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
903 --sorted_result
904 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
905 --sorted_result
906 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
907 SET @a=0;
908 EXECUTE stmt4 USING @a;
909 SET @a=1.0;
910 EXECUTE stmt4 USING @a;
911 SET @a=-9.0;
912 EXECUTE stmt4 USING @a;
913 DEALLOCATE PREPARE stmt4;
914 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
915 SET @a=0;
916 SET @b=1.0;
917 EXECUTE stmt4 USING @a,@b;
918 SET @a=1.0;
919 SET @b=0;
920 EXECUTE stmt4 USING @a,@b;
921 SET @a=-9.0;
922 SET @b=7.0;
923 EXECUTE stmt4 USING @a,@b;
924 DEALLOCATE PREPARE stmt4;
925 --sorted_result
926 SELECT * FROM t4;
927 --sorted_result
928 SELECT COUNT(c1) AS total_rows FROM t4;
929 --sorted_result
930 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
931 --sorted_result
932 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
933 --sorted_result
934 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
935 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
936 SET @a=0;
937 EXECUTE stmt4 USING @a;
938 SET @a=1.0;
939 EXECUTE stmt4 USING @a;
940 SET @a=-9.0;
941 EXECUTE stmt4 USING @a;
942 DEALLOCATE PREPARE stmt4;
943 --sorted_result
944 SELECT * FROM t4;
945 --sorted_result
946 SELECT COUNT(c1) AS total_rows FROM t4;
947 --sorted_result
948 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
949 --sorted_result
950 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
951 --sorted_result
952 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
953 DROP TABLE t4;
954 CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL);
955 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
956 SET @a=0;
957 EXECUTE stmt5 USING @a;
958 SET @a=1.0;
959 EXECUTE stmt5 USING @a;
960 SET @a=1.2345;
961 EXECUTE stmt5 USING @a;
962 SET @a=-9.0;
963 EXECUTE stmt5 USING @a;
964 SET @a=-9.12345;
965 EXECUTE stmt5 USING @a;
966 --sorted_result
967 SELECT * FROM t5;
968 --sorted_result
969 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
970 --sorted_result
971 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
972 --sorted_result
973 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
974 DEALLOCATE PREPARE stmt5;
975 --sorted_result
976 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
977 SET @a=0;
978 EXECUTE stmt5 USING @a;
979 SET @a=1.0;
980 EXECUTE stmt5 USING @a;
981 SET @a=1.2345;
982 EXECUTE stmt5 USING @a;
983 SET @a=-9.0;
984 EXECUTE stmt5 USING @a;
985 SET @a=-9.12345;
986 EXECUTE stmt5 USING @a;
987 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
988 SET @a=0;
989 SET @b=1.0;
990 EXECUTE stmt5 USING @a,@b;
991 SET @a=1.0;
992 SET @a=0;
993 EXECUTE stmt5 USING @a,@b;
994 SET @a=1.2345;
995 SET @a=3.5432;
996 EXECUTE stmt5 USING @a,@b;
997 SET @a=-9.0;
998 SET @a=-9.1;
999 EXECUTE stmt5 USING @a,@b;
1000 SET @a=-9.12345;
1001 SET @a=-8.54321;
1002 EXECUTE stmt5 USING @a,@b;
1003 --sorted_result
1004 SELECT * FROM t5;
1005 --sorted_result
1006 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1007 --sorted_result
1008 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1009 --sorted_result
1010 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1011 DEALLOCATE PREPARE stmt5;
1012 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1013 SET @a=0;
1014 EXECUTE stmt5 USING @a;
1015 SET @a=1.0;
1016 EXECUTE stmt5 USING @a;
1017 SET @a=1.2345;
1018 EXECUTE stmt5 USING @a;
1019 SET @a=-9.0;
1020 EXECUTE stmt5 USING @a;
1021 SET @a=-9.12345;
1022 EXECUTE stmt5 USING @a;
1023 --sorted_result
1024 SELECT * FROM t5;
1025 --sorted_result
1026 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1027 --sorted_result
1028 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1029 --sorted_result
1030 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1031 DEALLOCATE PREPARE stmt5;
1032 DROP TABLE t5;
1033 CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL);
1034 PREPARE stmt4 FROM 'INSERT INTO t4 (c1) VALUES(?)';
1035 SET @a=0;
1036 EXECUTE stmt4 USING @a;
1037 SET @a=1.0;
1038 EXECUTE stmt4 USING @a;
1039 SET @a=-9.0;
1040 EXECUTE stmt4 USING @a;
1041 DEALLOCATE PREPARE stmt4;
1042 --sorted_result
1043 SELECT * FROM t4;
1044 --sorted_result
1045 SELECT COUNT(c1) AS total_rows FROM t4;
1046 --sorted_result
1047 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1048 --sorted_result
1049 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1050 --sorted_result
1051 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1052 --sorted_result
1053 PREPARE stmt4 FROM 'SELECT * FROM t4 WHERE c1 = ?';
1054 SET @a=0;
1055 EXECUTE stmt4 USING @a;
1056 SET @a=1.0;
1057 EXECUTE stmt4 USING @a;
1058 SET @a=-9.0;
1059 EXECUTE stmt4 USING @a;
1060 DEALLOCATE PREPARE stmt4;
1061 PREPARE stmt4 FROM 'UPDATE t4 SET c1 = ? WHERE c1 = ?';
1062 SET @a=0;
1063 SET @b=1.0;
1064 EXECUTE stmt4 USING @a,@b;
1065 SET @a=1.0;
1066 SET @b=0;
1067 EXECUTE stmt4 USING @a,@b;
1068 SET @a=-9.0;
1069 SET @b=7.0;
1070 EXECUTE stmt4 USING @a,@b;
1071 DEALLOCATE PREPARE stmt4;
1072 --sorted_result
1073 SELECT * FROM t4;
1074 --sorted_result
1075 SELECT COUNT(c1) AS total_rows FROM t4;
1076 --sorted_result
1077 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1078 --sorted_result
1079 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1080 --sorted_result
1081 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1082 PREPARE stmt4 FROM 'DELETE FROM t4 WHERE c1 = ?';
1083 SET @a=0;
1084 EXECUTE stmt4 USING @a;
1085 SET @a=1.0;
1086 EXECUTE stmt4 USING @a;
1087 SET @a=-9.0;
1088 EXECUTE stmt4 USING @a;
1089 DEALLOCATE PREPARE stmt4;
1090 --sorted_result
1091 SELECT * FROM t4;
1092 --sorted_result
1093 SELECT COUNT(c1) AS total_rows FROM t4;
1094 --sorted_result
1095 SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0;
1096 --sorted_result
1097 SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0;
1098 --sorted_result
1099 SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0;
1100 DROP TABLE t4;
1101 CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL);
1102 PREPARE stmt5 FROM 'INSERT INTO t5 (c1) VALUES(?)';
1103 SET @a=0;
1104 EXECUTE stmt5 USING @a;
1105 SET @a=1.0;
1106 EXECUTE stmt5 USING @a;
1107 SET @a=1.2345;
1108 EXECUTE stmt5 USING @a;
1109 SET @a=-9.0;
1110 EXECUTE stmt5 USING @a;
1111 SET @a=-9.12345;
1112 EXECUTE stmt5 USING @a;
1113 --sorted_result
1114 SELECT * FROM t5;
1115 --sorted_result
1116 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1117 --sorted_result
1118 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1119 --sorted_result
1120 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1121 DEALLOCATE PREPARE stmt5;
1122 --sorted_result
1123 PREPARE stmt5 FROM 'SELECT * FROM t5 WHERE c1 = ?';
1124 SET @a=0;
1125 EXECUTE stmt5 USING @a;
1126 SET @a=1.0;
1127 EXECUTE stmt5 USING @a;
1128 SET @a=1.2345;
1129 EXECUTE stmt5 USING @a;
1130 SET @a=-9.0;
1131 EXECUTE stmt5 USING @a;
1132 SET @a=-9.12345;
1133 EXECUTE stmt5 USING @a;
1134 PREPARE stmt5 FROM 'UPDATE t5 SET c1 = ? WHERE c1 = ?';
1135 SET @a=0;
1136 SET @b=1.0;
1137 EXECUTE stmt5 USING @a,@b;
1138 SET @a=1.0;
1139 SET @a=0;
1140 EXECUTE stmt5 USING @a,@b;
1141 SET @a=1.2345;
1142 SET @a=3.5432;
1143 EXECUTE stmt5 USING @a,@b;
1144 SET @a=-9.0;
1145 SET @a=-9.1;
1146 EXECUTE stmt5 USING @a,@b;
1147 SET @a=-9.12345;
1148 SET @a=-8.54321;
1149 EXECUTE stmt5 USING @a,@b;
1150 --sorted_result
1151 SELECT * FROM t5;
1152 --sorted_result
1153 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1154 --sorted_result
1155 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1156 --sorted_result
1157 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1158 DEALLOCATE PREPARE stmt5;
1159 PREPARE stmt5 FROM 'DELETE FROM t5 WHERE c1 = ?';
1160 SET @a=0;
1161 EXECUTE stmt5 USING @a;
1162 SET @a=1.0;
1163 EXECUTE stmt5 USING @a;
1164 SET @a=1.2345;
1165 EXECUTE stmt5 USING @a;
1166 SET @a=-9.0;
1167 EXECUTE stmt5 USING @a;
1168 SET @a=-9.12345;
1169 EXECUTE stmt5 USING @a;
1170 --sorted_result
1171 SELECT * FROM t5;
1172 --sorted_result
1173 SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0;
1174 --sorted_result
1175 SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0;
1176 --sorted_result
1177 SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0;
1178 DEALLOCATE PREPARE stmt5;
1179 DROP TABLE t5;
1180