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` > 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` > ?)" 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" > 1)" db-types="PostgreSQL, openGauss" sql-case-types="LITERAL" parameters="1" />