sync_diff_inspector对比报错,提示 Illegal mix of collations,但上下游collation是一样的

是的,现在的 workaround 就是在 sync-diff 配置中强制让这个表走一个不存在的索引,例如

######################### Task config #########################
[task]
        output-dir = "./output"

        source-instances = ["mysql1"]

        target-instance = "tidb0"

        target-check-tables = ["schema*.table*", "!c.*", "test2.t2"]
        target-configs = ["config1"]

######################### Table config #########################
[table-configs.config1]
target-tables = ["schema*.test*", "test2.t2"]  #  填写出问题的表
index-fields = ["broker"]