-
Notifications
You must be signed in to change notification settings - Fork 197
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
sync_diff_inspector 的 json compare 不正确 #606
Comments
It's hard to compare json field cause we lost the information of column field. so we cannot do de-serialize here. |
你是说对于 json column,其 column.FieldType 并不是 JSON 所以没法对它按照 JSON 反序列化? 忽略 JSON 列的话 sync_diff_inspector 的结果就失去意义了。。。 |
I think wa can consider this a duplicate of #350 |
https://github.com/pingcap/tidb-tools/blob/master/sync_diff_inspector/utils/utils.go#L535
mysql 按照 key length 排序然后再按词典序,tidb 按照词典序排序,看起来这个地方把 json 解析再序列化下就可以比对了。
func CompareData(map1, map2 map[string]*dbutil.ColumnData, orderKeyCols, columns []*model.ColumnInfo) (equal bool, cmp int32, err error) {
The text was updated successfully, but these errors were encountered: