I searched some more and then I found .... Bug # 10897 - FLOAT and DOUBLE obeying precision and scale. No documentation.
http://bugs.mysql.com/bug.php?id=10897 Regards, Martin. > > Hi, > > I've recently changed MySQL versions and I am puzzled by the difference in > display of float values. > > CREATE TABLE test ( > id int unsigned NOT NULL auto_increment, > val1 float default NULL, > val2 float(3,3) default NULL, > val3 float(5,3) default NULL, > val4 float(10,6) default NULL, > PRIMARY KEY (id) > ) TYPE=MyISAM; > > INSERT INTO test VALUES (1,36705.586,36705.586,36705.586,36705.586); > > select version(); > > select * from test; > > drop table test; > > > > === OUTPUT 1 ==== > mysql> select version(); > +-----------------+ > | version() | > +-----------------+ > | 4.0.16-standard | > +-----------------+ > 1 row in set (0.00 sec) > > mysql> > mysql> select * from test; > +----+---------+-----------+-----------+--------------+ > | id | val1 | val2 | val3 | val4 | > +----+---------+-----------+-----------+--------------+ > | 1 | 36705.6 | 36705.586 | 36705.586 | 36705.585938 | > +----+---------+-----------+-----------+--------------+ > 1 row in set (0.00 sec) > > > === OUTPUT 2 ==== > mysql> select version(); > +-----------+ > | version() | > +-----------+ > | 4.1.13 | > +-----------+ > 1 row in set (0.00 sec) > > mysql> > mysql> select * from test; > +----+---------+-------+--------+--------------+ > | id | val1 | val2 | val3 | val4 | > +----+---------+-------+--------+--------------+ > | 1 | 36705.6 | 9.999 | 99.999 | 10000.000000 | > +----+---------+-------+--------+--------------+ > 1 row in set (0.00 sec) > > > How is it possible that the two versions behave so differently? > > Regards, > Martin. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
