You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by pa...@apache.org on 2022/09/11 13:43:55 UTC

[shardingsphere] branch master updated: Adjust FeatureSQLException's vendor codes (#20929)

This is an automated email from the ASF dual-hosted git repository.

panjuan 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 2395a05bf44 Adjust FeatureSQLException's vendor codes (#20929)
2395a05bf44 is described below

commit 2395a05bf44922542b71f2a8c598807234c449fa
Author: Liang Zhang <zh...@apache.org>
AuthorDate: Sun Sep 11 21:43:48 2022 +0800

    Adjust FeatureSQLException's vendor codes (#20929)
---
 .../user-manual/error-code/sql-error-code.cn.md    | 44 +++++++++++-----------
 .../user-manual/error-code/sql-error-code.en.md    | 44 +++++++++++-----------
 .../UnsupportedEncryptInsertValueException.java    |  2 +-
 .../syntax/UnsupportedEncryptSQLException.java     |  2 +-
 .../data/UnsupportedShadowColumnTypeException.java |  2 +-
 .../UnsupportedShadowInsertValueException.java     |  2 +-
 .../connection/CursorNameNotFoundException.java    |  2 +-
 .../EmptyShardingRouteResultException.java         |  2 +-
 .../connection/ShardingDDLRouteException.java      |  2 +-
 .../data/InvalidDatetimeFormatException.java       |  2 +-
 .../exception/data/NullShardingValueException.java |  2 +-
 .../data/ShardingValueDataTypeException.java       |  2 +-
 .../DMLMultipleDataNodesWithLimitException.java    |  2 +-
 .../DMLWithMultipleShardingTablesException.java    |  2 +-
 .../DataSourceIntersectionNotFoundException.java   |  2 +-
 .../InsertSelectTableViolationException.java       |  2 +-
 ...GenerateKeyColumnWithInsertSelectException.java |  2 +-
 ...namedViewWithoutSameConfigurationException.java |  2 +-
 .../syntax/UnsupportedCreateViewException.java     |  2 +-
 ...ortedPrepareRouteToSameDataSourceException.java |  2 +-
 .../UnsupportedShardingOperationException.java     |  2 +-
 .../UnsupportedUpdatingShardingValueException.java |  2 +-
 .../UnsupportedTranslatedDatabaseException.java    |  2 +-
 .../syntax/UnsupportedTranslatedSQLException.java  |  2 +-
 24 files changed, 66 insertions(+), 66 deletions(-)

diff --git a/docs/document/content/user-manual/error-code/sql-error-code.cn.md b/docs/document/content/user-manual/error-code/sql-error-code.cn.md
index f46875ea0d3..41962c2b930 100644
--- a/docs/document/content/user-manual/error-code/sql-error-code.cn.md
+++ b/docs/document/content/user-manual/error-code/sql-error-code.cn.md
@@ -108,22 +108,22 @@ SQL 错误码以标准的 SQL State,Vendor Code 和详细错误信息提供,
 | 42S01     | 20007       | Index \`%s\` already exists |
 | 42S02     | 20008       | Index \`%s\` does not exist |
 | 42S01     | 20009       | View name has to bind to %s tables |
-| 44000     | 20010       | Sharding value can't be null in insert statement |
-| HY004     | 20011       | Found different types for sharding value \`%s\` |
-| HY004     | 20012       | Invalid %s, datetime pattern should be \`%s\`, value is \`%s\` |
-| 0A000     | 20020       | Can not support operation \`%s\` with sharding table \`%s\` |
-| 44000     | 20021       | Can not update sharding value for table \`%s\` |
-| 0A000     | 20022       | The CREATE VIEW statement contains unsupported query statement |
-| 44000     | 20023       | PREPARE statement can not support sharding tables route to same data sources |
-| 44000     | 20024       | The table inserted and the table selected must be the same or bind tables |
-| 0A000     | 20025       | Can not support DML operation with multiple tables \`%s\` |
-| 42000     | 20026       | %s ... LIMIT can not support route to multiple data nodes |
-| 44000     | 20027       | Can not find actual data source intersection for logic tables \`%s\` |
-| 42000     | 20028       | INSERT INTO ... SELECT can not support applying key generator with absent generate key column |
-| 0A000     | 20029       | Alter view rename .. to .. statement should have same config for \`%s\` and \`%s\` |
-| HY000     | 20030       | \`%s %s\` can not route correctly for %s \`%s\` |
-| 42S02     | 20031       | Can not get route result, please check your sharding rule configuration |
-| 34000     | 20032       | Can not get cursor name from fetch statement |
+| 44000     | 20020       | Sharding value can't be null in insert statement |
+| HY004     | 20021       | Found different types for sharding value \`%s\` |
+| HY004     | 20022       | Invalid %s, datetime pattern should be \`%s\`, value is \`%s\` |
+| 0A000     | 20040       | Can not support operation \`%s\` with sharding table \`%s\` |
+| 44000     | 20041       | Can not update sharding value for table \`%s\` |
+| 0A000     | 20042       | The CREATE VIEW statement contains unsupported query statement |
+| 44000     | 20043       | PREPARE statement can not support sharding tables route to same data sources |
+| 44000     | 20044       | The table inserted and the table selected must be the same or bind tables |
+| 0A000     | 20045       | Can not support DML operation with multiple tables \`%s\` |
+| 42000     | 20046       | %s ... LIMIT can not support route to multiple data nodes |
+| 44000     | 20047       | Can not find actual data source intersection for logic tables \`%s\` |
+| 42000     | 20048       | INSERT INTO ... SELECT can not support applying key generator with absent generate key column |
+| 0A000     | 20049       | Alter view rename .. to .. statement should have same config for \`%s\` and \`%s\` |
+| HY000     | 20060       | \`%s %s\` can not route correctly for %s \`%s\` |
+| 42S02     | 20061       | Can not get route result, please check your sharding rule configuration |
+| 34000     | 20062       | Can not get cursor name from fetch statement |
 | HY000     | 20080       | Sharding algorithm class \`%s\` should be implement \`%s\` |
 | HY000     | 20081       | Routed target \`%s\` does not exist, available targets are \`%s\` |
 | 44000     | 20082       | Inline sharding algorithms expression \`%s\` and sharding column \`%s\` do not match |
@@ -142,8 +142,8 @@ SQL 错误码以标准的 SQL State,Vendor Code 和详细错误信息提供,
 
 | SQL State | Vendor Code | 错误信息 |
 | --------- | ----------- | ------ |
-| 42000     | 20420       | Can not support database \`%s\` in SQL translation |
-| 42000     | 20421       | Translation error, SQL is: %s |
+| 42000     | 20440       | Can not support database \`%s\` in SQL translation |
+| 42000     | 20441       | Translation error, SQL is: %s |
 
 ### 流量治理
 
@@ -158,16 +158,16 @@ SQL 错误码以标准的 SQL State,Vendor Code 和详细错误信息提供,
 | 44000     | 20700       | Can not find logic encrypt column by \`%s\` |
 | 44000     | 20701       | Fail to find encrypt column \`%s\` from table \`%s\` |
 | 44000     | 20702       | Altered column \`%s\` must use same encrypt algorithm with previous column \`%s\` in table \`%s\` |
-| 42000     | 20720       | Insert value of index \`%s\` can not support for encrypt |
-| 0A000     | 20721       | The SQL clause \`%s\` is unsupported in encrypt rule |
+| 42000     | 20740       | Insert value of index \`%s\` can not support for encrypt |
+| 0A000     | 20741       | The SQL clause \`%s\` is unsupported in encrypt rule |
 | HY004     | 20780       | Encrypt algorithm \`%s\` initialization failed, reason is: %s |
 
 ### 影子库
 
 | SQL State | Vendor Code | 错误信息 |
 | --------- | ----------- | ------ |
-| HY004     | 20810       | Shadow column \`%s\` of table \`%s\` does not support \`%s\` type |
-| 42000     | 20820       | Insert value of index \`%s\` can not support for shadow |
+| HY004     | 20820       | Shadow column \`%s\` of table \`%s\` does not support \`%s\` type |
+| 42000     | 20840       | Insert value of index \`%s\` can not support for shadow |
 
 ## 其他异常
 
diff --git a/docs/document/content/user-manual/error-code/sql-error-code.en.md b/docs/document/content/user-manual/error-code/sql-error-code.en.md
index 3a7f24b4141..63c6eb2e90b 100644
--- a/docs/document/content/user-manual/error-code/sql-error-code.en.md
+++ b/docs/document/content/user-manual/error-code/sql-error-code.en.md
@@ -108,22 +108,22 @@ SQL error codes provide by standard `SQL State`, `Vendor Code` and `Reason`, whi
 | 42S01     | 20007       | Index \`%s\` already exists |
 | 42S02     | 20008       | Index \`%s\` does not exist |
 | 42S01     | 20009       | View name has to bind to %s tables |
-| 44000     | 20010       | Sharding value can't be null in insert statement |
-| HY004     | 20011       | Found different types for sharding value \`%s\` |
-| HY004     | 20012       | Invalid %s, datetime pattern should be \`%s\`, value is \`%s\` |
-| 0A000     | 20020       | Can not support operation \`%s\` with sharding table \`%s\` |
-| 44000     | 20021       | Can not update sharding value for table \`%s\` |
-| 0A000     | 20022       | The CREATE VIEW statement contains unsupported query statement |
-| 44000     | 20023       | PREPARE statement can not support sharding tables route to same data sources |
-| 44000     | 20024       | The table inserted and the table selected must be the same or bind tables |
-| 0A000     | 20025       | Can not support DML operation with multiple tables \`%s\` |
-| 42000     | 20026       | %s ... LIMIT can not support route to multiple data nodes |
-| 44000     | 20027       | Can not find actual data source intersection for logic tables \`%s\` |
-| 42000     | 20028       | INSERT INTO ... SELECT can not support applying key generator with absent generate key column |
-| 0A000     | 20029       | Alter view rename .. to .. statement should have same config for \`%s\` and \`%s\` |
-| HY000     | 20030       | \`%s %s\` can not route correctly for %s \`%s\` |
-| 42S02     | 20031       | Can not get route result, please check your sharding rule configuration |
-| 34000     | 20032       | Can not get cursor name from fetch statement |
+| 44000     | 20020       | Sharding value can't be null in insert statement |
+| HY004     | 20021       | Found different types for sharding value \`%s\` |
+| HY004     | 20022       | Invalid %s, datetime pattern should be \`%s\`, value is \`%s\` |
+| 0A000     | 20040       | Can not support operation \`%s\` with sharding table \`%s\` |
+| 44000     | 20041       | Can not update sharding value for table \`%s\` |
+| 0A000     | 20042       | The CREATE VIEW statement contains unsupported query statement |
+| 44000     | 20043       | PREPARE statement can not support sharding tables route to same data sources |
+| 44000     | 20044       | The table inserted and the table selected must be the same or bind tables |
+| 0A000     | 20045       | Can not support DML operation with multiple tables \`%s\` |
+| 42000     | 20046       | %s ... LIMIT can not support route to multiple data nodes |
+| 44000     | 20047       | Can not find actual data source intersection for logic tables \`%s\` |
+| 42000     | 20048       | INSERT INTO ... SELECT can not support applying key generator with absent generate key column |
+| 0A000     | 20049       | Alter view rename .. to .. statement should have same config for \`%s\` and \`%s\` |
+| HY000     | 20060       | \`%s %s\` can not route correctly for %s \`%s\` |
+| 42S02     | 20061       | Can not get route result, please check your sharding rule configuration |
+| 34000     | 20062       | Can not get cursor name from fetch statement |
 | HY000     | 20080       | Sharding algorithm class \`%s\` should be implement \`%s\` |
 | HY000     | 20081       | Routed target \`%s\` does not exist, available targets are \`%s\` |
 | 44000     | 20082       | Inline sharding algorithms expression \`%s\` and sharding column \`%s\` do not match |
@@ -142,8 +142,8 @@ SQL error codes provide by standard `SQL State`, `Vendor Code` and `Reason`, whi
 
 | SQL State | Vendor Code | Reason |
 | --------- | ----------- | ------ |
-| 42000     | 20420       | Can not support database \`%s\` in SQL translation |
-| 42000     | 20421       | Translation error, SQL is: %s |
+| 42000     | 20440       | Can not support database \`%s\` in SQL translation |
+| 42000     | 20441       | Translation error, SQL is: %s |
 
 ### Traffic Management
 
@@ -158,16 +158,16 @@ SQL error codes provide by standard `SQL State`, `Vendor Code` and `Reason`, whi
 | 44000     | 20700       | Can not find logic encrypt column by \`%s\` |
 | 44000     | 20701       | Fail to find encrypt column \`%s\` from table \`%s\` |
 | 44000     | 20702       | Altered column \`%s\` must use same encrypt algorithm with previous column \`%s\` in table \`%s\` |
-| 42000     | 20720       | Insert value of index \`%s\` can not support for encrypt |
-| 0A000     | 20721       | The SQL clause \`%s\` is unsupported in encrypt rule |
+| 42000     | 20740       | Insert value of index \`%s\` can not support for encrypt |
+| 0A000     | 20741       | The SQL clause \`%s\` is unsupported in encrypt rule |
 | HY004     | 20780       | Encrypt algorithm \`%s\` initialization failed, reason is: %s |
 
 ### Shadow Database
 
 | SQL State | Vendor Code | Reason |
 | --------- | ----------- | ------ |
-| HY004     | 20810       | Shadow column \`%s\` of table \`%s\` does not support \`%s\` type |
-| 42000     | 20820       | Insert value of index \`%s\` can not support for shadow |
+| HY004     | 20820       | Shadow column \`%s\` of table \`%s\` does not support \`%s\` type |
+| 42000     | 20840       | Insert value of index \`%s\` can not support for shadow |
 
 ## Other Exception
 
diff --git a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptInsertValueException.java b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptInsertValueException.java
index 875c0f28554..38d717cd49f 100644
--- a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptInsertValueException.java
+++ b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptInsertValueException.java
@@ -28,6 +28,6 @@ public final class UnsupportedEncryptInsertValueException extends EncryptSQLExce
     private static final long serialVersionUID = 5004882561157380582L;
     
     public UnsupportedEncryptInsertValueException(final int columnIndex) {
-        super(XOpenSQLState.SYNTAX_ERROR, 20, "Insert value of index `%s` can not support for encrypt", String.valueOf(columnIndex));
+        super(XOpenSQLState.SYNTAX_ERROR, 40, "Insert value of index `%s` can not support for encrypt", String.valueOf(columnIndex));
     }
 }
diff --git a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptSQLException.java b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptSQLException.java
index 18154f2ce63..3debc5c5205 100644
--- a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptSQLException.java
+++ b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-core/src/main/java/org/apache/shardingsphere/encrypt/exception/syntax/UnsupportedEncryptSQLException.java
@@ -28,6 +28,6 @@ public final class UnsupportedEncryptSQLException extends EncryptSQLException {
     private static final long serialVersionUID = 8391663664617661217L;
     
     public UnsupportedEncryptSQLException(final String sqlClause) {
-        super(XOpenSQLState.SYNTAX_ERROR, 21, "The SQL clause `%s` is unsupported in encrypt rule", sqlClause);
+        super(XOpenSQLState.SYNTAX_ERROR, 41, "The SQL clause `%s` is unsupported in encrypt rule", sqlClause);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/data/UnsupportedShadowColumnTypeException.java b/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/data/UnsupportedShadowColumnTypeException.java
index 2780fb05369..48b229bebce 100644
--- a/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/data/UnsupportedShadowColumnTypeException.java
+++ b/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/data/UnsupportedShadowColumnTypeException.java
@@ -28,6 +28,6 @@ public final class UnsupportedShadowColumnTypeException extends ShadowSQLExcepti
     private static final long serialVersionUID = 8144277065388645946L;
     
     public UnsupportedShadowColumnTypeException(final String tableName, final String columnName, final Class<?> type) {
-        super(XOpenSQLState.INVALID_DATA_TYPE, 10, "Shadow column `%s` of table `%s` does not support `%s` type", columnName, tableName, type.getName());
+        super(XOpenSQLState.INVALID_DATA_TYPE, 20, "Shadow column `%s` of table `%s` does not support `%s` type", columnName, tableName, type.getName());
     }
 }
diff --git a/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/syntax/UnsupportedShadowInsertValueException.java b/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/syntax/UnsupportedShadowInsertValueException.java
index ff797bdde48..ea142f28cc3 100644
--- a/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/syntax/UnsupportedShadowInsertValueException.java
+++ b/shardingsphere-features/shardingsphere-shadow/shardingsphere-shadow-core/src/main/java/org/apache/shardingsphere/shadow/exception/syntax/UnsupportedShadowInsertValueException.java
@@ -28,6 +28,6 @@ public final class UnsupportedShadowInsertValueException extends ShadowSQLExcept
     private static final long serialVersionUID = -5987403907441367171L;
     
     public UnsupportedShadowInsertValueException(final int columnIndex) {
-        super(XOpenSQLState.SYNTAX_ERROR, 20, "Insert value of index `%s` can not support for shadow", String.valueOf(columnIndex));
+        super(XOpenSQLState.SYNTAX_ERROR, 40, "Insert value of index `%s` can not support for shadow", String.valueOf(columnIndex));
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/CursorNameNotFoundException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/CursorNameNotFoundException.java
index 818d19759be..b930df4ee49 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/CursorNameNotFoundException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/CursorNameNotFoundException.java
@@ -28,6 +28,6 @@ public final class CursorNameNotFoundException extends ShardingSQLException {
     private static final long serialVersionUID = 3124329832945598311L;
     
     public CursorNameNotFoundException() {
-        super(XOpenSQLState.INVALID_CURSOR_NAME, 32, "Can not get cursor name from fetch statement");
+        super(XOpenSQLState.INVALID_CURSOR_NAME, 62, "Can not get cursor name from fetch statement");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/EmptyShardingRouteResultException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/EmptyShardingRouteResultException.java
index 9fb3334eb38..e37bafe0ec4 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/EmptyShardingRouteResultException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/EmptyShardingRouteResultException.java
@@ -28,6 +28,6 @@ public final class EmptyShardingRouteResultException extends ShardingSQLExceptio
     private static final long serialVersionUID = -6548076668933945656L;
     
     public EmptyShardingRouteResultException() {
-        super(XOpenSQLState.NOT_FOUND, 31, "Can not get route result, please check your sharding rule configuration");
+        super(XOpenSQLState.NOT_FOUND, 61, "Can not get route result, please check your sharding rule configuration");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/ShardingDDLRouteException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/ShardingDDLRouteException.java
index 45b31bb472b..61856f52957 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/ShardingDDLRouteException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/connection/ShardingDDLRouteException.java
@@ -30,6 +30,6 @@ public final class ShardingDDLRouteException extends ShardingSQLException {
     private static final long serialVersionUID = 1611718269096645289L;
     
     public ShardingDDLRouteException(final String operation, final String objectType, final Collection<String> objectNames) {
-        super(XOpenSQLState.GENERAL_ERROR, 30, "`%s %s` can not route correctly for %s `%s`", operation, objectType, objectType, objectNames.toString());
+        super(XOpenSQLState.GENERAL_ERROR, 60, "`%s %s` can not route correctly for %s `%s`", operation, objectType, objectType, objectNames.toString());
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/InvalidDatetimeFormatException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/InvalidDatetimeFormatException.java
index 5b777a9deb2..7d617cb6f1e 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/InvalidDatetimeFormatException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/InvalidDatetimeFormatException.java
@@ -28,6 +28,6 @@ public final class InvalidDatetimeFormatException extends ShardingSQLException {
     private static final long serialVersionUID = 4472952142748467059L;
     
     public InvalidDatetimeFormatException(final String dateTimeKey, final String dateTimeValue, final String dateTimePattern) {
-        super(XOpenSQLState.INVALID_DATA_TYPE, 12, "Invalid %s, datetime pattern should be `%s`, value is `%s`", dateTimeKey, dateTimePattern, dateTimeValue);
+        super(XOpenSQLState.INVALID_DATA_TYPE, 22, "Invalid %s, datetime pattern should be `%s`, value is `%s`", dateTimeKey, dateTimePattern, dateTimeValue);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/NullShardingValueException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/NullShardingValueException.java
index 82d01cebe02..30aef2c3ce1 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/NullShardingValueException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/NullShardingValueException.java
@@ -28,6 +28,6 @@ public final class NullShardingValueException extends ShardingSQLException {
     private static final long serialVersionUID = -6223086772479822057L;
     
     public NullShardingValueException() {
-        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 10, "Sharding value can't be null in insert statement");
+        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 20, "Sharding value can't be null in insert statement");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/ShardingValueDataTypeException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/ShardingValueDataTypeException.java
index 8d81f815611..21a0725b753 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/ShardingValueDataTypeException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/data/ShardingValueDataTypeException.java
@@ -29,6 +29,6 @@ public final class ShardingValueDataTypeException extends ShardingSQLException {
     private static final long serialVersionUID = -4833106947304679015L;
     
     public ShardingValueDataTypeException(final Column column) {
-        super(XOpenSQLState.INVALID_DATA_TYPE, 11, "Found different types for sharding value `%s`", column.toString());
+        super(XOpenSQLState.INVALID_DATA_TYPE, 21, "Found different types for sharding value `%s`", column.toString());
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLMultipleDataNodesWithLimitException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLMultipleDataNodesWithLimitException.java
index 86f89cc4e31..dd823c6f71e 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLMultipleDataNodesWithLimitException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLMultipleDataNodesWithLimitException.java
@@ -28,6 +28,6 @@ public final class DMLMultipleDataNodesWithLimitException extends ShardingSQLExc
     private static final long serialVersionUID = -203240151021113065L;
     
     public DMLMultipleDataNodesWithLimitException(final String operation) {
-        super(XOpenSQLState.SYNTAX_ERROR, 26, "%s ... LIMIT can not support route to multiple data nodes", operation);
+        super(XOpenSQLState.SYNTAX_ERROR, 46, "%s ... LIMIT can not support route to multiple data nodes", operation);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLWithMultipleShardingTablesException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLWithMultipleShardingTablesException.java
index 91901fe6d6d..66afb124fc4 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLWithMultipleShardingTablesException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DMLWithMultipleShardingTablesException.java
@@ -30,6 +30,6 @@ public final class DMLWithMultipleShardingTablesException extends ShardingSQLExc
     private static final long serialVersionUID = -7368310216924145478L;
     
     public DMLWithMultipleShardingTablesException(final Collection<String> tableNames) {
-        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 25, "Can not support DML operation with multiple tables `%s`", tableNames.toString());
+        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 45, "Can not support DML operation with multiple tables `%s`", tableNames.toString());
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DataSourceIntersectionNotFoundException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DataSourceIntersectionNotFoundException.java
index 929890e032d..cc5665c7617 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DataSourceIntersectionNotFoundException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/DataSourceIntersectionNotFoundException.java
@@ -30,6 +30,6 @@ public final class DataSourceIntersectionNotFoundException extends ShardingSQLEx
     private static final long serialVersionUID = -2142571707728236489L;
     
     public DataSourceIntersectionNotFoundException(final Collection<String> logicTables) {
-        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 27, "Can not find actual data source intersection for logic tables `%s`", logicTables);
+        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 47, "Can not find actual data source intersection for logic tables `%s`", logicTables);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/InsertSelectTableViolationException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/InsertSelectTableViolationException.java
index e0d6a1efded..f59caf3b614 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/InsertSelectTableViolationException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/InsertSelectTableViolationException.java
@@ -28,6 +28,6 @@ public final class InsertSelectTableViolationException extends ShardingSQLExcept
     private static final long serialVersionUID = 1221612068163533037L;
     
     public InsertSelectTableViolationException() {
-        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 24, "The table inserted and the table selected must be the same or bind tables");
+        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 44, "The table inserted and the table selected must be the same or bind tables");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/MissingGenerateKeyColumnWithInsertSelectException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/MissingGenerateKeyColumnWithInsertSelectException.java
index e17c1084b66..f13d9c6c738 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/MissingGenerateKeyColumnWithInsertSelectException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/MissingGenerateKeyColumnWithInsertSelectException.java
@@ -28,6 +28,6 @@ public final class MissingGenerateKeyColumnWithInsertSelectException extends Sha
     private static final long serialVersionUID = 568269722599010228L;
     
     public MissingGenerateKeyColumnWithInsertSelectException() {
-        super(XOpenSQLState.SYNTAX_ERROR, 28, "INSERT INTO ... SELECT can not support applying key generator with absent generate key column");
+        super(XOpenSQLState.SYNTAX_ERROR, 48, "INSERT INTO ... SELECT can not support applying key generator with absent generate key column");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/RenamedViewWithoutSameConfigurationException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/RenamedViewWithoutSameConfigurationException.java
index bef979b7f08..18aa8c32081 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/RenamedViewWithoutSameConfigurationException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/RenamedViewWithoutSameConfigurationException.java
@@ -28,6 +28,6 @@ public final class RenamedViewWithoutSameConfigurationException extends Sharding
     private static final long serialVersionUID = -8276278970848162458L;
     
     public RenamedViewWithoutSameConfigurationException(final String originView, final String targetView) {
-        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 29, "Alter view rename .. to .. statement should have same config for %s and %s", originView, targetView);
+        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 49, "Alter view rename .. to .. statement should have same config for %s and %s", originView, targetView);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedCreateViewException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedCreateViewException.java
index d9767f01179..1c83f21c102 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedCreateViewException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedCreateViewException.java
@@ -28,6 +28,6 @@ public final class UnsupportedCreateViewException extends ShardingSQLException {
     private static final long serialVersionUID = -321126834428609310L;
     
     public UnsupportedCreateViewException() {
-        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 22, "The CREATE VIEW statement contains unsupported query statement");
+        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 42, "The CREATE VIEW statement contains unsupported query statement");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedPrepareRouteToSameDataSourceException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedPrepareRouteToSameDataSourceException.java
index a5e5f520bf9..21bf30f1e5e 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedPrepareRouteToSameDataSourceException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedPrepareRouteToSameDataSourceException.java
@@ -28,6 +28,6 @@ public final class UnsupportedPrepareRouteToSameDataSourceException extends Shar
     private static final long serialVersionUID = -451667286925533523L;
     
     public UnsupportedPrepareRouteToSameDataSourceException() {
-        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 23, "PREPARE statement can not support sharding tables route to same data sources");
+        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 43, "PREPARE statement can not support sharding tables route to same data sources");
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedShardingOperationException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedShardingOperationException.java
index 91e8962d180..8486e97074d 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedShardingOperationException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedShardingOperationException.java
@@ -28,6 +28,6 @@ public final class UnsupportedShardingOperationException extends ShardingSQLExce
     private static final long serialVersionUID = 1009938372927671322L;
     
     public UnsupportedShardingOperationException(final String operation, final String tableName) {
-        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 20, "Can not support operation `%s` with sharding table `%s`", operation, tableName);
+        super(XOpenSQLState.FEATURE_NOT_SUPPORTED, 40, "Can not support operation `%s` with sharding table `%s`", operation, tableName);
     }
 }
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedUpdatingShardingValueException.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedUpdatingShardingValueException.java
index f9c1bf5c5a1..7b2e641571a 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedUpdatingShardingValueException.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/exception/syntax/UnsupportedUpdatingShardingValueException.java
@@ -28,6 +28,6 @@ public final class UnsupportedUpdatingShardingValueException extends ShardingSQL
     private static final long serialVersionUID = 2552228890146113383L;
     
     public UnsupportedUpdatingShardingValueException(final String tableName) {
-        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 21, "Can not update sharding value for table `%s`", tableName);
+        super(XOpenSQLState.CHECK_OPTION_VIOLATION, 41, "Can not update sharding value for table `%s`", tableName);
     }
 }
diff --git a/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedDatabaseException.java b/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedDatabaseException.java
index f18f107a4f4..d17ff579430 100644
--- a/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedDatabaseException.java
+++ b/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedDatabaseException.java
@@ -29,6 +29,6 @@ public final class UnsupportedTranslatedDatabaseException extends SQLTranslation
     private static final long serialVersionUID = -8311552562051028033L;
     
     public UnsupportedTranslatedDatabaseException(final DatabaseType databaseType) {
-        super(XOpenSQLState.SYNTAX_ERROR, 20, "Can not support database `%s` in SQL translation", databaseType.getType());
+        super(XOpenSQLState.SYNTAX_ERROR, 40, "Can not support database `%s` in SQL translation", databaseType.getType());
     }
 }
diff --git a/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedSQLException.java b/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedSQLException.java
index 24642a9ef18..18f6e523b83 100644
--- a/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedSQLException.java
+++ b/shardingsphere-kernel/shardingsphere-sql-translator/shardingsphere-sql-translator-api/src/main/java/org/apache/shardingsphere/sqltranslator/exception/syntax/UnsupportedTranslatedSQLException.java
@@ -28,6 +28,6 @@ public final class UnsupportedTranslatedSQLException extends SQLTranslationExcep
     private static final long serialVersionUID = -1419778194546662319L;
     
     public UnsupportedTranslatedSQLException(final String sql) {
-        super(XOpenSQLState.SYNTAX_ERROR, 21, "Translation error, SQL is: %s", sql);
+        super(XOpenSQLState.SYNTAX_ERROR, 41, "Translation error, SQL is: %s", sql);
     }
 }