a struggle with float type display and width

[Martin D. Foster]

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]