hanchuanchuan / goInception

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

delete b.* 报语法错误 #585

Closed czxin788 closed 1 year ago

czxin788 commented 1 year ago

描述 mysql可以正常执行:delete b.* from aaa a left join bbb b on a.numericalorder = b.numericalorder where enterpriseid in (116765594498537) and a.datadate between '2023-01-01' and '2023-05-31' and b.accochecktype in (201708010104402109, 201708010104402114)

但是goinception审核报错: line 1 column 18 near "* from aaa a left join bbb b on a.numericalorder = b.numericalorder where enterpriseid in (116765594498537) and a.datadate between '2023-01-01' and '2023-05-31' and b.accochecktype in (201708010104402109, 201708010104402114)"

重现 模拟重现的步骤

环境

参数 可能与问题相关的设置参数

hanchuanchuan commented 1 year ago

请改为 delete b from aaa a left join bbb b ... 属于TiDB语法兼容性问题, 有些特殊写法不支持. 参考 #505