[shardingsphere] branch master updated: Update limitations document for encrypt feature (#26134)

[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 a7ad1d65983 Update limitations document for encrypt feature (#26134)
a7ad1d65983 is described below

commit a7ad1d659836a881b94081c05db550b41796f154
Author: Zhengqiang Duan <du...@apache.org>
AuthorDate: Thu Jun 8 11:47:49 2023 +0800

    Update limitations document for encrypt feature (#26134)
---
 docs/document/content/features/encrypt/limitations.cn.md | 3 ++-
 docs/document/content/features/encrypt/limitations.en.md | 3 ++-
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/docs/document/content/features/encrypt/limitations.cn.md b/docs/document/content/features/encrypt/limitations.cn.md
index 801db7197b8..ee6baf4ad74 100644
--- a/docs/document/content/features/encrypt/limitations.cn.md
+++ b/docs/document/content/features/encrypt/limitations.cn.md
@@ -7,4 +7,5 @@ weight = 2
 - 模糊查询支持 %、_，暂不支持 escape；
 - 加密字段无法支持查询不区分大小写功能；
 - 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN 等；
-- 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式。
+- 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式；
+- 当投影子查询中包含加密字段时，必须使用别名。
diff --git a/docs/document/content/features/encrypt/limitations.en.md b/docs/document/content/features/encrypt/limitations.en.md
index e0b3fc36062..635f5e76664 100644
--- a/docs/document/content/features/encrypt/limitations.en.md
+++ b/docs/document/content/features/encrypt/limitations.en.md
@@ -4,7 +4,8 @@ weight = 2
 +++
 
 - You need to process the original data on stocks in the database by yourself.
-- the `like` query supports %, _, but currently does not support escape.
+- The `like` query supports %, _, but currently does not support escape.
 - Case insensitive queries are not supported for the encrypted fields.
 - Comparison operations are not supported for encrypted fields, such as `GREATER THAN`, `LESS THAN`, `ORDER BY`, `BETWEEN`.
 - Calculation operations are not supported for encrypted fields, such as `AVG`, `SUM`, and computation expressions.
+- When projection subquery contains encrypt column, you must use alias.