| commit a7ad1d659836a881b94081c05db550b41796f154 |
| Author: Zhengqiang Duan <duanzhengqiang@apache.org> |
| Date: Thu Jun 8 11:47:49 2023 +0800 |
| |
| Update limitations document for encrypt feature (#26134) |
| |
| 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. |
