This is an automated email from the ASF dual-hosted git repository.
chengzhang 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 a9e559dfb15 Update encrypt feature unsupported sql doc with UNION,
INTERSECT, and EXCEPT statements (#30927)
a9e559dfb15 is described below
commit a9e559dfb1561633ce40f7102e4de861ade2d9b5
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Wed Apr 17 08:46:29 2024 +0800
Update encrypt feature unsupported sql doc with UNION, INTERSECT, and
EXCEPT statements (#30927)
---
docs/document/content/features/encrypt/appendix.cn.md | 3 ++-
docs/document/content/features/encrypt/appendix.en.md | 1 +
2 files changed, 3 insertions(+), 1 deletion(-)
diff --git a/docs/document/content/features/encrypt/appendix.cn.md
b/docs/document/content/features/encrypt/appendix.cn.md
index 88cef38bbd1..43adc4bce47 100644
--- a/docs/document/content/features/encrypt/appendix.cn.md
+++ b/docs/document/content/features/encrypt/appendix.cn.md
@@ -8,7 +8,8 @@ weight = 3
- 加密字段无法支持查询不区分大小写功能；
- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN 等；
- 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式；
-- 不支持子查询中包含加密字段，并且外层投影使用星号的 SQL。
+- 不支持子查询中包含加密字段，并且外层投影使用星号的 SQL；
+- 不支持 UNION、INTERSECT、EXCEPT 等集合运算语句中包含加密列。
其他：
diff --git a/docs/document/content/features/encrypt/appendix.en.md
b/docs/document/content/features/encrypt/appendix.en.md
index 7a930811872..a729ee62cc4 100644
--- a/docs/document/content/features/encrypt/appendix.en.md
+++ b/docs/document/content/features/encrypt/appendix.en.md
@@ -9,6 +9,7 @@ Unsupported SQL：
- 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.
- SQL that contains encrypt column in subquery and uses asterisks for outer
projection is not supported.
+- SQL that contains encrypt column in UNION, INTERSECT, and EXCEPT statements
is not supported.
Other:
