Comment 4 for bug 337038
Revision history for this message
| Stewart Smith (stewart) wrote Re: [Bug 337038] Re: DECIMAL truncation is warning, not error | #4 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
On Wed, Mar 04, 2009 at 02:21:02AM -0000, Padraig O'Sullivan wrote:
> drizzle> create table t1 (
> -> f1 decimal not null default 17.49,
> -> f2 decimal not null default 17.68,
> -> f3 decimal not null default 99.2,
> -> f4 decimal not null default 99.7,
> -> f5 decimal not null default 104.49,
> -> f6 decimal not null default 199.91,
> -> f7 decimal not null default 999.9,
> -> f8 decimal not null default 9999.99);
> ERROR 1067 (42000): Invalid default value for 'f1'
> drizzle>
>
> Is this the kind of behavior we are looking for here? I wasn't sure if
> this is the right behavior since the error message doesn't mention that
> the value is invalid because it is truncated. Any thoughts?
If details are in SHOW WARNINGS then I'm double plus happy.
--
Stewart Smith