Bug #17826 'type_decimal' fails with ps-protocol
Submitted: 1 Mar 2006 15:47 Modified: 4 Mar 2006 8:36
Reporter: Sergey Gluhov
Status: Closed
Category:Server: PS Severity:S3 (Non-critical)
Version:5.0.18 OS:Linux (Linux)
Assigned to: Sergey Gluhov Target Version:

[1 Mar 2006 15:47] Sergey Gluhov 
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 17: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 12: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 12:40] Sergey Gluhov 
Fixed in 5.0.19
[4 Mar 2006 8: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.