-
Notifications
You must be signed in to change notification settings - Fork 15.1k
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
严重问题,数据误删除!!!online erp表单修改主表时,子表数据被全量删除 #7190
Comments
cr |
已处理,下个版本发布 |
|
1 similar comment
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
版本号:
3.6.3和3.7.0都试过
问题描述:
修改ERP表单的主表数据,会触发子表的批量删除(执行的是delete where in 语句),然后执行单个插入语句(执行的是 insert ),但是因为一页只有5条,所以插入语句也只执行了五条,导致有一张两万条数据的表只剩下五条。

后续使用 binlog 恢复了数据,但这个问题确实很严重,为了确认不是我自己的代码影响,又下载了 3.7.0 测试了一遍,仍然如此,从六条数据变为了五条,所以ERP修改主表会触发子表的误删除
错误截图:
友情提示:
The text was updated successfully, but these errors were encountered: