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 85998a1 close inner join tests of pgsql (#11446)
85998a1 is described below
commit 85998a1bb55b8c21076b8753088bff4121c9479a
Author: Jieker <[email protected]>
AuthorDate: Sat Jul 24 18:09:09 2021 +0800
close inner join tests of pgsql (#11446)
---
.../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 5b220fd..2f3f898 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
@@ -370,8 +370,8 @@
<test-case sql="SELECT i.user_id FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id WHERE o.user_id IN (?, ?) AND
o.order_id BETWEEN ? AND ? GROUP BY i.user_id ORDER BY i.item_id DESC LIMIT ?,
?" db-types="MySQL"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion parameters="10:int, 19:int, 1000:int, 1909:int, 1:int,
10:int"
expected-data-file="select_pagination_with_diff_group_by_and_order_by.xml" />
</test-case>
-
- <test-case sql="SELECT i.* FROM t_order o INNER JOIN t_order_item i ON
o.order_id = i.order_id WHERE o.order_id = ?"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
+ <!--TODO inner join in pgsql is not supported yet issue #11429-->
+ <test-case sql="SELECT i.* FROM t_order o INNER JOIN t_order_item i ON
o.order_id = i.order_id WHERE o.order_id = ?" db-types="MySQL,H2"
scenario-types="db,tbl,dbtbl_with_readwrite_splitting,readwrite_splitting">
<assertion parameters="1000:int"
expected-data-file="select_inner_join.xml" />
</test-case>
