This is an automated email from the ASF dual-hosted git repository.
sunnianjun 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 f3410ee41ed Update DistSQL doc about encrypt rule (#23129)
f3410ee41ed is described below
commit f3410ee41ed00d2f13bc724014cbc7b990ca8c75
Author: jiangML <[email protected]>
AuthorDate: Wed Dec 28 10:41:33 2022 +0800
Update DistSQL doc about encrypt rule (#23129)
---
.../distsql/syntax/rdl/rule-definition/encrypt.cn.md | 8 ++++----
.../distsql/syntax/rdl/rule-definition/encrypt.en.md | 8 ++++----
2 files changed, 8 insertions(+), 8 deletions(-)
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.cn.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.cn.md
index 51736814f70..d2a5826f408 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.cn.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.cn.md
@@ -16,7 +16,7 @@ encryptRuleDefinition:
tableName(COLUMNS(columnDefinition [, columnDefinition] ...),
QUERY_WITH_CIPHER_COLUMN=queryWithCipherColumn)
columnDefinition:
- (NAME=columnName [, PLAIN=plainColumnName] , CIPHER=cipherColumnName [,
ASSISTED_QUERY_COLUMN=assistedQueryColumnName] [,
LIKE_QUERY_COLUMN=likeQueryColumnName], encryptAlgorithm [,
assistedQueryAlgorithm] [, likeQueryAlgorithm])
+ (NAME=columnName [, PLAIN=plainColumnName] , CIPHER=cipherColumnName [,
ASSISTED_QUERY_COLUMN=assistedQueryColumnName] [,
LIKE_QUERY_COLUMN=likeQueryColumnName], encryptAlgorithm [,
assistedQueryAlgorithm] [, likeQueryAlgorithm] [,
QUERY_WITH_CIPHER_COLUMN=queryWithCipherColumn])
encryptAlgorithm:
ENCRYPT_ALGORITHM(TYPE(NAME=encryptAlgorithmType [,
PROPERTIES([algorithmProperties] )] ))
@@ -58,7 +58,7 @@ algorithmProperty:
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=user_assisted,LIKE_QUERY_COLUMN=user_like,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))),
-(NAME=order_id, CIPHER =order_cipher, ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))
+(NAME=order_id, CIPHER =order_cipher, ENCRYPT_ALGORITHM(TYPE(NAME='MD5')),
QUERY_WITH_CIPHER_COLUMN=FALSE)
), QUERY_WITH_CIPHER_COLUMN=true),
t_encrypt_2 (
COLUMNS(
@@ -69,8 +69,8 @@ COLUMNS(
ALTER ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=user_assisted,LIKE_QUERY_COLUMN=user_like,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))),
-(NAME=order_id,CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))
-), QUERY_WITH_CIPHER_COLUMN=TRUE);
+(NAME=order_id,CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')),
QUERY_WITH_CIPHER_COLUMN=true)
+), QUERY_WITH_CIPHER_COLUMN=FALSE);
DROP ENCRYPT RULE t_encrypt,t_encrypt_2;
```
diff --git
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.en.md
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.en.md
index 3b771b40ddf..80edc7ae037 100644
---
a/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.en.md
+++
b/docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/encrypt.en.md
@@ -16,7 +16,7 @@ encryptRuleDefinition:
tableName(COLUMNS(columnDefinition [, columnDefinition] ...),
QUERY_WITH_CIPHER_COLUMN=queryWithCipherColumn)
columnDefinition:
- (NAME=columnName [, PLAIN=plainColumnName] , CIPHER=cipherColumnName [,
ASSISTED_QUERY_COLUMN=assistedQueryColumnName] [,
LIKE_QUERY_COLUMN=likeQueryColumnName], encryptAlgorithm [,
assistedQueryAlgorithm] [, likeQueryAlgorithm])
+ (NAME=columnName [, PLAIN=plainColumnName] , CIPHER=cipherColumnName [,
ASSISTED_QUERY_COLUMN=assistedQueryColumnName] [,
LIKE_QUERY_COLUMN=likeQueryColumnName], encryptAlgorithm [,
assistedQueryAlgorithm] [, likeQueryAlgorithm] [,
QUERY_WITH_CIPHER_COLUMN=queryWithCipherColumn])
encryptAlgorithm:
ENCRYPT_ALGORITHM(TYPE(NAME=encryptAlgorithmType [,
PROPERTIES([algorithmProperties] )] ))
@@ -58,7 +58,7 @@ algorithmProperty:
CREATE ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=user_assisted,LIKE_QUERY_COLUMN=user_like,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456abc'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))),
-(NAME=order_id, CIPHER =order_cipher, ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))
+(NAME=order_id, CIPHER =order_cipher, ENCRYPT_ALGORITHM(TYPE(NAME='MD5')),
QUERY_WITH_CIPHER_COLUMN=FALSE)
), QUERY_WITH_CIPHER_COLUMN=true),
t_encrypt_2 (
COLUMNS(
@@ -69,8 +69,8 @@ COLUMNS(
ALTER ENCRYPT RULE t_encrypt (
COLUMNS(
(NAME=user_id,PLAIN=user_plain,CIPHER=user_cipher,ASSISTED_QUERY_COLUMN=user_assisted,LIKE_QUERY_COLUMN=user_like,ENCRYPT_ALGORITHM(TYPE(NAME='AES',PROPERTIES('aes-key-value'='123456'))),ASSISTED_QUERY_ALGORITHM(TYPE(NAME='MD5')),
LIKE_QUERY_ALGORITHM(TYPE(NAME='CHAR_DIGEST_LIKE'))),
-(NAME=order_id,CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')))
-), QUERY_WITH_CIPHER_COLUMN=TRUE);
+(NAME=order_id,CIPHER=order_cipher,ENCRYPT_ALGORITHM(TYPE(NAME='MD5')),
QUERY_WITH_CIPHER_COLUMN=true)
+), QUERY_WITH_CIPHER_COLUMN=FALSE);
DROP ENCRYPT RULE t_encrypt,t_encrypt_2;
```
