apache / apache/incubator-seata

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

Open
#5,757 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.