This is an automated email from the ASF dual-hosted git repository.
zhaojinchao 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 b98b62d64c7 Update document about table and column capitalization in
sharding and encrypt (#27612)
b98b62d64c7 is described below
commit b98b62d64c76f3327c0efb508617ac1bc3965cc2
Author: Zhengqiang Duan <[email protected]>
AuthorDate: Tue Aug 1 17:35:17 2023 +0800
Update document about table and column capitalization in sharding and
encrypt (#27612)
* Update document about table and column capitalization in sharding and
encrypt
* Update document about table and column capitalization in sharding and
encrypt
---
docs/document/content/features/encrypt/appendix.cn.md | 4 ++++
docs/document/content/features/encrypt/appendix.en.md | 4 ++++
docs/document/content/features/sharding/appendix.cn.md | 4 ++++
docs/document/content/features/sharding/appendix.en.md | 4 ++++
4 files changed, 16 insertions(+)
diff --git a/docs/document/content/features/encrypt/appendix.cn.md
b/docs/document/content/features/encrypt/appendix.cn.md
index 444b0e1be3d..e312be0cea6 100644
--- a/docs/document/content/features/encrypt/appendix.cn.md
+++ b/docs/document/content/features/encrypt/appendix.cn.md
@@ -8,3 +8,7 @@ weight = 3
- 加密字段无法支持查询不区分大小写功能；
- 加密字段无法支持比较操作，如：大于、小于、ORDER BY、BETWEEN 等；
- 加密字段无法支持计算操作，如：AVG、SUM 以及计算表达式。
+
+其他：
+
+- 加密规则中配置的加密列、辅助查询列、LIKE 查询列等需要和数据库中的列保持大小写一致。
\ No newline at end of file
diff --git a/docs/document/content/features/encrypt/appendix.en.md
b/docs/document/content/features/encrypt/appendix.en.md
index e4775168fd5..072765e59b9 100644
--- a/docs/document/content/features/encrypt/appendix.en.md
+++ b/docs/document/content/features/encrypt/appendix.en.md
@@ -8,3 +8,7 @@ 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.
- Calculation operations are not supported for encrypted fields, such as AVG,
SUM, and computation expressions.
+
+Other:
+
+- You should keep encrypt columns, assisted columns and like columns in
encrypt rule same capitalization with columns in database.
\ No newline at end of file
diff --git a/docs/document/content/features/sharding/appendix.cn.md
b/docs/document/content/features/sharding/appendix.cn.md
index d290a33b216..e5be258b6c2 100644
--- a/docs/document/content/features/sharding/appendix.cn.md
+++ b/docs/document/content/features/sharding/appendix.cn.md
@@ -14,3 +14,7 @@ weight = 3
- INSERT INTO tbl_name (col1, col2, …) SELECT * FROM tbl_name WHERE col3 =
?（SELECT 子句不支持 * 和内置分布式主键生成器）
- REPLACE INTO tbl_name (col1, col2, …) SELECT * FROM tbl_name WHERE col3 =
?（SELECT 子句不支持 * 和内置分布式主键生成器）
- SELECT MAX(tbl_name.col1) FROM tbl_name（查询列是函数表达式时，查询列前不能使用表名，可以使用表别名）
+
+其他：
+
+- 分片规则中配置的真实表、分片列和分布式序列需要和数据库中的列保持大小写一致。
diff --git a/docs/document/content/features/sharding/appendix.en.md
b/docs/document/content/features/sharding/appendix.en.md
index 2e8d5355e6b..de76701860d 100644
--- a/docs/document/content/features/sharding/appendix.en.md
+++ b/docs/document/content/features/sharding/appendix.en.md
@@ -14,3 +14,7 @@ Unsupported SQL:
- INSERT INTO tbl_name (col1, col2, …) SELECT * FROM tbl_name WHERE col3 =
?（The SELECT clause does not support * and the built-in distributed primary key
generator）
- REPLACE INTO tbl_name (col1, col2, …) SELECT * FROM tbl_name WHERE col3 =
?（The SELECT clause does not support * and the built-in distributed primary key
generator）
- SELECT MAX(tbl_name.col1) FROM tbl_name (If the query column is a function
expression, use the table alias instead of the table name）
+
+Other：
+
+- You should keep actual tables, sharding columns and key generate columns in
sharding rule same capitalization with tables and columns in database.
\ No newline at end of file
