[shardingsphere] branch master updated: Fix integration test exception when execute federation sql in PostgreSQL (#19454)

[panjuan]

This is an automated email from the ASF dual-hosted git repository.

panjuan 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 591187371ce Fix integration test exception when execute federation sql 
in PostgreSQL (#19454)
591187371ce is described below

commit 591187371ce06e8e4bab68c4382411ba620fd9d0
Author: Zhengqiang Duan <duanzhengqi...@apache.org>
AuthorDate: Fri Jul 22 10:01:21 2022 +0800

    Fix integration test exception when execute federation sql in PostgreSQL 
(#19454)
---
 .../src/test/resources/cases/dql/dql-integration-test-cases.xml       | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
index 4a3506eae51..e9efface702 100644
--- 
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
+++ 
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml
@@ -531,7 +531,7 @@
         <assertion parameters="1000:int, 100000:int" 
expected-data-source-name="read_dataset" />
     </test-case>
     
-    <test-case sql="SELECT user_id, CONCAT('SUM:', total, '.') content FROM 
(SELECT user_id, SUM(order_id_sharding) AS total FROM t_order_federate_sharding 
GROUP BY user_id HAVING SUM(order_id_sharding) > ?) AS temp" 
db-types="MySQL,PostgreSQL" scenario-types="tbl">
+    <test-case sql="SELECT user_id, CONCAT('SUM:', total, '.') AS content FROM 
(SELECT user_id, SUM(order_id_sharding) AS total FROM t_order_federate_sharding 
GROUP BY user_id HAVING SUM(order_id_sharding) > ?) AS temp ORDER BY 
temp.user_id" db-types="MySQL,PostgreSQL" scenario-types="tbl">
         <assertion parameters="1000:int" />
     </test-case>
     
@@ -555,7 +555,7 @@
         <assertion parameters="1100:int" />
     </test-case>
     
-    <test-case sql="SELECT user_id, SUM(order_id_sharding) FROM 
t_order_federate_sharding GROUP BY user_id HAVING SUM(order_id_sharding) > ?" 
db-types="MySQL,PostgreSQL" scenario-types="tbl">
+    <test-case sql="SELECT user_id, SUM(order_id_sharding) FROM 
t_order_federate_sharding GROUP BY user_id HAVING SUM(order_id_sharding) > ? 
ORDER BY user_id" db-types="MySQL,PostgreSQL" scenario-types="tbl">
         <assertion parameters="1000:int" />
     </test-case>