apache / apache/incubator-seata
DELETE with JOIN 语句 在 seata 下 报 not support the syntax of delete with join table 错误
Open
task: help-wanted
- Dominant language
- Java
- Stars
- 26k
- Forks
- 8.8k
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 4
Description
问题描述:
使用 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
Contributor guide
Research direction
Start by reproducing the DELETE with JOIN example against MySQL 8.0 under Seata 1.6.1, then trace where the NotSupportYetException for delete with join table is produced. Done means the supported statement no longer raises this error and regression coverage verifies the sample syntax.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- databases, distributed-systems
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100