MySQL Bugs: #9527: Precision Math: Multiplying zero with a -ve number gives -ve output..

Bug #9527	Precision Math: Multiplying zero with a -ve number gives -ve output..
Submitted:	31 Mar 2005 15:07	Modified:	7 May 2005 9:55
Reporter:	Disha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.3 alpha	OS:	Windows (Windows 2003)
Assigned to:	Alexey Botchkov	CPU Architecture:	Any

Description:
When zero is multiplied with a column that comprises a -ve value, the result is a negated zero.

How to repeat:
1. delimiter //
2. Drop table if exists t111//
2. Create table t111 (f1 dec(64,30))//
3. Insert into t111 values (-2.234)//
4. Select f1*0 from t111//

ACTUAL RESULT:
+--------------------------------------+
| f1*0                                               |
+--------------------------------------+
| -0.000000000000000000000000000000 |
+--------------------------------------+
1 row in set (0.00 sec)

EXPECTED RESULT:
The result should not be NEGATIVE.

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