This is an automated email from the ASF dual-hosted git repository.
chengzhang 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 8f1a33c3aec Fix nightly sql federation e2e test case caused by result
set order (#30668)
8f1a33c3aec is described below
commit 8f1a33c3aecdbf11c394918e160861a7f1df1dad
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Wed Mar 27 17:28:50 2024 +0800
Fix nightly sql federation e2e test case caused by result set order (#30668)
---
.../src/test/resources/cases/dql/dql-integration-select-aggregate.xml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-aggregate.xml
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-aggregate.xml
index 8654d57d365..7442da9e906 100644
---
a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-aggregate.xml
+++
b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-aggregate.xml
@@ -121,11 +121,11 @@
<assertion expected-data-source-name="read_dataset" />
</test-case>-->
- <test-case sql="SELECT MIN(o.order_id), MIN(o.merchant_id), i.product_id
FROM t_order o INNER JOIN t_order_item i ON o.order_id = i.order_id WHERE
o.user_id = ? GROUP BY i.product_id" db-types="MySQL,PostgreSQL,openGauss"
scenario-types="db_tbl_sql_federation">
+ <test-case sql="SELECT MIN(o.order_id), MIN(o.merchant_id), i.product_id
FROM t_order o INNER JOIN t_order_item i ON o.order_id = i.order_id WHERE
o.user_id = ? GROUP BY i.product_id ORDER BY i.product_id"
db-types="MySQL,PostgreSQL,openGauss" scenario-types="db_tbl_sql_federation">
<assertion parameters="10:int"
expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT MIN(o.order_id), MIN(o.merchant_id),
MIN(m.merchant_name) FROM t_order o INNER JOIN t_merchant m ON o.merchant_id =
m.merchant_id WHERE o.user_id = ? GROUP BY m.merchant_id"
db-types="MySQL,PostgreSQL,openGauss" scenario-types="db_tbl_sql_federation">
+ <test-case sql="SELECT MIN(o.order_id), MIN(o.merchant_id),
MIN(m.merchant_name) FROM t_order o INNER JOIN t_merchant m ON o.merchant_id =
m.merchant_id WHERE o.user_id = ? GROUP BY m.merchant_id ORDER BY
m.merchant_id" db-types="MySQL,PostgreSQL,openGauss"
scenario-types="db_tbl_sql_federation">
<assertion parameters="10:int"
expected-data-source-name="read_dataset" />
</test-case>
