Re: INSERT is changing column value

[joe conery]

First, i must apologize, since this is turning out to be more of a db problem than a mysqlconnector problem, so I'm really in the wrong forum with this, so thanks for the help but...

Yes. The problem occurs the same. It has a problem with the thr_baseamount (value = 375000.0) and thr_countercurrency (value=-499275.0). The others appear to be correct.

If I remove the decimal portion and insert it as if it were an integer, it works fine.
if I replace with small decimal numbers, it's fine.
If I keep it as a decimal, I can't seem to have numbers => 10000.0
The query returns a warning for each bad column value, but I'm not sure how to get the warning info. I don't think mysqld was started with a .log file. Is there a query I can use to get the last warnings?

describe transhistorytable;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| thr_username | varchar(64) | YES | | NULL | |
| thr_primebroker | varchar(64) | YES | | NULL | |
| thr_counterpart | varchar(64) | YES | | NULL | |
| thr_sectype | varchar(64) | YES | | NULL | |
| thr_transid | varchar(64) | | PRI | | |
| thr_currencypair | varchar(64) | YES | | NULL | |
| thr_trademethod | varchar(64) | YES | | NULL | |
| thr_tradetype | varchar(64) | YES | | NULL | |
| thr_tradeowner | varchar(64) | YES | | NULL | |
| thr_levmult | varchar(64) | YES | | NULL | |
| thr_buysell | varchar(64) | YES | | NULL | |
| thr_baseamount | double(10,6) | YES | | NULL | |
| thr_dollarbaseamount | double(10,6) | YES | | NULL | |
| thr_countercurrency | double(10,6) | YES | | NULL | |
| thr_traderate | double(10,6) | YES | | NULL | |
| thr_tradedate | datetime | YES | | NULL | |
| thr_valuedate | datetime | YES | | NULL | |
| thr_entrydate | datetime | YES | | NULL | |
| thr_fixmessage | blob | YES | | NULL | |
| thr_status | varchar(25) | YES | | NULL | |
| thr_sendersubid | varchar(64) | YES | | NULL | |
| thr_pbfee | double(10,6) | YES | | NULL | |
+----------------------+--------------+------+-----+---------+-------+