You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2026/09/07 12:25:42 UTC

(shardingsphere) branch master updated: Fixes CI related to MySQL `!` operator precedence semantics (#39760)

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

RaigorJiang 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 cfc787e6e12 Fixes CI related to MySQL `!` operator precedence semantics (#39760)
cfc787e6e12 is described below

commit cfc787e6e12269d63733fb5504634f7aa5552f65
Author: Hengqian Ling <li...@outlook.com>
AuthorDate: Mon Sep 7 20:25:36 2026 +0800

    Fixes CI related to MySQL `!` operator precedence semantics (#39760)
---
 .../optimizer/src/test/resources/converted-sql/select-expression.xml  | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/test/it/optimizer/src/test/resources/converted-sql/select-expression.xml b/test/it/optimizer/src/test/resources/converted-sql/select-expression.xml
index 6745f310fdd..46a05bed7fd 100644
--- a/test/it/optimizer/src/test/resources/converted-sql/select-expression.xml
+++ b/test/it/optimizer/src/test/resources/converted-sql/select-expression.xml
@@ -31,8 +31,8 @@
     <test-cases sql-case-id="select_where_with_bit_expr_with_mod" expected-sql="SELECT * FROM `t_order` WHERE MOD(`t_order`.`order_id`, ?)" db-types="MySQL" sql-case-types="PLACEHOLDER" parameters="1" />
     <test-cases sql-case-id="select_where_with_bit_expr_with_vertical_bar" expected-sql="SELECT * FROM `t_order` WHERE `t_order`.`order_id` | 1" db-types="MySQL" sql-case-types="LITERAL" parameters="1" />
     <test-cases sql-case-id="select_where_with_bit_expr_with_vertical_bar" expected-sql="SELECT * FROM `t_order` WHERE `t_order`.`order_id` | ?" db-types="MySQL" sql-case-types="PLACEHOLDER" parameters="1" />
-    <test-cases sql-case-id="select_where_with_expr_with_not_sign" expected-sql="SELECT * FROM `t_order` WHERE ! 1 = `t_order`.`order_id`" db-types="MySQL" sql-case-types="LITERAL" parameters="1" />
-    <test-cases sql-case-id="select_where_with_expr_with_not_sign" expected-sql="SELECT * FROM `t_order` WHERE ! ? = `t_order`.`order_id`" db-types="MySQL" sql-case-types="PLACEHOLDER" parameters="1" />
+    <test-cases sql-case-id="select_where_with_expr_with_not_sign" expected-sql="SELECT * FROM `t_order` WHERE ! (1 = `t_order`.`order_id`)" db-types="MySQL" sql-case-types="LITERAL" parameters="1" />
+    <test-cases sql-case-id="select_where_with_expr_with_not_sign" expected-sql="SELECT * FROM `t_order` WHERE ! (? = `t_order`.`order_id`)" db-types="MySQL" sql-case-types="PLACEHOLDER" parameters="1" />
     <test-cases sql-case-id="select_where_with_predicate_with_in_subquery" expected-sql="SELECT * FROM `t_order` WHERE `t_order`.`order_id` NOT IN (SELECT `order_id` FROM `t_order_item` WHERE `status` &gt; 1)" db-types="MySQL" sql-case-types="LITERAL" parameters="1" />
     <test-cases sql-case-id="select_where_with_predicate_with_in_subquery" expected-sql="SELECT * FROM `t_order` WHERE `t_order`.`order_id` NOT IN (SELECT `order_id` FROM `t_order_item` WHERE `status` &gt; ?)" db-types="MySQL" sql-case-types="PLACEHOLDER" parameters="1" />
     <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" parameters="1" />