[shardingsphere] branch master updated: feat: not test case (#28311)

[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 8f07b7581a4 feat: not test case (#28311)
8f07b7581a4 is described below

commit 8f07b7581a47c982c73917b5a2dbbdc2f8fb9a81
Author: Yunbo Ni <87902024+cardigan1...@users.noreply.github.com>
AuthorDate: Mon Sep 4 16:47:30 2023 +0800

    feat: not test case (#28311)
---
 test/it/optimizer/src/test/resources/converter/select-expression.xml | 1 +
 1 file changed, 1 insertion(+)

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 ffb33c349f9..5f9efd447c3 100644
--- a/test/it/optimizer/src/test/resources/converter/select-expression.xml
+++ b/test/it/optimizer/src/test/resources/converter/select-expression.xml
@@ -49,6 +49,7 @@
     <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" />
     <test-cases sql-case-id="select_where_with_simple_expr_with_collate" 
expected-sql="SELECT * FROM `t_order` WHERE `order_id` COLLATE 
'utf8mb4_0900_ai_ci'" db-types="MySQL" sql-case-types="LITERAL" />
+    <test-cases sql-case-id="select_where_with_simple_expr_with_not" 
expected-sql="SELECT * FROM `t_order` WHERE ! `t_order`.`order_id`" 
db-types="MySQL" />
     <test-cases sql-case-id="select_where_with_simple_expr_with_variable" 
expected-sql="SELECT * FROM `t_order` WHERE `max_connections` &lt; `order_id`" 
db-types="MySQL" />
     <test-cases sql-case-id="select_with_regexp" expected-sql="SELECT * FROM 
`t_order_item` AS `t` WHERE `t`.`status` REGEXP ? AND `t`.`item_id` IN (?, ?)" 
db-types="MySQL" sql-case-types="PLACEHOLDER" />
     <test-cases sql-case-id="select_with_regexp" expected-sql="SELECT * FROM 
`t_order_item` AS `t` WHERE `t`.`status` REGEXP 'init' AND `t`.`item_id` IN (1, 
2)" db-types="MySQL" sql-case-types="LITERAL" />