You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by to...@apache.org on 2022/07/08 02:48:36 UTC
[shardingsphere] branch master updated: Add test cases in PostgreSQL (#18930)
This is an automated email from the ASF dual-hosted git repository.
totalo 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 492e0bb1b3a Add test cases in PostgreSQL (#18930)
492e0bb1b3a is described below
commit 492e0bb1b3a29c59a7219a065ae45065827a50d7
Author: RunQi Zhao <40...@users.noreply.github.com>
AuthorDate: Fri Jul 8 10:48:29 2022 +0800
Add test cases in PostgreSQL (#18930)
* Add test cases
* fix ci
* fix ci
* fix ci
---
.../resources/cases/dal/dal-integration-test-cases.xml | 2 ++
.../resources/cases/dcl/dcl-integration-test-cases.xml | 1 +
.../resources/cases/ddl/ddl-integration-test-cases.xml | 16 +++++++++++++++-
.../tcl-integration-test-cases.xml} | 4 +---
4 files changed, 19 insertions(+), 4 deletions(-)
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml
index cd92e0682c5..8f9f1b406d6 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml
@@ -18,4 +18,6 @@
<test-case sql="SHOW DATABASES" db-types="MySQL" scenario-types="dbtbl_with_readwrite_splitting,readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
<assertion expected-data-file="show_databases.xml" />
</test-case>
+
+ <test-case sql="RESET ALL" db-types="PostgreSQL,openGauss" />
</integration-test-cases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dcl/dcl-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dcl/dcl-integration-test-cases.xml
index 43b6decb0a6..68beb03f36b 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dcl/dcl-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dcl/dcl-integration-test-cases.xml
@@ -178,4 +178,5 @@
<test-case sql="REVOKE SELECT ON t_order FROM user_dev" db-types="SQLServer" />
<test-case sql="SET ROLE ALL EXCEPT role_dev" db-types="MySQL" />
<test-case sql="SET ROLE ALL EXCEPT role_dev, role2" db-types="MySQL" />
+ <test-case sql="REASSIGN OWNED BY regress_dep_user0 TO regress_dep_user1" db-types="PostgreSQL" />
</integration-test-cases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
index 596f95e609b..bf299c813c8 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/ddl/ddl-integration-test-cases.xml
@@ -243,6 +243,20 @@
<initial-sql sql="CREATE TABLE t_user_details (user_id INT NOT NULL, address_id INT NOT NULL, number_plain VARCHAR(45) NULL, number_cipher VARCHAR(45) NULL, description varchar(10))" affected-table="t_user_details" />
</assertion>
</test-case>
-
+
+ <test-case sql="LISTEN notify_async2" db-types="PostgreSQL" />
+
+ <test-case sql="NOTIFY notify_async2" db-types="PostgreSQL" />
+
+ <test-case sql="UNLISTEN notify_async2" db-types="PostgreSQL" />
+
+ <test-case sql="REINDEX (CONCURRENTLY) TABLE t_user_details" db-types="PostgreSQL" />
+
+ <test-case sql="SECURITY LABEL ON TABLE t_user_details IS 'classified'" db-types="PostgreSQL" />
+
+ <test-case sql="MOVE BACKWARD ALL FROM t_user_details" db-types="PostgreSQL" />
+
+ <test-case sql="REFRESH MATERIALIZED VIEW CONCURRENTLY mvtest_boxmv" db-types="PostgreSQL" />
+
<!-- TODO add single table DDL test cases -->
</integration-test-cases>
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/tcl/tcl-integration-test-cases.xml
similarity index 78%
copy from shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml
copy to shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/tcl/tcl-integration-test-cases.xml
index cd92e0682c5..652341a871f 100644
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dal/dal-integration-test-cases.xml
+++ b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/tcl/tcl-integration-test-cases.xml
@@ -15,7 +15,5 @@
~ limitations under the License.
-->
<integration-test-cases>
- <test-case sql="SHOW DATABASES" db-types="MySQL" scenario-types="dbtbl_with_readwrite_splitting,readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt">
- <assertion expected-data-file="show_databases.xml" />
- </test-case>
+ <test-case sql="PREPARE TRANSACTION 'foo1" db-types="PostgreSQL" />
</integration-test-cases>