From: Dan Nelson
Date: July 18 2005 5:27pm
Subject: Re: Different versions differnet results
List-Archive: http://lists.mysql.com/mysql/186654
Message-Id: <20050718172718.GD20180@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 18), shantanu oak said:
> I am getting two different results for the same set of commands on
> two different versions of MySQL. Can anyone explain what the issue
> is?
> 
> CREATE TABLE `testdecimal` (
> `rate` decimal(7,4) NOT NULL default '0.0000'
> ) ENGINE=MyISAM; 
> 
> INSERT INTO testdecimal SET rate=1468;
> 
> select * from testdecimal;
> _____
> 
> version 4.1.12
> 1468.0000
> 
> version 5.0
> 999.9999


I think the DECIMAL type was changed to be more standard-compliant, and
(7,4) now means "7 total digits, 4 of them to the right of the decimal
point".  Your number doesn't fit, so the maximum value was inserted
instead.

http://dev.mysql.com/doc/mysql/en/numeric-types.html

-- 
	Dan Nelson
	dnelson@stripped