Comment 3 for bug 1426629

Hi Frank

I can find the record in my databases , I did't find the float data have different between delete sql and the record . so i think shouldn't rounding issues . there is "Show create table" following.

CREATE TABLE `cache_tendersummary_loc` (
  `OfficeID` int(10) DEFAULT NULL,
  `BranchID` int(10) DEFAULT NULL,
  `TenderTypeID` int(10) DEFAULT NULL,
  `TenderClassificationID` int(10) DEFAULT NULL,
  `TenderPrem` int(10) DEFAULT NULL,
  `TenderUnit` int(10) DEFAULT NULL,
  `TenderNum` int(10) DEFAULT NULL,
  `TenderValue` decimal(22,0) DEFAULT NULL,
  `TenderNumMonth` int(10) DEFAULT NULL,
  `TenderValueMonth` int(10) DEFAULT NULL,
  `TargetMonth` float DEFAULT NULL,
  `TenderNumYear` int(10) DEFAULT NULL,
  `TenderValueYear` int(10) DEFAULT NULL,
  `TargetYear` float DEFAULT NULL,
  `OpportunityPrem` int(10) DEFAULT NULL,
  `OpportunityUnit` int(10) DEFAULT NULL,
  `OpportunityNum` int(10) DEFAULT NULL,
  `OpportunityValue` decimal(22,0) DEFAULT NULL,
  `AllTimeTenderNum` int(10) DEFAULT NULL,
  `AllTimeTenderValue` decimal(22,0) DEFAULT NULL,
  `AllTimeWonNum` decimal(10,0) DEFAULT NULL,
  `AllTimeWonValue` decimal(22,0) DEFAULT NULL,
  `AllTimeLostNum` decimal(10,0) DEFAULT NULL,
  `AllTimeLostValue` decimal(22,0) DEFAULT NULL,
  `AllTimeClosedNum` decimal(10,0) DEFAULT NULL,
  `AllTimeClosedValue` decimal(22,0) DEFAULT NULL,
  `TenderClosedMonth` decimal(10,0) DEFAULT NULL,
  `ValueClosedMonth` decimal(22,0) DEFAULT NULL,
  `TenderClosedYear` decimal(10,0) DEFAULT NULL,
  `ValueClosedYear` decimal(22,0) DEFAULT NULL,
  `TenderCreatedMonth` decimal(10,0) DEFAULT NULL,
  `ValueCreatedMonth` decimal(22,0) DEFAULT NULL,
  `TenderCreatedYear` decimal(10,0) DEFAULT NULL,
  `ValueCreatedYear` decimal(22,0) DEFAULT NULL,
  `ValueWonMonth` decimal(22,0) DEFAULT NULL,
  `ValueLostMonth` decimal(22,0) DEFAULT NULL,
  `ValueUnresolvedMonth` decimal(22,0) DEFAULT NULL,
  `ValueWonYear` decimal(22,0) DEFAULT NULL,
  `ValueLostYear` decimal(22,0) DEFAULT NULL,
  `ValueUnresolvedYear` decimal(22,0) DEFAULT NULL,
  `UnitWonMonth` decimal(22,0) DEFAULT NULL,
  `UnitLostMonth` decimal(22,0) DEFAULT NULL,
  `UnitUnresolvedMonth` decimal(22,0) DEFAULT NULL,
  `UnitWonYear` decimal(22,0) DEFAULT NULL,
  `UnitLostYear` decimal(22,0) DEFAULT NULL,
  `UnitUnresolvedYear` decimal(22,0) DEFAULT NULL,
  `TenderWonMonth` decimal(22,0) DEFAULT NULL,
  `TenderLostMonth` decimal(22,0) DEFAULT NULL,
  `TenderUnresolvedMonth` decimal(22,0) DEFAULT NULL,
  `TenderWonYear` decimal(22,0) DEFAULT NULL,
  `TenderLostYear` decimal(22,0) DEFAULT NULL,
  `TenderUnresolvedYear` decimal(22,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Thanks and regards,
Damon