You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/07/05 02:30:56 UTC
[GitHub] [shardingsphere] JiekerTime commented on a change in pull request #11113: support ddl cases of encrypt scenario and bind some issue
JiekerTime commented on a change in pull request #11113:
URL: https://github.com/apache/shardingsphere/pull/11113#discussion_r663602760
##########
File path: shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
##########
@@ -21,125 +21,128 @@
<initial-sql affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="CREATE INDEX t_order_details_index ON t_order_details (id)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="create_index.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="CREATE UNIQUE INDEX t_order_details_index ON t_order_details (id)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="create_unique_index.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="ALTER TABLE t_order_details ADD name varchar(10)" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="alter_table.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="DROP TABLE t_order_details" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="drop_table.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10))" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="DROP INDEX t_order_details_index ON t_order_details" db-types="MySQL,SQLServer" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="unchanged_table.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10));CREATE INDEX t_order_details_index ON t_order_details(description)" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
<test-case sql="DROP INDEX order_index" db-types="PostgreSQL,Oracle" scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion expected-data-file="unchanged_table.xml">
<initial-sql sql="CREATE TABLE t_order_details(id int, description varchar(10));CREATE INDEX order_index ON t_order_details(description)" affected-table="t_order_details" />
</assertion>
</test-case>
-
+
Review comment:
Not yet, the PR here just provides a way to review the issue.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org