Bug #17826 'type_decimal' fails with ps-protocol
Submitted: 1 Mar 2006 14:47 Modified: 4 Mar 2006 7:36
Reporter: Sergey Glukhov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S3 (Non-critical)
Version:5.0.18 OS:Linux (Linux)
Assigned to: Sergey Glukhov

[1 Mar 2006 14:47] Sergey Glukhov
Description:
 'type_decimal' fails with ps-protocol:

type_decimal                   [ fail ]

Errors are (from /home/mysqldev/pb/mysql-5.0/push-aivanov@mysql.com-20060301123443.info/mysql-5.0.19-standard/mysql-test/var-ps_stm-5/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_decimal.result    Wed Mar  1 15:04:20 2006
--- r/type_decimal.reject    Wed Mar  1 16:41:14 2006
***************
*** 698,703 ****
--- 698,705 ----
 SELECT EMPNUM FROM t1 WHERE HOURS IN (SELECT HOURS FROM t1);
 EMPNUM
 E1
+ Warnings:
+ Error    1366    Incorrect decimal value: '' for column '' at row -1
 DROP TABLE t1,t2;
 create table t1 (d decimal(64,0));
 insert into t1 values (1);
------------------------------------------------------- 

How to repeat:
./mysql-test-run --ps-protocol type_decimal

Suggested fix:
ChangeSet
  1.2090 06/03/01
  Fix: 'type_decimal' fails with ps-protocol
  Do not calculate field value on first stmt execute stage
  during prepared statement execute
[2 Mar 2006 16:04] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3393
[3 Mar 2006 11:25] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3423
[3 Mar 2006 11:40] Sergey Glukhov
Fixed in 5.0.19
[4 Mar 2006 7:36] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.0.19 changelog. Closed.