apache / shardingsphere

Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Apache License 2.0
19.98k stars 6.75k forks source link

BatchUpdateException occurs when exeucte INSERT INTO ON DUPLICATE KEY UPDATE in proxy adapter #33745

Open strongduanmu opened 21 hours ago

strongduanmu commented 21 hours ago

Bug Report

Which version of ShardingSphere did you use?

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

Execute INSERT INTO ON DUPLICATE KEY UPDATE with jdbc batch api successfully.

Actual behavior

image

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).