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 <[email protected]>
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>
