Bug #22502 Updating value in DECIMAL column with same datatype causes data truncation error
Submitted: 20 Sep 2006 0:49 Modified: 20 Sep 2006 7:24
Reporter: Ben Anderson Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:3.1.13 and 5.0.3 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: truncation

[20 Sep 2006 0:49] Ben Anderson
Description:
Please see new comments (and attachments) for bug #22290. I can still reproduce the problem using your test case. Please retry your test case with sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Sorry if this is not the correct way to 're-open' an existing bug but I did not see that as a selectable option for bug #22290.

How to repeat:
See bug #22290.
[20 Sep 2006 7:24] Tonci Grgin
Ben, please set original report to "Open" state. I'm following you there.