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.

Sign up for GitHub

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

Jump to bottom

因有个表用了explain字段，源表新增数据后adapter同步时报SQLSyntaxErrorException异常 #2783

Closed
guoguo66 opened this issue Jun 2, 2020 · 5 comments
Closed

因有个表用了explain字段，源表新增数据后adapter同步时报SQLSyntaxErrorException异常 #2783

guoguo66 opened this issue Jun 2, 2020 · 5 comments
Labels
bug
Milestone
v1.1.6

Comments

@guoguo66
Copy link

guoguo66 commented Jun 2, 2020

image
@CurtisYang1989
Copy link

遇到同样问题了

@guoguo66
Copy link
Author

guoguo66 commented Jun 2, 2020

遇到同样问题了

有个临时解决办法，可以关闭mapAll，开启targetColumns，只同步需要同步的字段，不同步explain

@agapple
Copy link
Member

agapple commented Aug 21, 2020

看来explain是命中mysql关键字了，需要在sync同步时增加转义符

@agapple agapple added the bug label Aug 21, 2020
@agapple agapple added this to the v1.1.5 milestone Aug 21, 2020
@wangyu1916
Copy link

字段是不是加了 `` ，可以去掉试试

@XuDaojie XuDaojie mentioned this issue Oct 6, 2020
Closed
@agapple agapple modified the milestones: v1.1.5, v1.1.6 Apr 19, 2021
@agapple
Copy link
Member

agapple commented May 23, 2022

#3984

@agapple agapple closed this as completed May 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
v1.1.6
Development

Successfully merging a pull request may close this issue.

fix: v1.1.5-snapshot rdb-adapter 由关键字引起的异常 (#3026 #2783) XuDaojie/canal
4 participants
@agapple @guoguo66 @CurtisYang1989 @wangyu1916