You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by lu...@apache.org on 2020/08/31 10:10:31 UTC
[shardingsphere] branch master updated: #7010,
PostgreSQL dedicated column missed in t_order cause
GeneralDQLIT.assertExecuteQuery failed
This is an automated email from the ASF dual-hosted git repository.
lujingshang 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 e3ba5ae #7010, PostgreSQL dedicated column missed in t_order cause GeneralDQLIT.assertExecuteQuery failed
new 4b4a399 Merge pull request #7178 from tuohai666/7010
e3ba5ae is described below
commit e3ba5ae8cff30e726e8a7400f17d075ed3ba1478
Author: Zhang Yonglun <zh...@apache.org>
AuthorDate: Mon Aug 31 18:06:43 2020 +0800
#7010, PostgreSQL dedicated column missed in t_order cause GeneralDQLIT.assertExecuteQuery failed
---
.../resources/integrate/cases/dql/dql-integrate-test-cases.xml | 10 ----------
1 file changed, 10 deletions(-)
diff --git a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
index 64a364b..3f883d8 100644
--- a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
+++ b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
@@ -117,16 +117,6 @@
<dql-test-case sql="SELECT i.* FROM t_order o FORCE INDEX(order_index) JOIN t_order_item i ON o.order_id=i.order_id WHERE o.order_id = ?" db-types="MySQL">
<assertion parameters="1000:int" expected-data-file="select_with_force_index_join.xml" />
</dql-test-case>
-
- <dql-test-case sql="SELECT * FROM t_order WHERE rule = ?::jsonb AND start_point=ST_GeographyFromText('SRID=4326;POINT('||?||' '||?||')') AND user_id = ? AND order_id = ?" db-types="PostgreSQL">
- <assertion parameters="'{"rule2":"null"}', 100:int, 200:int, 10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
- <assertion parameters="'{"rule2":"null"}', 100:int, 200:int, 12:int, 1000:int" expected-data-file="empty_order.xml" />
- </dql-test-case>
-
- <dql-test-case sql="SELECT * FROM t_order WHERE rule IN (?::jsonb, ?::jsonb) AND start_point=ST_GeographyFromText('SRID=4326;POINT('||?||' '||?||')') AND user_id = ? AND order_id = ?" db-types="PostgreSQL">
- <assertion parameters="'{"rule2":"null"}', '{"rule2":"null"}', 100:int, 200:int, 10:int, 1000:int" expected-data-file="select_equal_with_single_table.xml" />
- <assertion parameters="'{"rule2":"null"}', '{"rule2":"null"}', 100:int, 200:int, 12:int, 1000:int" expected-data-file="empty_order.xml" />
- </dql-test-case>
<dql-test-case sql="SELECT SUM(user_id) AS user_id_sum FROM t_order">
<assertion expected-data-file="select_sum.xml" />