hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.59k stars 545 forks source link

使用 delete join 时,不能正确生成数据备份与回滚语句 #616

Open dibrother opened 8 months ago

dibrother commented 8 months ago

描述 使用 delete join 时,不能正确生成数据备份回滚语句

重现

# 建表
create table t1 (id int ,va varchar(10));
create table t2 (id int ,va varchar(10));
# 测试数据
insert into t1 values(1,'老王');
insert into t2 values (1,'老李');

# 问题语句
delete a,b from t1 a join t2 b on a.id = b.id;  -- Execute Successfully Backup failed
hanchuanchuan commented 8 months ago

已更新. 请升级到 v1.3.0-84 版本后重试.