[shardingsphere] branch master updated: Update features on encrypt document (#22046)

[zh...@apache.org]

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

zhangliang 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 6c0519000a9 Update features on encrypt document (#22046)
6c0519000a9 is described below

commit 6c0519000a94db912c5f2688715bd7d055754b49
Author: gxxiong <xi...@foxmail.com>
AuthorDate: Thu Nov 10 18:17:09 2022 +0800

    Update features on encrypt document (#22046)
    
    * rewrite the sql while LIKE operator contained and UT, SIT
    
    * Update dev-manual on encrypt document
    
    * Update features on encrypt document
---
 docs/document/content/features/encrypt/appendix.cn.md    | 2 +-
 docs/document/content/features/encrypt/appendix.en.md    | 2 +-
 docs/document/content/features/encrypt/concept.cn.md     | 6 +++++-
 docs/document/content/features/encrypt/concept.en.md     | 6 +++++-
 docs/document/content/features/encrypt/limitations.cn.md | 2 +-
 docs/document/content/features/encrypt/limitations.en.md | 2 +-
 6 files changed, 14 insertions(+), 6 deletions(-)

diff --git a/docs/document/content/features/encrypt/appendix.cn.md b/docs/document/content/features/encrypt/appendix.cn.md
index 8ac1f49b980..3d8ea53ae20 100644
--- a/docs/document/content/features/encrypt/appendix.cn.md
+++ b/docs/document/content/features/encrypt/appendix.cn.md
@@ -6,5 +6,5 @@ weight = 3
 不支持的 SQL：
 
 - 加密字段无法支持查询不区分大小写功能；
-- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN、LIKE 等；
+- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN等；
 - 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式。
diff --git a/docs/document/content/features/encrypt/appendix.en.md b/docs/document/content/features/encrypt/appendix.en.md
index 4b79a97185c..e4775168fd5 100644
--- a/docs/document/content/features/encrypt/appendix.en.md
+++ b/docs/document/content/features/encrypt/appendix.en.md
@@ -6,5 +6,5 @@ weight = 3
 Unsupported SQL：
 
 - The case-insensitive queries are not supported by encrypted fields.
-- Comparison operations are not supported for encrypted fields, such as GREATER THAN, LESS THAN, ORDER BY, BETWEEN, LIKE.
+- 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.
diff --git a/docs/document/content/features/encrypt/concept.cn.md b/docs/document/content/features/encrypt/concept.cn.md
index a606220d737..cca99703b46 100644
--- a/docs/document/content/features/encrypt/concept.cn.md
+++ b/docs/document/content/features/encrypt/concept.cn.md
@@ -6,7 +6,7 @@ weight = 1
 ## 逻辑列
 
 用于计算加解密列的逻辑名称，是 SQL 中列的逻辑标识。
-逻辑列包含密文列（必须）、查询辅助列（可选）和明文列（可选）。
+逻辑列包含密文列（必须）、查询辅助列（可选）、模糊查询辅助列（可选）、和明文列（可选）。
 
 ## 密文列
 
@@ -17,6 +17,10 @@ weight = 1
 用于查询的辅助列。
 对于一些安全级别更高的非幂等加密算法，提供不可逆的幂等列用于查询。
 
+## 模糊查询列
+
+用于模糊查询的列。
+
 ## 明文列
 
 存储明文的列，用于在加密数据迁移过程中仍旧提供服务。
diff --git a/docs/document/content/features/encrypt/concept.en.md b/docs/document/content/features/encrypt/concept.en.md
index fcde624f89d..6dec5b16dcb 100644
--- a/docs/document/content/features/encrypt/concept.en.md
+++ b/docs/document/content/features/encrypt/concept.en.md
@@ -5,7 +5,7 @@ weight = 1
 
 ## Logic column
 
-It is used to calculate the encryption and decryption columns and it is the logical identifier of the column in SQL. Logical columns contain ciphertext columns (mandatory), query-helper columns (optional), and plaintext columns (optional).
+It is used to calculate the encryption and decryption columns and it is the logical identifier of the column in SQL. Logical columns contain ciphertext columns (mandatory), query-helper columns (optional), fuzzy-query columns (optional), and plaintext columns (optional).
 
 ## Cipher column
 
@@ -15,6 +15,10 @@ Encrypted data columns.
 
 It is a helper column used for queries. For some non-idempotent encryption algorithms with higher security levels, irreversible idempotent columns are provided for queries.
 
+## Query fuzzy column
+
+It is a helper column used for fuzzy queries. 
+
 ## Plain column
 
 The column is used to store plaintext and provide services during the migration of encrypted data. It can be deleted after the data cleansing is complete.
diff --git a/docs/document/content/features/encrypt/limitations.cn.md b/docs/document/content/features/encrypt/limitations.cn.md
index d257af35fb6..fb9116d6211 100644
--- a/docs/document/content/features/encrypt/limitations.cn.md
+++ b/docs/document/content/features/encrypt/limitations.cn.md
@@ -5,5 +5,5 @@ weight = 2
 
 - 需自行处理数据库中原始的存量数据；
 - 加密字段无法支持查询不区分大小写功能；
-- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN、LIKE 等；
+- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN等；
 - 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式。
diff --git a/docs/document/content/features/encrypt/limitations.en.md b/docs/document/content/features/encrypt/limitations.en.md
index 23999232f6f..22061e5cd3d 100644
--- a/docs/document/content/features/encrypt/limitations.en.md
+++ b/docs/document/content/features/encrypt/limitations.en.md
@@ -5,5 +5,5 @@ weight = 2
 
 - You need to process the original data on stocks in the database by yourself.
 - The case-insensitive queries are not supported for encrypted fields.
-- Comparison operations are not supported for encrypted fields, such as GREATER THAN, LESS THAN, ORDER BY, BETWEEN, LIKE.
+- 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.