使用mybatisplus 先删除在批量插入没有执行成功

[BeiQiaoT]

• I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

在全局事务中先删除一条数据，然后插入一条数据，两条数据的id保持一致，此时如果使用mybatisplus单条插入则没有问题，使用mybatisplus批量插入没有执行成功。

Ⅱ. Describe what happened

debug发现有如下异常，批量插入时只有第一次注册失败日志,并且插入操作没有执行成功

### Error flushing statements.  Cause: java.sql.SQLException: io.seata.core.exception.RmTransactionException: branch register exception, xid:192.168.1.12:8091:27612063588174772
### Cause: java.sql.SQLException: io.seata.core.exception.RmTransactionException: branch register exception, xid:192.168.1.12:8091:27612063588174772
; uncategorized SQLException; SQL state [null]; error code [0]; io.seata.core.exception.RmTransactionException: branch register exception, xid:192.168.1.12:8091:27612063588174772

Ⅲ. Describe what you expected to happen

可以正常插入

Ⅳ. How to reproduce it (as minimally and precisely as possible)

这个链接有详细的说明：https://developer.aliyun.com/ask/659744

Minimal yet complete reproducer code (or URL to code):

参考这个：https://developer.aliyun.com/ask/659744

Ⅴ. Anything else we need to know?

无

Ⅵ. Environment:

• JDK version(e.g. java -version): graalvm-ce-17
• Seata client/server version: 1.8
• Database version: mysql 8
• OS(e.g. uname -a): Darwin Kernel Version 24.1.0
• Others:

[funky-eyes]

不支持savebatch，因为获取自增主键存在问题。
Savebatch is not supported because there is a problem getting the auto-increment primary key.

[BeiQiaoT]

不支持savebatch，因为获取自增主键存在问题。 Savebatch is not supported because there is a problem getting the auto-increment primary key.

有什么好的解决办法吗？还是说目前只能循环使用单条插入呢？

[funky-eyes]

不支持savebatch，因为获取自增主键存在问题。 Savebatch is not supported because there is a problem getting the auto-increment primary key.

有什么好的解决办法吗？还是说目前只能循环使用单条插入呢？

这种sql应该是可以的
This sql should work.

INSERT xxxx INTO table_name (column1, column2, column3)
VALUES
    (value1a, value2a, value3a),
    (value1b, value2b, value3b),
    (value1c, value2c, value3c);

[wxrqforever]

@BeiQiaoT
请教下具体使用的saveBatch方法是什么，我使用的是IService的saveBatch并没有出现这个报错，是还因为先执行删除语句的原因吗？