Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
Is this a known problem? Does anyone have a solution?
I'm running standard MySQL binaries on redhat linux 7.2 kernel
2.4.20-28.7smp. Help!
Cheers,
Andrew
mysql> desc table1;
+---------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+----------------+
| id | mediumint(6) | | PRI | NULL | auto_increment |
| GeoQuality | varchar(5) | YES | | NULL | |
| lon | double(7,6) | YES | MUL | NULL | |
| lat | double(7,6) | YES | | NULL | |
| GeocodeDate | date | YES | | NULL | |
| GeocodeSource | varchar(25) | YES | | NULL | |
| state | varchar(70) | YES | | NULL | |
| client_id | varchar(40) | YES | MUL | NULL | |
+---------------+--------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)
mysql> INSERT INTO table1VALUES
(8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
Query OK, 1 row affected, 1 warning (0.01 sec)
mysql> select * from table1 where id=8002\G
*************************** 1. row ***************************
id: 8002
GeoQuality: 2a
lon: -0.361080
lat: 9.999999
GeocodeDate: 2005-08-31
GeocodeSource: ES052
state: NULL
client_id: NULL
1 row in set (0.00 sec)
Mysql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
