List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 18 2005 5:27pm
Subject:Re: Different versions differnet results
View as plain text  
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
Thread
Different versions differnet resultsshantanu oak18 Jul
  • Re: Different versions differnet resultsDan Nelson18 Jul
  • RE: Different versions differnet resultsEdwin Cruz18 Jul
  • Re: Different versions differnet resultsSGreen18 Jul