goInception icon indicating copy to clipboard operation
goInception copied to clipboard

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

Open dibrother opened this issue 1 year ago • 1 comments

描述 使用 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

dibrother avatar Oct 20 '23 03:10 dibrother

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

hanchuanchuan avatar Nov 12 '23 12:11 hanchuanchuan