Bug #17826 'type_decimal' fails with ps-protocol
Submitted: 1 Mar 2006 14:47 Modified: 4 Mar 2006 7:36
Reporter: Sergei 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: Sergei Glukhov CPU Architecture:Any

[1 Mar 2006 14:47] Sergei 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] Sergei 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.