Hello. Can you send complete test for your problem (i.e SHOW CREATE TABLE on your tables, buggy sql statement...)? On my 4.1.7 instance of MySQL everything looks fine:
mysql> desc v1; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | v | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ select * from v1; +------+ | v | +------+ | 237 | +------+ mysql> select * from v1 where v=2.37000000000000000e+002; +------+ | v | +------+ | 237 | +------+ update v1 set v=11 where v=2.37000000000000000e+002; select * from v1; +------+ | v | +------+ | 11 | +------+ >I have a query where I perform an update "where (CALL_ID = >2.37000000000000000e+002);" > >This query updates nothing, even though my "CALL_ID" column has an id of "237". > >If I change the end of this query to read: "where (CALL_ID = 237);", then the >row with >"CALL_ID=237" is updated. > >Is there a reason why the double value "2.37000000000000000e+002" is not >evaluating to >"237"? > >Regards, >-Brett Berry "Berry, Brett C" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
