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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
