Different versions differnet results

2005-07-18 Thread shantanu oak
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.' ) ENGINE=MyISAM; INSERT INTO testdecimal SET rate=1468; select * from

Re: Different versions differnet results

2005-07-18 Thread Dan Nelson
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.' ) ENGINE=MyISAM; INSERT

RE: Different versions differnet results

2005-07-18 Thread Edwin Cruz
: Different versions differnet results 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.' ) ENGINE=MyISAM; INSERT INTO testdecimal SET

Re: Different versions differnet results

2005-07-18 Thread SGreen
shantanu oak [EMAIL PROTECTED] wrote on 07/18/2005 01:17:57 PM: 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.' )