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

看了一下,是有的哈,把 index-fields 换成 range 就行了

######################### 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"]  #  填写出问题的表
range = "true and true"
2 个赞