Hi all,
my environment: WindowsNT4 with SP6, mysql4.0.15-max-nt
I tried the following only for fun:
mysql> CREATE TABLE t2 (a int, b float(24,99)); -->this should give me
an error but it doesn't!
Query OK, 0 rows affected (0.02 sec)
mysql> show tables;
+---------------+
| Tables_in_pb1 |
+---------------+
| t1 |
| t2 |
+---------------+
2 rows in set (0.01 sec)
mysql> describe t2;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| a | int(11) | YES | | NULL | |
| b | float(31,30) | YES | | NULL | |
-->this conversion is also very strange
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.01 sec)
mysql> insert into t2 values (1, 1.234567890);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t2;
+------+----------------------------------+
| a | b |
+------+----------------------------------+
| 1 | 1.234567880630493200000000000000 |
+------+----------------------------------+
1 row in set (0.00 sec)
Where does this number come from? I haven't inserted it and further
calculations with this would lead to incorrekt results!
Regards
Peter Bernhardt
Hessisches Statistisches Landesamt
Rheinstraße 35/37
65185 Wiesbaden
Telefon: 0611 3802-165
Telefax: 0611 3802-190
Internet: http://www.hsl.de
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.