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 137a2658e28 Add select with concat in subquery rewrite case (#35125)
137a2658e28 is described below
commit 137a2658e28c5aaab66e578894730203caacb40c
Author: ZhangCheng <[email protected]>
AuthorDate: Wed Apr 2 16:16:11 2025 +0800
Add select with concat in subquery rewrite case (#35125)
---
.../encrypt/case/query-with-cipher/dml/select/select-subquery.xml | 5 +++++
1 file changed, 5 insertions(+)
diff --git
a/test/it/rewriter/src/test/resources/scenario/encrypt/case/query-with-cipher/dml/select/select-subquery.xml
b/test/it/rewriter/src/test/resources/scenario/encrypt/case/query-with-cipher/dml/select/select-subquery.xml
index d104ade2f02..65b5d644489 100644
---
a/test/it/rewriter/src/test/resources/scenario/encrypt/case/query-with-cipher/dml/select/select-subquery.xml
+++
b/test/it/rewriter/src/test/resources/scenario/encrypt/case/query-with-cipher/dml/select/select-subquery.xml
@@ -101,4 +101,9 @@
<input sql="SELECT COUNT(1) AS cnt FROM (SELECT a.amount FROM
t_account a GROUP BY a.amount DESC ) AS tmp" />
<output sql="SELECT COUNT(1) AS cnt FROM (SELECT a.cipher_amount AS
amount_CIPHER FROM t_account a GROUP BY a.`cipher_amount` DESC ) AS tmp" />
</rewrite-assertion>
+
+ <rewrite-assertion id="select_concat_in_subquery" db-types="MySQL">
+ <input sql="SELECT COUNT(*) FROM (SELECT * FROM (SELECT password FROM
t_account WHERE password like concat('%', 'zhangsan', '%')) t) TOTAL" />
+ <output sql="SELECT COUNT(*) FROM (SELECT t.password_CIPHER,
t.password_ASSISTED, t.password_LIKE FROM (SELECT cipher_password AS
password_CIPHER, assisted_query_password AS password_ASSISTED,
like_query_password AS password_LIKE FROM t_account WHERE `like_query_password`
like concat ('like_query_%', 'like_query_zhangsan', 'like_query_%')) t) TOTAL"
/>
+ </rewrite-assertion>
</rewrite-assertions>
