check float will return error.When float data has 0 value on source or on target
erwadba opened this issue · 0 comments
erwadba commented
Bug Report
Please answer these questions before submitting your issue. Thanks!
- What did you do?
If possible, provide a recipe for reproducing the error.
source tidb
mysql> create table f(id int primary key,f float);
mysql> insert into f values(1,2),(2,4.5),(3,0);
target tidb
mysql> create table f(id int primary key,f float);
mysql> insert into f values(1,0),(2,0),(3,0);
-
What did you expect to see?
no error -
What did you see instead?
convert , 4.5 to float failed, err1: strconv.ParseFloat: parsing "": invalid syntax, err2: error occured in a
.f
- What version of TiDB are you using (
tidb-server -V
or runselect tidb_version();
on TiDB)?
v6.5.0 - which tool are you using?
sync_diff_inspector - what versionof tool are you using (
pump -V
ortidb-lightning -V
orsyncer -V
)?