Please answer these questions before submitting your issue. Thanks!
What did you do?
If possible, provide a recipe for reproducing the error.
-- mysql @ 172.17.0.2:3306
create table u (a int primary key);
insert into u values (1), (2);
-- tidb @ 127.0.0.1:4000
create table u (a int primary key);
insert into u values (1), (2);
[2023/12/28 01:37:05.737 +08:00] [FATAL] [main.go:139] ["failed to check data difference"] [error="Error 1253 (42000): COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'binary'"]
What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
7.3.0
which tool are you using?
sync-diff-inspector 7.1.3 (master version 8811722d71222462578c24da878a59ca46c8baaf)
what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)?
Bug Report
Please answer these questions before submitting your issue. Thanks!
The two
test.u
tables are equivalentFatal error.
tidb-server -V
or runselect tidb_version();
on TiDB)?7.3.0
sync-diff-inspector 7.1.3 (master version 8811722d71222462578c24da878a59ca46c8baaf)
pump -V
ortidb-lightning -V
orsyncer -V
)?