SQL:
DELETE FROM `tkhk`.`cache_tendersummary_loc` WHERE `officeid`='28401' AND `branchid`='20401' AND `tendertypeid`='1' AND `tenderclassificationid`='4' AND `tenderprem`='85' AND `tenderunit`='882' AND `tendernum`='87' AND `tendervalue`='5578720' AND `tendernummonth`='0' AND `tendervaluemonth`='0' AND `targetmonth`=6966.67 AND `tendernumyear`='0' AND `tendervalueyear`='0' AND `targetyear`=27866.7 AND `opportunityprem`='251' AND `opportunityunit`='2232' AND `opportunitynum`='298' AND `opportunityvalue`='4585270' AND `alltimetendernum`='303' AND `alltimetendervalue`='99798240' AND `alltimewonnum`='38' AND `alltimewonvalue`='6103773' AND `alltimelostnum`='178' AND `alltimelostvalue`='88115744' AND `alltimeclosednum` IS NULL AND `alltimeclosedvalue` IS NULL AND `tenderclosedmonth` IS NULL AND `valueclosedmonth` IS NULL AND `tenderclosedyear` IS NULL AND `valueclosedyear` IS NULL AND `tendercreatedmonth`='3' AND `valuecreatedmonth`='54920' AND `tendercreatedyear`='11' AND `valuecreatedyear`='590720' AND `valuewonmonth`='0' AND `valuelostmonth`='0' AND `valueunresolvedmonth`='5560950' AND `valuewonyear`='0' AND `valuelostyear`='0' AND `valueunresolvedyear`='5560950' AND `unitwonmonth`='0' AND `unitlostmonth`='0' AND `unitunresolvedmonth`='816' AND `unitwonyear`='0' AND `unitlostyear`='0' AND `unitunresolvedyear`='816' AND `tenderwonmonth`='0' AND `tenderlostmonth`='0' AND `tenderunresolvedmonth`='86' AND `tenderwonyear`='0' AND `tenderlostyear`='0' AND `tenderunresolvedyear`='86' LIMIT 1 /*percona-toolkit src_db:tkhk src_tbl:cache_tendersummary_loc src_dsn:A=utf8,h=192.168.1.153,p=...,u=pttool dst_db:tkhk dst_tbl:cache_tendersummary_loc dst_dsn:A=utf8,h=192.168.1.154,p=...,u=pttool lock:0 transaction:1 changing_src:0 replicate:0 bidirectional:0 pid:65398 user:root host:Damon*/;
Pt-table-sync version: 2.2.11
issue sql :
AND `targetmonth`=6966.67
AND `targetyear`=27866.7
targetmonth and targetyear type: float
Command : pt-table-sync --execute --charset=utf8 --no-check-triggers --no-check-slave --no-foreign- key-checks --databases tkhk --tables cache_tendersum mary_loc h=192.168. 1.153,u= 'xxxx', p='xxxxxxx' h=192.168. 1.154,u= 'xxxxx' ,p='xxxxxxxxxx'