You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2025/05/15 05:33:02 UTC
(shardingsphere) branch master updated: Correct SQL state and error message for MySQL duplicate entry errors (#35421)
This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new b20da098b9d Correct SQL state and error message for MySQL duplicate entry errors (#35421)
b20da098b9d is described below
commit b20da098b9ded53477056661427317462d9b3888
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Thu May 15 13:32:56 2025 +0800
Correct SQL state and error message for MySQL duplicate entry errors (#35421)
- Update SQL state for ER_DUP_ENTRY from INTEGRITY_CONSTRAINT_VIOLATION to SYNTAX_ERROR
- Update SQL state for ER_PARSE_ERROR from INTEGRITY_CONSTRAINT_VIOLATION to SYNTAX_ERROR
- Correct error message format for ER_DUP_ENTRY
- Correct error message format for ER_PARSE_ERROR
---
.../shardingsphere/infra/exception/mysql/vendor/MySQLVendorError.java | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/infra/exception/dialect/type/mysql/src/main/java/org/apache/shardingsphere/infra/exception/mysql/vendor/MySQLVendorError.java b/infra/exception/dialect/type/mysql/src/main/java/org/apache/shardingsphere/infra/exception/mysql/vendor/MySQLVendorError.java
index e8be69694ee..177ac7da77b 100644
--- a/infra/exception/dialect/type/mysql/src/main/java/org/apache/shardingsphere/infra/exception/mysql/vendor/MySQLVendorError.java
+++ b/infra/exception/dialect/type/mysql/src/main/java/org/apache/shardingsphere/infra/exception/mysql/vendor/MySQLVendorError.java
@@ -50,9 +50,9 @@ public enum MySQLVendorError implements VendorError {
ER_TABLE_EXISTS_ERROR(XOpenSQLState.DUPLICATE, 1050, "Table '%s' already exists"),
- ER_DUP_ENTRY(XOpenSQLState.SYNTAX_ERROR, 1062, "%s near '%s' at line %d"),
+ ER_DUP_ENTRY(XOpenSQLState.INTEGRITY_CONSTRAINT_VIOLATION, 1062, "Duplicate entry '%s' for key %d"),
- ER_PARSE_ERROR(XOpenSQLState.INTEGRITY_CONSTRAINT_VIOLATION, 1064, "Duplicate entry '%s' for key %d"),
+ ER_PARSE_ERROR(XOpenSQLState.SYNTAX_ERROR, 1064, "%s near '%s' at line %d"),
ER_UNKNOWN_CHARACTER_SET(XOpenSQLState.SYNTAX_ERROR, 1115, "Unknown character set: '%s'"),