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="'{&quot;rule2&quot;:&quot;null&quot;}', 
100:int, 200:int, 10:int, 1000:int" 
expected-data-file="select_equal_with_single_table.xml" />
-        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', 
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="'{&quot;rule2&quot;:&quot;null&quot;}', 
'{&quot;rule2&quot;:&quot;null&quot;}', 100:int, 200:int, 10:int, 1000:int" 
expected-data-file="select_equal_with_single_table.xml" />
-        <assertion parameters="'{&quot;rule2&quot;:&quot;null&quot;}', 
'{&quot;rule2&quot;:&quot;null&quot;}', 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" />

Reply via email to