Incorrect records getting updated with Mysql 3.23.56

[Mathew Joseph]

Hi

I am running MySql 3.23.56
I am using the MySql Connector/ODBC 3.51 to connect to the database
I am facing a strange problem for which i have been searching for a while .

When I give a update statement to update a single record ,instead of one record getting updated the majority of the records in the database are getting updated

I am listing the table structure and the 'update statement' used


**************table structure ******************************************
CREATE TABLE `rfanew` (
`rfa_id` bigint(20) NOT NULL auto_increment,
`rfa_no` varchar(45) NOT NULL default '',
`activity` int(11) default NULL,
`act_desc` text,
`ch_frm` varchar(50) default NULL,
`ch_to` varchar(50) default NULL,
`lr` varchar(15) default NULL,
`loc` text,
`ins_dt` varchar(15) default NULL,
`ins_time` varchar(15) default NULL,
`req_dt` varchar(15) default NULL,
`req_time` varchar(15) default NULL,
`valuation` int(11) default '0',
`sub_status` varchar(4) default NULL,
`ret_dt` varchar(15) default NULL,
`fin_status` varchar(4) default NULL,
`alt_rfa_no` varchar(15) default NULL,
`boq_no` varchar(100) default NULL,
`Req_by` varchar(30) default NULL,
`rem` text,
`proj_id` bigint(20) NOT NULL default '0',
`entry_type` char(1) default 'R',
`road_name` varchar(250) default NULL,
`sector` varchar(250) default NULL,
`volume_no` varchar(25) default NULL,
PRIMARY KEY (`rfa_id`)
) ;


***********************************************************************

************************update query********************************


UPDATE rfanew set fin_Status='A',alt_rfa_no='',ret_dt='' WHERE rfa_id=20061

When this statement is executed the fin_status field is set to 'A' for majority of the records in the table

This is a big problem for me as this happens without warning .
I would like to know if this is a bug.

Thanks in advance

Regards
Mathew



Edited 2 time(s). Last edit at 07/25/2006 12:44AM by Mathew Joseph.