DELETE with JOIN 语句在 seata 下报 not support the syntax of delete with join table 错误

cpjpxq1n 于 4个月前发布在其他

关注(0)|答案(3)|浏览(56)

问题描述：
使用 DELETE with JOIN 语句进行关联删除时，Seata 报错不支持这种语法

SQL样例：
DELETE t
FROM t
INNER JOIN t2 ON ...
WHERE ...

报错信息：
Caused by: io.seata.common.exception.NotSupportYetException: not support the syntax of delete with join table

使用环境：
Java：JDK1.8
MYSQL：8.0
Seata：1.6.1

3条答案

currently not support delete ... join SQL syntax.

please assign it to me, i will solve it in nearest month

请把它给我,我将在最近的一个月内解决它

现在支持这种语法了吗？