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 <[email protected]>
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" />