This is an automated email from the ASF dual-hosted git repository.
sunnianjun 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 f4e30ffe03d Add more integration test for PostgreSQL and openGauss
combine statement (#22726)
f4e30ffe03d is described below
commit f4e30ffe03d5409b46f8b77b90f8bd69b4406e2a
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Wed Dec 7 20:10:29 2022 +0800
Add more integration test for PostgreSQL and openGauss combine statement
(#22726)
---
.../cases/dql/dql-integration-test-cases.xml | 88 ++++++++++++++++++++++
1 file changed, 88 insertions(+)
diff --git
a/test/e2e/suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
b/test/e2e/suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
index de80cae7810..8bfae909e52 100644
--- a/test/e2e/suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
+++ b/test/e2e/suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
@@ -968,6 +968,94 @@
<test-case sql="SELECT o.user_id FROM t_order o WHERE o.order_id > ? MINUS
SELECT u.user_id FROM t_user u ORDER BY user_id" db-types="openGauss"
scenario-types="db">
<assertion parameters="2500:long"
expected-data-source-name="read_dataset" />
</test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order) INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order EXCEPT SELECT * FROM t_order WHERE order_id = ? ORDER BY order_id"
db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION (SELECT *
FROM t_order EXCEPT SELECT * FROM t_order WHERE order_id = ?) ORDER BY
order_id" db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order MINUS SELECT * FROM t_order WHERE order_id = ? ORDER BY order_id"
db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION (SELECT *
FROM t_order MINUS SELECT * FROM t_order WHERE order_id = ?) ORDER BY order_id"
db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order INTERSECT SELECT * FROM t_order WHERE order_id = ? EXCEPT SELECT *
FROM t_order WHERE order_id = ? ORDER BY order_id"
db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long,1000:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order) INTERSECT (SELECT * FROM t_order WHERE order_id = ? EXCEPT SELECT
* FROM t_order WHERE order_id = ?) ORDER BY order_id"
db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long,1000:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order INTERSECT SELECT * FROM t_order WHERE order_id = ? MINUS SELECT *
FROM t_order WHERE order_id = ? ORDER BY order_id" db-types="openGauss"
scenario-types="db">
+ <assertion parameters="2500:long,2900:long,1000:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order WHERE order_id = ? UNION SELECT *
FROM t_order) INTERSECT (SELECT * FROM t_order WHERE order_id = ? MINUS SELECT
* FROM t_order WHERE order_id = ?) ORDER BY order_id" db-types="openGauss"
scenario-types="db">
+ <assertion parameters="2500:long,2900:long,1000:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order EXCEPT SELECT * FROM t_order WHERE
order_id = ? INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order EXCEPT SELECT * FROM t_order WHERE
order_id = ?) INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order MINUS SELECT * FROM t_order WHERE
order_id = ? INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order MINUS SELECT * FROM t_order WHERE
order_id = ?) INTERSECT SELECT * FROM t_order WHERE order_id = ? ORDER BY
order_id" db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order EXCEPT SELECT * FROM t_order WHERE
order_id = ? UNION SELECT * FROM t_order WHERE order_id = ? ORDER BY order_id"
db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order EXCEPT (SELECT * FROM t_order WHERE
order_id = ? UNION SELECT * FROM t_order WHERE order_id = ?) ORDER BY order_id"
db-types="PostgreSQL,openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order MINUS SELECT * FROM t_order WHERE
order_id = ? UNION SELECT * FROM t_order WHERE order_id = ? ORDER BY order_id"
db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order MINUS (SELECT * FROM t_order WHERE
order_id = ? UNION SELECT * FROM t_order WHERE order_id = ?) ORDER BY order_id"
db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order EXCEPT SELECT * FROM t_order
INTERSECT SELECT * FROM t_order WHERE order_id = ? UNION SELECT * FROM t_order
WHERE order_id = ? ORDER BY order_id" db-types="PostgreSQL,openGauss"
scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order EXCEPT SELECT * FROM t_order)
INTERSECT (SELECT * FROM t_order WHERE order_id = ? UNION SELECT * FROM t_order
WHERE order_id = ?) ORDER BY order_id" db-types="PostgreSQL,openGauss"
scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="SELECT * FROM t_order MINUS SELECT * FROM t_order
INTERSECT SELECT * FROM t_order WHERE order_id = ? UNION SELECT * FROM t_order
WHERE order_id = ? ORDER BY order_id" db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
+
+ <test-case sql="(SELECT * FROM t_order MINUS SELECT * FROM t_order)
INTERSECT (SELECT * FROM t_order WHERE order_id = ? UNION SELECT * FROM t_order
WHERE order_id = ?) ORDER BY order_id" db-types="openGauss" scenario-types="db">
+ <assertion parameters="2500:long,2900:long"
expected-data-source-name="read_dataset" />
+ </test-case>
<!-- TODO FIX ME Expected: is "true" but was "1"-->
<!-- <test-case sql="SELECT order_id, user_id, order_name, type_char,
type_boolean, type_smallint, type_enum, type_decimal, type_date, type_time,
type_timestamp FROM t_shadow WHERE user_id = ?" db-types="MySQL"
scenario-types="sharding_and_shadow">-->
