This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin 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 464158cf4c2 Minor refactor for ddl e2e test case (#29697)
464158cf4c2 is described below
commit 464158cf4c2688833f9b101c328dfa2346072c33
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Thu Jan 11 14:31:21 2024 +0800
Minor refactor for ddl e2e test case (#29697)
---
.../sql/src/test/resources/cases/ddl/ddl-integration-alter-table.xml | 2 +-
.../sql/src/test/resources/cases/ddl/ddl-integration-create-index.xml | 4 ++--
.../sql/src/test/resources/cases/ddl/ddl-integration-create-table.xml | 2 +-
.../sql/src/test/resources/cases/ddl/ddl-integration-drop-index.xml | 2 +-
.../sql/src/test/resources/cases/ddl/ddl-integration-drop-table.xml | 2 +-
.../e2e/sql/src/test/resources/cases/ddl/ddl-integration-truncate.xml | 2 +-
6 files changed, 7 insertions(+), 7 deletions(-)
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-alter-table.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-alter-table.xml
index 8b8d8c0c7f1..2de5a61a4ca 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-alter-table.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-alter-table.xml
@@ -73,7 +73,7 @@
</assertion>
</test-case>
- <test-case sql="ALTER TABLE t_user_details ADD name varchar(10)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="ALTER TABLE t_user_details ADD name varchar(10)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
db-types="MySQL,PostgreSQL,openGauss">
<assertion expected-data-file="alter_add.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10))" affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-index.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-index.xml
index 74e191da4f2..7c2308720a3 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-index.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-index.xml
@@ -31,7 +31,7 @@
</assertion>
</test-case>
- <test-case sql="CREATE INDEX t_user_details_index ON t_user_details
(user_id)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="CREATE INDEX t_user_details_index ON t_user_details
(user_id)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
db-types="MySQL,PostgreSQL,openGauss">
<assertion expected-data-file="create_index.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10))" affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
@@ -52,7 +52,7 @@
</assertion>
</test-case>
- <test-case sql="CREATE UNIQUE INDEX t_user_details_index ON t_user_details
(user_id)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="CREATE UNIQUE INDEX t_user_details_index ON t_user_details
(user_id)"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
db-types="MySQL,PostgreSQL,openGauss">
<assertion expected-data-file="create_unique_index.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10))" affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-table.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-table.xml
index e0b31347140..8586a21b1d8 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-table.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-create-table.xml
@@ -31,7 +31,7 @@
</assertion>
</test-case>
- <test-case sql="CREATE TABLE t_user_details (user_id INT NOT NULL,
address_id INT NOT NULL, number VARCHAR(45), description varchar(10))"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="CREATE TABLE t_user_details (user_id INT NOT NULL,
address_id INT NOT NULL, number VARCHAR(45), description varchar(10))"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
db-types="MySQL,PostgreSQL,openGauss">
<assertion expected-data-file="create_table.xml">
<initial-sql affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-index.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-index.xml
index feb267d9932..d8d5196295a 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-index.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-index.xml
@@ -17,7 +17,7 @@
-->
<integration-test-cases>
- <test-case sql="DROP INDEX t_user_details_index ON t_user_details"
db-types="MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="DROP INDEX t_user_details_index ON t_user_details"
db-types="MySQL"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="unchanged_table.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10));CREATE INDEX t_user_details_index ON t_user_details(description)"
affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-table.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-table.xml
index 390e75ee970..ae4ee5a5440 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-table.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-drop-table.xml
@@ -29,7 +29,7 @@
</assertion>
</test-case>
- <test-case sql="DROP TABLE t_user_details"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="DROP TABLE t_user_details"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting"
db-types="MySQL,PostgreSQL,openGauss">
<assertion expected-data-file="drop_table.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10))" affected-table="t_user_details" />
</assertion>
diff --git
a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-truncate.xml
b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-truncate.xml
index 241c12f88ad..0a50d03aa0e 100644
--- a/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-truncate.xml
+++ b/test/e2e/sql/src/test/resources/cases/ddl/ddl-integration-truncate.xml
@@ -45,7 +45,7 @@
</assertion>
</test-case>
- <test-case sql="TRUNCATE TABLE t_user_details"
db-types="MySQL,SQLServer,Oracle"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
+ <test-case sql="TRUNCATE TABLE t_user_details" db-types="MySQL"
scenario-types="encrypt,dbtbl_with_readwrite_splitting_and_encrypt,sharding_and_encrypt,encrypt_and_readwrite_splitting">
<assertion expected-data-file="unchanged_table.xml">
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT
NULL, address_id INT NOT NULL, number_cipher VARCHAR(45) NULL, description
varchar(10))" affected-table="t_user_details" />
<destroy-sql sql="DROP TABLE t_user_details" />
