[shardingsphere] branch master updated: feat(task6): add test cases (#27263)

[duanzhengqiang]

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

duanzhengqiang 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 6e86011444e feat(task6): add test cases (#27263)
6e86011444e is described below

commit 6e86011444eb2af90e7ae4477003eab6a41c3637
Author: Yunbo Ni <87902024+cardigan1...@users.noreply.github.com>
AuthorDate: Fri Jul 21 20:25:10 2023 +0800

    feat(task6): add test cases (#27263)
---
 test/it/optimizer/src/test/resources/converter/select-expression.xml | 2 ++
 1 file changed, 2 insertions(+)

diff --git 
a/test/it/optimizer/src/test/resources/converter/select-expression.xml 
b/test/it/optimizer/src/test/resources/converter/select-expression.xml
index 62716d95a61..d61c3bfa031 100644
--- a/test/it/optimizer/src/test/resources/converter/select-expression.xml
+++ b/test/it/optimizer/src/test/resources/converter/select-expression.xml
@@ -46,4 +46,6 @@
     <test-cases sql-case-id="select_where_with_boolean_primary_with_null_safe" 
expected-sql="SELECT * FROM `t_order` WHERE `t_order`.`status` &lt;=&gt; 
`t_order`.`order_id`" db-types="MySQL" sql-case-types="LITERAL" />
     <test-cases sql-case-id="select_where_with_simple_expr_with_match" 
expected-sql="SELECT * FROM `t_order` WHERE MATCH (`order_id`) AGAINST 
('keyword' IN NATURAL LANGUAGE MODE)" db-types="MySQL" sql-case-types="LITERAL" 
/>
     <test-cases sql-case-id="select_where_with_simple_expr_with_match" 
expected-sql="SELECT * FROM `t_order` WHERE MATCH (`order_id`) AGAINST (? IN 
NATURAL LANGUAGE MODE)" db-types="MySQL" sql-case-types="PLACEHOLDER" />
+    <test-cases sql-case-id="select_where_with_predicate_with_in_subquery" 
expected-sql="SELECT * FROM &quot;t_order&quot; WHERE 
&quot;t_order&quot;.&quot;order_id&quot; NOT IN (SELECT &quot;order_id&quot; 
FROM &quot;t_order_item&quot; WHERE &quot;status&quot; &gt; 1)" 
db-types="PostgreSQL, openGauss" sql-case-types="LITERAL" />
+    <test-cases sql-case-id="select_where_with_predicate_with_in_subquery" 
expected-sql="SELECT * FROM &quot;t_order&quot; WHERE 
&quot;t_order&quot;.&quot;order_id&quot; NOT IN (SELECT &quot;order_id&quot; 
FROM &quot;t_order_item&quot; WHERE &quot;status&quot; &gt; ?)" 
db-types="PostgreSQL, openGauss" sql-case-types="PLACEHOLDER" />
 </sql-node-converter-test-cases>