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

对于ON UPDATE CURRENT_TIMESTAMP自动更新的时间戳字段，不能做到有效回滚 #2541

Closed
ThomasYoung1989 opened this issue Apr 13, 2020 · 2 comments
Closed

对于ON UPDATE CURRENT_TIMESTAMP自动更新的时间戳字段，不能做到有效回滚 #2541

ThomasYoung1989 opened this issue Apr 13, 2020 · 2 comments

Comments

@ThomasYoung1989
Copy link

由于当前的回滚机制是基于提交的sql做分析生成image，可能误判实际更新的字段数量，对于自动更新的时间戳字段，sql中不会提交，导致回滚后数据不对；如果是串起来的业务，对一个记录更新两次，两次更新过后发生回滚，第二次更新回滚成功，第一次更新回滚失败，报Field not equals, name update_time, old value 2020-04-11 17:34:08.0, new value 2020-04-11 17:34:10.0
@slievrly slievrly mentioned this issue Apr 13, 2020
Merged
@hermitcai
Copy link

都有点不懂你描述的意思 第二次更新回滚能成功 为什么第一次就失败了 如果你的字段不是sql控制的是数据库自己的 那你第二次回滚也会失败

@zjinlei
Copy link
Contributor

zjinlei commented May 3, 2020

will release in 1.3.0

@zjinlei zjinlei closed this as completed May 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ThomasYoung1989 @zjinlei @hermitcai