Issues with Single Backslash \ in sync_diff_inspector Data

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: sync_diff_inspector 数据里面有单斜杠\的问题

| username: Vincent_Wang

【TiDB Usage Environment】Production Environment
【TiDB Version】
【Reproduction Path】What operations were performed when the issue occurred
【Encountered Issue: Issue Phenomenon and Impact】

There are single backslashes \ in the data,
The generated repair SQL after comparison also contains single backslashes \ (it should be three backslashes \)
However, if you execute the repair SQL with single backslashes , the result will not contain any backslashes \

【Resource Configuration】Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】

| username: MrSylar | Original post link

Could this not be considered a problem, but just an output that is different from what everyone expected?

| username: tidb菜鸟一只 | Original post link

TiDB does not guarantee that the repair SQL generated by sync_diff_inspector is always correct.