pingcap / tidb-tools

tidb-tools are some useful tool collections for TiDB.
Apache License 2.0
286 stars 191 forks source link

error occurred when the different row's json column is NULL in the one db source, but is not NULL in the other db source #736

Closed Leavrth closed 1 year ago

Leavrth commented 1 year ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?

upstream:

create database if not exists json_test;
create table json_test.test (a int, b json, primary key(a));

insert into json_test.test values (1, '{"id": 1, "name":"aaa"}');

downstream:

create database if not exists json_test;
create table json_test.test (a int, b json, primary key(a));

insert into json_test.test values (1, NULL);
  1. What did you expect to see? check different

  2. What did you see instead? error occurred:

    Error in comparison process:
    unmarshal json  failed, error unexpected end of JSON input error occured in `test`.`t`
  3. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)? master

  4. which tool are you using? sync-diff-inspector

  5. what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)?