[shardingsphere] branch master updated: Add subquery test case for encrypt (#9350)

[pa...@apache.org]

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

panjuan 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 93ff03b  Add subquery test case for encrypt (#9350)
93ff03b is described below

commit 93ff03bf0b68dee622bf8ca60e4d0db89094f78a
Author: Liang Zhang <te...@163.com>
AuthorDate: Fri Feb 5 16:18:57 2021 +0800

    Add subquery test case for encrypt (#9350)
---
 .../src/test/resources/encrypt/select_for_query_with_cipher.xml     | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-rewrite/src/test/resources/encrypt/select_for_query_with_cipher.xml b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-rewrite/src/test/resources/encrypt/select_for_query_with_cipher.xml
index 8856917..e806059 100644
--- a/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-rewrite/src/test/resources/encrypt/select_for_query_with_cipher.xml
+++ b/shardingsphere-features/shardingsphere-encrypt/shardingsphere-encrypt-rewrite/src/test/resources/encrypt/select_for_query_with_cipher.xml
@@ -78,4 +78,10 @@
         <input sql="SELECT t_account.amount, t_account_bak.amount FROM t_account LEFT JOIN t_account_bak ON t_account.id = t_account_bak.id WHERE t_account.amount = ? OR t_account_bak.amount = ?" parameters="1, 2" />
         <output sql="SELECT t_account.cipher_amount AS amount, t_account_bak.cipher_amount AS amount FROM t_account LEFT JOIN t_account_bak ON t_account.id = t_account_bak.id WHERE t_account.cipher_amount = ? OR t_account_bak.cipher_amount = ?" parameters="encrypt_1, encrypt_2" />
     </rewrite-assertion>
+    
+    <!-- TODO encrypt for sub-query -->
+<!--    <rewrite-assertion id="select_with_subquery">-->
+<!--        <input sql="SELECT amount FROM (SELECT amount FROM t_account WHERE amount = ?) AS a" parameters="1" />-->
+<!--        <output sql="SELECT amount FROM (SELECT cipher_amount AS amount FROM t_account WHERE cipher_amount = ?) AS a" parameters="encrypt_1" />-->
+<!--    </rewrite-assertion>-->
 </rewrite-assertions>