You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2024/09/10 06:06:11 UTC
(doris-website) branch master updated: [Enhancement](function) Add more explaination for crypto functions (#1098)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new ab5923f1535 [Enhancement](function) Add more explaination for crypto functions (#1098)
ab5923f1535 is described below
commit ab5923f15357e0eed67f1db9b3580c276f12feb1
Author: zclllhhjj <zh...@selectdb.com>
AuthorDate: Tue Sep 10 14:06:05 2024 +0800
[Enhancement](function) Add more explaination for crypto functions (#1098)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
docs/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
docs/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md | 2 +-
.../sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md | 2 +-
40 files changed, 40 insertions(+), 40 deletions(-)
diff --git a/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index c20ae64014c..03160276e61 100644
--- a/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES decryption function. This function behaves like the `AES_DECRYPT` function i
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index dbc3081643c..efc637fb491 100644
--- a/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/docs/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index dfb013827ac..d7e55c9b591 100644
--- a/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 1532aae2eb3..eedbac6056f 100644
--- a/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/docs/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 73081fb632e..33014ae8784 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES 解密函数。该函数与 MySQL 中的 `AES_DECRYPT` 函数行为一致。
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 1551c5d4939..49c2d3e8fb3 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index 0f4846bf96d..4dedc40513b 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 2956afb9d2d..8575dd64f1d 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法最终使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index c0ece5b54d7..7cc1239bed3 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES 解密函数。该函数与 MySQL 中的 `AES_DECRYPT` 函数行为一致。
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../advanced/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index b58d407c108..d8e5489878d 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../advanced/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index c8159fa8645..cd5d38c7981 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../advanced/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 9e34c351598..29c29023151 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../advanced/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 5a5779039b6..a3bcd1cc900 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES 解密函数。该函数与 MySQL 中的 `AES_DECRYPT` 函数行为一致。
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 788bedba430..373894f0daf 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index b113a490cd1..cf5d9cc16ba 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index ae857f94960..616e36ecb2c 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 7fa811f989b..dea4d382ba0 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES 解密函数。该函数与 MySQL 中的 `AES_DECRYPT` 函数行为一致。
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index afe843b46f4..de593d83323 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index 8e7eb8c49e4..31d47411802 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 1203c0826bf..2b5d6bb2f5f 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 1f4a7cb473b..b8a1e88e61d 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES 解密函数。该函数与 MySQL 中的 `AES_DECRYPT` 函数行为一致。
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 287bd5408e3..85016449862 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index b2491f91f1b..7d94559272f 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
返回解密后的结果，其中：
- `str` 为待解密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 5a895b1cda4..1b9b2c9fd07 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
返回加密后的结果，其中：
- `str` 为待加密文本；
-- `key_str` 为密钥；
+- `key_str` 为密钥。注意此密钥并非 16 进制编码，而是编码后的字符串表示。例如对于 128 位密钥加密，`key_str` 长度应为 16。如果密钥长度不足，使用**零填充**补齐。如果长度超出，使用循环异或的方式求出最终密钥。例如算法使用的 128 位密钥为 `key`，则 `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` 为算法中使用到的初始向量，仅在特定算法下生效，如不指定，则 Doris 使用内置向量；
- `encryption_mode` 为加密算法，可选值见于：[变量](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 2311ff50bec..d9bfe91a628 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES decryption function. This function behaves like the `AES_DECRYPT` function i
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../advanced/variables)。
diff --git a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 3db4f00857a..4c4684053e3 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../advanced/variables)。
diff --git a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index b5eb220999d..ea4341269d4 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../advanced/variables)。
diff --git a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 518d8af4cb4..a878ce54a4a 100644
--- a/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/versioned_docs/version-1.2/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../advanced/variables)。
diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 6d991a8045b..2ddbc239dbf 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES decryption function. This function behaves like the `AES_DECRYPT` function i
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 80fdaa62bb7..ff8d2f36008 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index 5a36720bb45..0a1768d62c9 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index c422218702e..a9994566c54 100644
--- a/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/versioned_docs/version-2.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 8c77bc17576..a5dd3d39b80 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES decryption function. This function behaves like the `AES_DECRYPT` function i
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index 6fea1e645fd..cdd795cc845 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index ebaf6eacbee..d6758d982aa 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index 7527fb7ea77..aee6982364b 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
index 163acb3b2d4..5557639c178 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-decrypt.md
@@ -32,7 +32,7 @@ AES decryption function. This function behaves like the `AES_DECRYPT` function i
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
index b6e90de88dd..3ad29d46762 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/aes-encrypt.md
@@ -34,7 +34,7 @@ Reference: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#fun
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
index 6ff4db28be8..756cb293cdb 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-decrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the decrypted result, where:
- `str` is the text to be decrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variables](../../../query/query-variables/variables)。
diff --git a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
index a6f843e8db2..a935d9d3371 100644
--- a/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
+++ b/versioned_docs/version-3.0/sql-manual/sql-functions/encrypt-digest-functions/sm4-encrypt.md
@@ -30,7 +30,7 @@ under the License.
Returns the encrypted result, where:
- `str` is the text to be encrypted;
-- `key_str` is the key;
+- `key_str` is the key. Note that this key is not a hexadecimal encoding, but a string representation of the encoded key. For example, for 128-bit key encryption, `key_str` should be 16-length. If the key is not long enough, use **zero padding** to make it up. If it is longer than that, the final key is found using a cyclic xor method. For example, if the 128-bit key used by the algorithm finally is `key`, then `key[i] = key_str[i] ^ key_str[i+128] ^ key_str[i+256] ^ ...`
- `init_vector` is the initial vector to be used in the algorithm, this is only valid for some algorithms, if not specified then Doris will use the built-in value;
- `encryption_mode` is the encryption algorithm, optionally available in [variable](../../../query/query-variables/variables)。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org