Skip to content
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生成的修复SQL没有处理反斜线字符(“\") #838

Open
lenmore opened this issue Jan 10, 2025 · 1 comment
Open

Comments

@lenmore
Copy link

lenmore commented Jan 10, 2025

版本: 8.5.0

如果字段中含有反斜线(“"), 生成修复SQL时是直接输出的,没有转移。导致执行修复SQL后反斜线丢失。最终数据还是不一致。

比如
实际值是: '!(^(?=[-+)(\d ]+$)(?:.?\d.){10,}$)'
生成的SQL是: REPLACE INTO test.t1(ID, c1) VALUES (1, '!(^(?=[-+)(\d ]+$)(?:.?\d.){10,}$)' );
执行后的值变成了: '!(^(?=[-+)(d ]+$)(?:.?d.){10,}$)'

Copy link

ti-chi-bot bot commented Jan 10, 2025

[FORMAT CHECKER NOTIFICATION]

🫱 ${\color{gold}\Huge{\textsf{Please use english to create or update issue.}}}$

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant