You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by yx...@apache.org on 2023/02/17 13:48:06 UTC
[shardingsphere] branch master updated: Remove CreateTrafficRuleStatement & DropTrafficRuleStatement (#24222)
This is an automated email from the ASF dual-hosted git repository.
yx9o 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 0f7f4b1eac1 Remove CreateTrafficRuleStatement & DropTrafficRuleStatement (#24222)
0f7f4b1eac1 is described below
commit 0f7f4b1eac1b62a45d0ae50b5bcc74cfa8339732
Author: Raigor <ra...@gmail.com>
AuthorDate: Fri Feb 17 21:47:57 2023 +0800
Remove CreateTrafficRuleStatement & DropTrafficRuleStatement (#24222)
---
.../ral/global-rule/alter-sql-parser-rule.cn.md | 2 +-
.../ral/global-rule/alter-sql-parser-rule.en.md | 2 +-
.../ral/global-rule/create-traffic-rule.cn.md | 71 ----------------------
.../ral/global-rule/create-traffic-rule.en.md | 71 ----------------------
.../syntax/ral/global-rule/drop-traffic-rule.cn.md | 46 --------------
.../syntax/ral/global-rule/drop-traffic-rule.en.md | 46 --------------
.../rql/rule-query/shadow/show-shadow-rule.cn.md | 2 +-
.../rql/rule-query/shadow/show-shadow-rule.en.md | 2 +-
.../main/antlr4/imports/traffic/RALStatement.g4 | 8 ---
.../parser/autogen/TrafficDistSQLStatement.g4 | 2 -
.../core/TrafficDistSQLStatementVisitor.java | 15 -----
.../updatable/CreateTrafficRuleStatement.java | 35 -----------
.../updatable/DropTrafficRuleStatement.java | 36 -----------
.../ral/impl/UpdatableRALStatementAssert.java | 10 ---
.../CreateTrafficRuleStatementAssert.java | 68 ---------------------
.../updatable/DropTrafficRuleStatementAssert.java | 54 ----------------
.../cases/parser/jaxb/RootSQLParserTestCases.java | 8 ---
.../ral/CreateTrafficRuleStatementTestCase.java | 36 -----------
.../ral/DropTrafficRuleStatementTestCase.java | 36 -----------
.../src/main/resources/case/ral/updatable.xml | 28 ---------
.../main/resources/sql/supported/ral/updatable.xml | 4 --
21 files changed, 4 insertions(+), 578 deletions(-)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.cn.md
index 8de22e3091a..01354cf2361 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.cn.md
@@ -55,7 +55,7 @@ concurrencyLevel ::=
ALTER SQL_PARSER RULE
SQL_COMMENT_PARSE_ENABLE=false,
PARSE_TREE_CACHE(INITIAL_CAPACITY=10, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=1),
- SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100)；
+ SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100);
```
### 保留字
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.en.md
index 51c32aa7c51..9eb73b9b627 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/alter-sql-parser-rule.en.md
@@ -55,7 +55,7 @@ concurrencyLevel ::=
ALTER SQL_PARSER RULE
SQL_COMMENT_PARSE_ENABLE=false,
PARSE_TREE_CACHE(INITIAL_CAPACITY=10, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=1),
- SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100)；
+ SQL_STATEMENT_CACHE(INITIAL_CAPACITY=11, MAXIMUM_SIZE=11, CONCURRENCY_LEVEL=100);
```
### Reserved word
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.cn.md
deleted file mode 100644
index 016fc022276..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.cn.md
+++ /dev/null
@@ -1,71 +0,0 @@
-+++
-title = "CREATE TRAFFIC RULE"
-weight = 7
-+++
-
-## 描述
-
-`CREATE TRAFFIC RULE` 语法用于创建双路由规则
-
-### 语法定义
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-CreateTrafficRule ::=
- 'CREATE' 'TRAFFIC' 'RULE' '(' 'LABELS' '(' lableName ')' ',' trafficAlgorithmDefinition ',' loadBalancerDefinition ')'
-
-lableName ::=
- identifier
-
-trafficAlgorithmDefinition ::=
- 'TRAFFIC_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' trafficAlgorithmTypeName (',' propertiesDefinition)? ')' ')'
-
-loadBalancerDefinition ::=
- 'LOAD_BALANCER' '(' 'TYPE' '(' 'NAME' '=' loadBalancerName (',' propertiesDefinition)? ')' ')'
-
-propertiesDefinition ::=
- 'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
-
-trafficAlgorithmTypeName ::=
- string
-
-loadBalancerTypeName ::=
- string
-
-key ::=
- string
-
-value ::=
- literal
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 补充说明
-
-- `TRAFFIC_ALGORITHM` 支持 `SQL_MATCH` 与 `SQL_HINT` 两种类型
-
-- `LOAD_BALANCER` 支持 `RANDOM` 与 `ROUND_ROBIN` 两种类型
-
-### 示例
-
-- 创建双路由规则
-
-```sql
-CREATE TRAFFIC RULE sql_match_traffic (
- LABELS (OLTP),
- TRAFFIC_ALGORITHM(TYPE(NAME="SQL_MATCH",PROPERTIES("sql" = "SELECT * FROM t_order WHERE order_id = 1; UPDATE t_order SET order_id = 5;"))),
- LOAD_BALANCER(TYPE(NAME="RANDOM")));
-```
-
-### 保留字
-
-`CREATE`、`TRAFFIC`、`RULE`、`LABELS`、`TYPE`、`NAME`、`PROPERTIES`、`TRAFFIC_ALGORITHM`、`LOAD_BALANCER`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.en.md
deleted file mode 100644
index 8d3a88aaaff..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/create-traffic-rule.en.md
+++ /dev/null
@@ -1,71 +0,0 @@
-+++
-title = "CREATE TRAFFIC RULE"
-weight = 7
-+++
-
-### Description
-
-The `CREATE TRAFFIC RULE` syntax is used to create dual routing rule.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-CreateTrafficRule ::=
- 'CREATE' 'TRAFFIC' 'RULE' '(' 'LABELS' '(' lableName ')' ',' trafficAlgorithmDefinition ',' loadBalancerDefinition ')'
-
-lableName ::=
- identifier
-
-trafficAlgorithmDefinition ::=
- 'TRAFFIC_ALGORITHM' '(' 'TYPE' '(' 'NAME' '=' trafficAlgorithmTypeName (',' propertiesDefinition)? ')' ')'
-
-loadBalancerDefinition ::=
- 'LOAD_BALANCER' '(' 'TYPE' '(' 'NAME' '=' loadBalancerName (',' propertiesDefinition)? ')' ')'
-
-propertiesDefinition ::=
- 'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
-
-trafficAlgorithmTypeName ::=
- string
-
-loadBalancerTypeName ::=
- string
-
-key ::=
- string
-
-value ::=
- literal
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Supplement
-
-- `TRAFFIC_ALGORITHM` support `SQL_MATCH` and `SQL_HINT` two types;
-
-- `LOAD_BALANCER` support `RANDOM` and `ROUND_ROBIN` two types.
-
-### Example
-
-- Create dual routing rule
-
-```sql
-CREATE TRAFFIC RULE sql_match_traffic (
- LABELS (OLTP),
- TRAFFIC_ALGORITHM(TYPE(NAME="SQL_MATCH",PROPERTIES("sql" = "SELECT * FROM t_order WHERE order_id = 1; UPDATE t_order SET order_id = 5;"))),
- LOAD_BALANCER(TYPE(NAME="RANDOM")));
-```
-
-### Reserved word
-
-`CREATE`, `TRAFFIC`, `RULE`, `LABELS`, `TYPE`, `NAME`, `PROPERTIES`, `TRAFFIC_ALGORITHM`, `LOAD_BALANCER`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.cn.md
deleted file mode 100644
index c00cb934068..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.cn.md
+++ /dev/null
@@ -1,46 +0,0 @@
-+++
-title = "DROP TRAFFIC RULE"
-weight = 10
-+++
-
-### 描述
-
-`DROP TRAFFIC RULE` 语法用于删除指定的双路由规则
-### 语法
-
-{{< tabs >}}
-{{% tab name="语法" %}}
-```sql
-DropTrafficRule ::=
- 'DROP' 'TRAFFIC' 'RULE' ruleName (',' ruleName)?
-
-ruleName ::=
- identifier
-```
-{{% /tab %}}
-{{% tab name="铁路图" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### 示例
-
-- 删除指定双路由规则
-
-```sql
-DROP TRAFFIC RULE sql_match_traffic;
-```
-
-- 删除多个双路由规则
-
-```sql
-DROP TRAFFIC RULE sql_match_traffic, sql_hint_traffic;
-```
-
-### 保留字
-
-`DROP`、`TRAFFIC`、`RULE`
-
-### 相关链接
-
-- [保留字](/cn/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.en.md
deleted file mode 100644
index 17a56ecd18c..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/global-rule/drop-traffic-rule.en.md
+++ /dev/null
@@ -1,46 +0,0 @@
-+++
-title = "DROP TRAFFIC RULE"
-weight = 10
-+++
-
-### Description
-
-The `DROP TRAFFIC RULE` syntax is used to drop specified dual routing rule.
-
-### Syntax
-
-{{< tabs >}}
-{{% tab name="Grammar" %}}
-```sql
-DropTrafficRule ::=
- 'DROP' 'TRAFFIC' 'RULE' ruleName (',' ruleName)?
-
-ruleName ::=
- identifier
-```
-{{% /tab %}}
-{{% tab name="Railroad diagram" %}}
-<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe>
-{{% /tab %}}
-{{< /tabs >}}
-
-### Example
-
-- Drop specified traffic rule
-
-```sql
-DROP TRAFFIC RULE sql_match_traffic;
-```
-
-- Drop mutiple traffic rules
-```sql
-DROP TRAFFIC RULE sql_match_traffic, sql_hint_traffic;
-```
-
-### Reserved word
-
-`DROP`, `TRAFFIC`, `RULE`
-
-### Related links
-
-- [Reserved word](/en/user-manual/shardingsphere-proxy/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.cn.md
index b9eb8b37610..d8ecfd35bd0 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.cn.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.cn.md
@@ -61,7 +61,7 @@ mysql> SHOW SHADOW RULE shadow_rule FROM shadow_db;
- 查询当前逻辑库中的指定影子规则
```sql
-SHOW SHADOW RULE shadow_rule；
+SHOW SHADOW RULE shadow_rule;
```
```sql
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.en.md b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.en.md
index 959eb5c5ed5..d40299fa976 100644
--- a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.en.md
+++ b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rql/rule-query/shadow/show-shadow-rule.en.md
@@ -64,7 +64,7 @@ mysql> SHOW SHADOW RULE shadow_rule FROM shadow_db;
- Query specified shadow rule in current database.
```sql
-SHOW SHADOW RULE shadow_rule；
+SHOW SHADOW RULE shadow_rule;
```
```sql
diff --git a/kernel/traffic/distsql/parser/src/main/antlr4/imports/traffic/RALStatement.g4 b/kernel/traffic/distsql/parser/src/main/antlr4/imports/traffic/RALStatement.g4
index 14c406cac48..31a858f11cd 100644
--- a/kernel/traffic/distsql/parser/src/main/antlr4/imports/traffic/RALStatement.g4
+++ b/kernel/traffic/distsql/parser/src/main/antlr4/imports/traffic/RALStatement.g4
@@ -19,18 +19,10 @@ grammar RALStatement;
import BaseRule;
-createTrafficRule
- : CREATE TRAFFIC RULE trafficRuleDefinition (COMMA_ trafficRuleDefinition)*
- ;
-
alterTrafficRule
: ALTER TRAFFIC RULE trafficRuleDefinition (COMMA_ trafficRuleDefinition)*
;
-dropTrafficRule
- : DROP TRAFFIC RULE ifExists? ruleName (COMMA_ ruleName)*
- ;
-
showTrafficRules
: SHOW TRAFFIC (RULES | RULE ruleName)
;
diff --git a/kernel/traffic/distsql/parser/src/main/antlr4/org/apache/shardingsphere/distsql/parser/autogen/TrafficDistSQLStatement.g4 b/kernel/traffic/distsql/parser/src/main/antlr4/org/apache/shardingsphere/distsql/parser/autogen/TrafficDistSQLStatement.g4
index f67537baaf7..4e7f935bc6a 100644
--- a/kernel/traffic/distsql/parser/src/main/antlr4/org/apache/shardingsphere/distsql/parser/autogen/TrafficDistSQLStatement.g4
+++ b/kernel/traffic/distsql/parser/src/main/antlr4/org/apache/shardingsphere/distsql/parser/autogen/TrafficDistSQLStatement.g4
@@ -21,8 +21,6 @@ import Symbol, RALStatement;
execute
: (showTrafficRules
- | createTrafficRule
| alterTrafficRule
- | dropTrafficRule
) SEMI?
;
diff --git a/kernel/traffic/distsql/parser/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/core/TrafficDistSQLStatementVisitor.java b/kernel/traffic/distsql/parser/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/core/TrafficDistSQLStatementVisitor.java
index 123ee1134d4..7227f3be28e 100644
--- a/kernel/traffic/distsql/parser/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/core/TrafficDistSQLStatementVisitor.java
+++ b/kernel/traffic/distsql/parser/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/core/TrafficDistSQLStatementVisitor.java
@@ -21,8 +21,6 @@ import org.antlr.v4.runtime.tree.ParseTree;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementBaseVisitor;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.AlgorithmDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.AlterTrafficRuleContext;
-import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.CreateTrafficRuleContext;
-import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.DropTrafficRuleContext;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.LabelDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.LoadBalancerDefinitionContext;
import org.apache.shardingsphere.distsql.parser.autogen.TrafficDistSQLStatementParser.PropertiesDefinitionContext;
@@ -36,8 +34,6 @@ import org.apache.shardingsphere.sql.parser.sql.common.value.identifier.Identifi
import org.apache.shardingsphere.traffic.distsql.parser.segment.TrafficRuleSegment;
import org.apache.shardingsphere.traffic.distsql.parser.statement.queryable.ShowTrafficRulesStatement;
import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.AlterTrafficRuleStatement;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.CreateTrafficRuleStatement;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.DropTrafficRuleStatement;
import java.util.Collection;
import java.util.Collections;
@@ -49,11 +45,6 @@ import java.util.stream.Collectors;
*/
public final class TrafficDistSQLStatementVisitor extends TrafficDistSQLStatementBaseVisitor<ASTNode> implements SQLVisitor {
- @Override
- public ASTNode visitCreateTrafficRule(final CreateTrafficRuleContext ctx) {
- return new CreateTrafficRuleStatement(ctx.trafficRuleDefinition().stream().map(each -> (TrafficRuleSegment) visit(each)).collect(Collectors.toList()));
- }
-
@Override
public ASTNode visitAlterTrafficRule(final AlterTrafficRuleContext ctx) {
return new AlterTrafficRuleStatement(ctx.trafficRuleDefinition().stream().map(each -> (TrafficRuleSegment) visit(each)).collect(Collectors.toList()));
@@ -91,12 +82,6 @@ public final class TrafficDistSQLStatementVisitor extends TrafficDistSQLStatemen
return result;
}
- @Override
- public ASTNode visitDropTrafficRule(final DropTrafficRuleContext ctx) {
- Collection<String> ruleNames = null == ctx.ruleName() ? null : ctx.ruleName().stream().map(this::getIdentifierValue).collect(Collectors.toSet());
- return new DropTrafficRuleStatement(null != ctx.ifExists(), ruleNames);
- }
-
@Override
public ASTNode visitShowTrafficRules(final ShowTrafficRulesContext ctx) {
return new ShowTrafficRulesStatement(null == ctx.ruleName() ? null : getIdentifierValue(ctx.ruleName()));
diff --git a/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/CreateTrafficRuleStatement.java b/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/CreateTrafficRuleStatement.java
deleted file mode 100644
index b65f88d9d5d..00000000000
--- a/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/CreateTrafficRuleStatement.java
+++ /dev/null
@@ -1,35 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.traffic.distsql.parser.statement.updatable;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.UpdatableGlobalRuleRALStatement;
-import org.apache.shardingsphere.traffic.distsql.parser.segment.TrafficRuleSegment;
-
-import java.util.Collection;
-
-/**
- * Create traffic rule statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class CreateTrafficRuleStatement extends UpdatableGlobalRuleRALStatement {
-
- private final Collection<TrafficRuleSegment> segments;
-}
diff --git a/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/DropTrafficRuleStatement.java b/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/DropTrafficRuleStatement.java
deleted file mode 100644
index 9719ff177be..00000000000
--- a/kernel/traffic/distsql/statement/src/main/java/org/apache/shardingsphere/traffic/distsql/parser/statement/updatable/DropTrafficRuleStatement.java
+++ /dev/null
@@ -1,36 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.traffic.distsql.parser.statement.updatable;
-
-import lombok.Getter;
-import lombok.RequiredArgsConstructor;
-import org.apache.shardingsphere.distsql.parser.statement.ral.UpdatableGlobalRuleRALStatement;
-
-import java.util.Collection;
-
-/**
- * Drop traffic rule statement.
- */
-@RequiredArgsConstructor
-@Getter
-public final class DropTrafficRuleStatement extends UpdatableGlobalRuleRALStatement {
-
- private final boolean ifExists;
-
- private final Collection<String> ruleNames;
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/UpdatableRALStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/UpdatableRALStatementAssert.java
index 37e3694d707..4d81b85285e 100644
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/UpdatableRALStatementAssert.java
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/UpdatableRALStatementAssert.java
@@ -34,8 +34,6 @@ import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.r
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.AlterSQLParserRuleStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.AlterTrafficRuleStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.AlterTransactionRuleStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.CreateTrafficRuleStatementAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.DropTrafficRuleStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.ImportDatabaseConfigurationStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.LabelComputeNodeStatementAssert;
import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable.RefreshTableMetaDataStatementAssert;
@@ -46,16 +44,12 @@ import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.s
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AlterReadwriteSplittingStorageUnitStatusStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AlterSQLParserRuleStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.AlterTrafficRuleStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.CreateTrafficRuleStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.DropTrafficRuleStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ImportDatabaseConfigurationStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.LabelComputeNodeStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.RefreshTableMetaDataStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.SetDistVariableStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.UnlabelComputeNodeStatementTestCase;
import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.AlterTrafficRuleStatement;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.CreateTrafficRuleStatement;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.DropTrafficRuleStatement;
import org.apache.shardingsphere.transaction.distsql.parser.statement.updatable.AlterTransactionRuleStatement;
/**
@@ -84,10 +78,6 @@ public final class UpdatableRALStatementAssert {
RefreshTableMetaDataStatementAssert.assertIs(assertContext, (RefreshTableMetaDataStatement) actual, (RefreshTableMetaDataStatementTestCase) expected);
} else if (actual instanceof AlterSQLParserRuleStatement) {
AlterSQLParserRuleStatementAssert.assertIs(assertContext, (AlterSQLParserRuleStatement) actual, (AlterSQLParserRuleStatementTestCase) expected);
- } else if (actual instanceof DropTrafficRuleStatement) {
- DropTrafficRuleStatementAssert.assertIs(assertContext, (DropTrafficRuleStatement) actual, (DropTrafficRuleStatementTestCase) expected);
- } else if (actual instanceof CreateTrafficRuleStatement) {
- CreateTrafficRuleStatementAssert.assertIs(assertContext, (CreateTrafficRuleStatement) actual, (CreateTrafficRuleStatementTestCase) expected);
} else if (actual instanceof AlterTrafficRuleStatement) {
AlterTrafficRuleStatementAssert.assertIs(assertContext, (AlterTrafficRuleStatement) actual, (AlterTrafficRuleStatementTestCase) expected);
} else if (actual instanceof ImportDatabaseConfigurationStatement) {
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/CreateTrafficRuleStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/CreateTrafficRuleStatementAssert.java
deleted file mode 100644
index 1d1c27d2ddf..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/CreateTrafficRuleStatementAssert.java
+++ /dev/null
@@ -1,68 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable;
-
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.segment.distsql.AlgorithmAssert;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.segment.impl.distsql.ral.ExpectedTrafficRule;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.CreateTrafficRuleStatementTestCase;
-import org.apache.shardingsphere.traffic.distsql.parser.segment.TrafficRuleSegment;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.CreateTrafficRuleStatement;
-
-import java.util.Collection;
-import java.util.List;
-import java.util.Map;
-import java.util.stream.Collectors;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-import static org.hamcrest.MatcherAssert.assertThat;
-
-/**
- * Create traffic rule statement assert.
- */
-public final class CreateTrafficRuleStatementAssert {
-
- /**
- * Assert create traffic rule statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual create traffic rule statement
- * @param expected expected create traffic rule statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final CreateTrafficRuleStatement actual, final CreateTrafficRuleStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertTrafficRuleSegments(assertContext, actual.getSegments(), expected.getRules());
- }
- }
-
- private static void assertTrafficRuleSegments(final SQLCaseAssertContext assertContext, final Collection<TrafficRuleSegment> actual, final List<ExpectedTrafficRule> expected) {
- Map<String, TrafficRuleSegment> actualMap = actual.stream().collect(Collectors.toMap(TrafficRuleSegment::getName, each -> each));
- expected.forEach(each -> {
- TrafficRuleSegment actualRule = actualMap.get(each.getName());
- assertThat(actualRule.getName(), is(each.getName()));
- assertThat(actualRule.getLabels(), is(each.getLabels()));
- AlgorithmAssert.assertIs(assertContext, actualRule.getAlgorithm(), each.getTrafficAlgorithm());
- AlgorithmAssert.assertIs(assertContext, actualRule.getLoadBalancer(), each.getLoadBalancer());
- });
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/DropTrafficRuleStatementAssert.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/DropTrafficRuleStatementAssert.java
deleted file mode 100644
index 3eecd67f124..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/asserts/statement/ral/impl/updatable/DropTrafficRuleStatementAssert.java
+++ /dev/null
@@ -1,54 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.asserts.statement.ral.impl.updatable;
-
-import lombok.AccessLevel;
-import lombok.NoArgsConstructor;
-import org.apache.shardingsphere.test.it.sql.parser.internal.asserts.SQLCaseAssertContext;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.DropTrafficRuleStatementTestCase;
-import org.apache.shardingsphere.traffic.distsql.parser.statement.updatable.DropTrafficRuleStatement;
-
-import java.util.ArrayList;
-
-import static org.hamcrest.CoreMatchers.is;
-import static org.junit.Assert.assertNotNull;
-import static org.junit.Assert.assertNull;
-import static org.hamcrest.MatcherAssert.assertThat;
-
-/**
- * Drop traffic rule statement assert.
- */
-@NoArgsConstructor(access = AccessLevel.PRIVATE)
-public final class DropTrafficRuleStatementAssert {
-
- /**
- * Assert drop traffic rule statement is correct with expected parser result.
- *
- * @param assertContext assert context
- * @param actual actual drop traffic rule statement
- * @param expected expected drop traffic rule statement test case
- */
- public static void assertIs(final SQLCaseAssertContext assertContext, final DropTrafficRuleStatement actual, final DropTrafficRuleStatementTestCase expected) {
- if (null == expected) {
- assertNull(assertContext.getText("Actual statement should not exist."), actual);
- } else {
- assertNotNull(assertContext.getText("Actual statement should exist."), actual);
- assertThat(assertContext.getText("Rule name id assertion error"), new ArrayList<>(actual.getRuleNames()), is(new ArrayList<>(expected.getNames())));
- }
- }
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
index 447e3a464c3..7471b675367 100644
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
+++ b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/RootSQLParserTestCases.java
@@ -298,9 +298,7 @@ import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.s
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearReadwriteSplittingHintStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ClearShardingHintStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ConvertYamlConfigurationStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.CreateTrafficRuleStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.DiscardDistSQLStatementTestCase;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.DropTrafficRuleStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ExportDatabaseConfigurationStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.ImportDatabaseConfigurationStatementTestCase;
import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral.LabelComputeNodeStatementTestCase;
@@ -1273,9 +1271,6 @@ public final class RootSQLParserTestCases {
@XmlElement(name = "show-traffic-rules")
private final List<ShowTrafficRulesStatementTestCase> showTrafficRulesTestCases = new LinkedList<>();
- @XmlElement(name = "create-traffic-rule")
- private final List<CreateTrafficRuleStatementTestCase> createTrafficRulesTestCases = new LinkedList<>();
-
@XmlElement(name = "alter-traffic-rule")
private final List<AlterTrafficRuleStatementTestCase> alterTrafficRulesTestCases = new LinkedList<>();
@@ -1288,9 +1283,6 @@ public final class RootSQLParserTestCases {
@XmlElement(name = "alter-xa-transaction-rule")
private final List<AlterXATransactionRuleStatementTestCase> alterXATransactionRuleTestCases = new LinkedList<>();
- @XmlElement(name = "drop-traffic-rule")
- private final List<DropTrafficRuleStatementTestCase> dropTrafficRuleTestCases = new LinkedList<>();
-
@XmlElement(name = "label-compute-node")
private final List<LabelComputeNodeStatementTestCase> labelTestCases = new LinkedList<>();
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/CreateTrafficRuleStatementTestCase.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/CreateTrafficRuleStatementTestCase.java
deleted file mode 100644
index 35a371284c7..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/CreateTrafficRuleStatementTestCase.java
+++ /dev/null
@@ -1,36 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral;
-
-import lombok.Getter;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.segment.impl.distsql.ral.ExpectedTrafficRule;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
-
-import javax.xml.bind.annotation.XmlElement;
-import java.util.LinkedList;
-import java.util.List;
-
-/**
- * Create traffic rule statement test case.
- */
-@Getter
-public final class CreateTrafficRuleStatementTestCase extends SQLParserTestCase {
-
- @XmlElement(name = "rule")
- private final List<ExpectedTrafficRule> rules = new LinkedList<>();
-}
diff --git a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/DropTrafficRuleStatementTestCase.java b/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/DropTrafficRuleStatementTestCase.java
deleted file mode 100644
index 1475d318b18..00000000000
--- a/test/it/parser/src/main/java/org/apache/shardingsphere/test/it/sql/parser/internal/cases/parser/jaxb/statement/ral/DropTrafficRuleStatementTestCase.java
+++ /dev/null
@@ -1,36 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You under the Apache License, Version 2.0
- * (the "License"); you may not use this file except in compliance with
- * the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing, software
- * distributed under the License is distributed on an "AS IS" BASIS,
- * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- * See the License for the specific language governing permissions and
- * limitations under the License.
- */
-
-package org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.statement.ral;
-
-import lombok.Getter;
-import lombok.Setter;
-import org.apache.shardingsphere.test.it.sql.parser.internal.cases.parser.jaxb.SQLParserTestCase;
-
-import javax.xml.bind.annotation.XmlElement;
-import java.util.Collection;
-
-/**
- * Drop traffic rule statement test case.
- */
-@Getter
-@Setter
-public final class DropTrafficRuleStatementTestCase extends SQLParserTestCase {
-
- @XmlElement(name = "name")
- private Collection<String> names;
-}
diff --git a/test/it/parser/src/main/resources/case/ral/updatable.xml b/test/it/parser/src/main/resources/case/ral/updatable.xml
index 891f1dfe3ec..adf1eda022b 100644
--- a/test/it/parser/src/main/resources/case/ral/updatable.xml
+++ b/test/it/parser/src/main/resources/case/ral/updatable.xml
@@ -34,18 +34,6 @@
<alter-local-transaction-rule sql-case-id="alter-local-transaction-rule" />
<alter-xa-transaction-rule sql-case-id="alter-xa-transaction-rule" />
<alter-xa-transaction-rule sql-case-id="alter-xa-transaction-rule-without-quote-on-build-in-default-type-name-and-provider-type-name" />
-
- <create-traffic-rule sql-case-id="create-traffic-rule">
- <rule name="sql_match_traffic">
- <label>OLTP</label>
- <traffic-algorithm algorithm-name="SQL_MATCH">
- <property key="sql" value="SELECT * FROM t_order WHERE order_id = ?; UPDATE t_order SET order_id = ?;" />
- </traffic-algorithm>
- <load-balancer algorithm-name="RANDOM">
- <property key="key" value="value" />
- </load-balancer>
- </rule>
- </create-traffic-rule>
<alter-traffic-rule sql-case-id="alter-traffic-rule">
<rule name="sql_match_traffic">
@@ -58,22 +46,6 @@
</load-balancer>
</rule>
</alter-traffic-rule>
-
- <drop-traffic-rule sql-case-id="drop-traffic-rule">
- <name>rule_name</name>
- </drop-traffic-rule>
-
- <create-traffic-rule sql-case-id="create-traffic-rule-without-quote-on-build-in-traffic-algorithm-type-name-and-load-balancer-type-name">
- <rule name="sql_match_traffic">
- <label>OLTP</label>
- <traffic-algorithm algorithm-name="SQL_MATCH">
- <property key="sql" value="SELECT * FROM t_order WHERE order_id = ?; UPDATE t_order SET order_id = ?;" />
- </traffic-algorithm>
- <load-balancer algorithm-name="RANDOM">
- <property key="key" value="value" />
- </load-balancer>
- </rule>
- </create-traffic-rule>
<alter-compute-node sql-case-id="alter-compute-node-xa-recovery-nodes" instance-id="instance_xa_recovery" key="XA_RECOVERY_NODES" value="instance_1" />
<alter-compute-node sql-case-id="alter-compute-node-xa-recovery-nodes-with-multiple-values" instance-id="instance_xa_recovery_multiple" key="XA_RECOVERY_NODES" value="instance_1,instance_2" />
diff --git a/test/it/parser/src/main/resources/sql/supported/ral/updatable.xml b/test/it/parser/src/main/resources/sql/supported/ral/updatable.xml
index aa1ea679f86..5f047b4db75 100644
--- a/test/it/parser/src/main/resources/sql/supported/ral/updatable.xml
+++ b/test/it/parser/src/main/resources/sql/supported/ral/updatable.xml
@@ -29,11 +29,7 @@
<sql-case id="alter-local-transaction-rule" value="ALTER TRANSACTION RULE (DEFAULT='LOCAL')" db-types="ShardingSphere" />
<sql-case id="alter-xa-transaction-rule" value="ALTER TRANSACTION RULE(DEFAULT='XA', TYPE(NAME='Atomikos'))" db-types="ShardingSphere" />
<sql-case id="alter-xa-transaction-rule-without-quote-on-build-in-default-type-name-and-provider-type-name" value="ALTER TRANSACTION RULE(DEFAULT=XA, TYPE(NAME=Atomikos))" db-types="ShardingSphere" />
-
- <sql-case id="create-traffic-rule" value="CREATE TRAFFIC RULE sql_match_traffic (LABELS(OLTP),TRAFFIC_ALGORITHM(TYPE(NAME='SQL_MATCH',PROPERTIES('sql' = 'SELECT * FROM t_order WHERE order_id = ?; UPDATE t_order SET order_id = ?;'))), LOAD_BALANCER(TYPE(NAME='RANDOM', PROPERTIES('key'='value'))) )" db-types="ShardingSphere" />
<sql-case id="alter-traffic-rule" value="ALTER TRAFFIC RULE sql_match_traffic (LABELS(OLTP),TRAFFIC_ALGORITHM(TYPE(NAME='SQL_MATCH',PROPERTIES('sql' = 'SELECT * FROM t_order WHERE order_id = ?; UPDATE t_order SET order_id = ?;'))), LOAD_BALANCER(TYPE(NAME='RANDOM', PROPERTIES('key'='value'))) )" db-types="ShardingSphere" />
- <sql-case id="drop-traffic-rule" value="DROP TRAFFIC RULE rule_name" db-types="ShardingSphere" />
- <sql-case id="create-traffic-rule-without-quote-on-build-in-traffic-algorithm-type-name-and-load-balancer-type-name" value="CREATE TRAFFIC RULE sql_match_traffic (LABELS(OLTP),TRAFFIC_ALGORITHM(TYPE(NAME=SQL_MATCH,PROPERTIES('sql' = 'SELECT * FROM t_order WHERE order_id = ?; UPDATE t_order SET order_id = ?;'))), LOAD_BALANCER(TYPE(NAME=RANDOM, PROPERTIES('key'='value'))) )" db-types="ShardingSphere" />
<sql-case id="alter-compute-node-xa-recovery-nodes" value="ALTER COMPUTE NODE instance_xa_recovery SET XA_RECOVERY_NODES='instance_1'" db-types="ShardingSphere" />
<sql-case id="alter-compute-node-xa-recovery-nodes-with-multiple-values" value="ALTER COMPUTE NODE instance_xa_recovery_multiple SET XA_RECOVERY_NODES='instance_1,instance_2'" db-types="ShardingSphere" />