pingcap/tidb-tools

sync-diff-inspector: Doesn't check check constraints

Opened this issue · 0 comments

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?

Upstream:

create table t3 (id int primary key, check (id<10));

Downstream:

SET GLOBAL tidb_enable_check_constraint=ON;
create table t3 (id int primary key, check (id<20));
  1. What did you expect to see?

Difference in the check constraint being reported

  1. What did you see instead?
Comparing the table structure of ``test`.`t3`` ... equivalent
  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

v8.0.0

  1. which tool are you using?

sync_diff_inspector

  1. what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)?
$ ./bin/sync_diff_inspector -V
App Name: sync_diff_inspector
Release Version: v8.1.0-1-g17af326
Git Commit Hash: 17af3262fc169d6a4ae3f6ece6ade4e49b24a804
Git Branch: master
UTC Build Time: 2024-05-24 09:30:01
Go Version: go1.22.3