This is an automated email from the ASF dual-hosted git repository.
zclll 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 1c7aff11db4 [doc]mask function only supports the ascii letter. (#2983)
1c7aff11db4 is described below
commit 1c7aff11db4f6d4e5e6498516d9c36500613e1ee
Author: Mryange <[email protected]>
AuthorDate: Tue Oct 21 11:29:38 2025 +0800
[doc]mask function only supports the ascii letter. (#2983)
## Versions
- [x] dev
- [ ] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/string-functions/mask-first-n.md | 13 +++++++++++++
.../scalar-functions/string-functions/mask-last-n.md | 13 +++++++++++++
.../sql-functions/scalar-functions/string-functions/mask.md | 13 +++++++++++++
.../scalar-functions/string-functions/mask-first-n.md | 13 +++++++++++++
.../scalar-functions/string-functions/mask-last-n.md | 13 +++++++++++++
.../sql-functions/scalar-functions/string-functions/mask.md | 13 +++++++++++++
6 files changed, 78 insertions(+)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
index 7c537ad0c94..1b28811e5b7 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
@@ -28,6 +28,7 @@ Returns a string after masking uppercase character, lowercase
character and lnum
- If any Parameter is NULL, NULL will be returned.
- Non-alphabetic and non-numeric characters will do not masking
+- Only ASCII letters are supported for replacement, non-ASCII letters (such as
accented Latin letters) will be preserved as is
## Examples
@@ -54,3 +55,15 @@ select mask_first_n("1234-5678-8765-4321", null);
| NULL |
+-------------------------------------------+
```
+
+```sql
+select mask_first_n('eeeéèêëìí1234');
+```
+
+```text
++-------------------------------------+
+| mask_first_n('eeeéèêëìí1234') |
++-------------------------------------+
+| xxxéèêëìínnnn |
++-------------------------------------+
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index 4b531e2852c..890b3b823d3 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -28,6 +28,7 @@ Returns a string after masking uppercase character, lowercase
character and lnum
- If any Parameter is NULL, NULL will be returned.
- Non-alphabetic and non-numeric characters will do not masking
+- Only ASCII letters are supported for replacement, non-ASCII letters (such as
accented Latin letters) will be preserved as is
## Examples
@@ -54,3 +55,15 @@ select mask_last_n("1234-5678-8765-4321", null);
| NULL |
+-------------------------------------------+
```
+
+```sql
+select mask_last_n('eeeéèêëìí1234');
+```
+
+```text
++------------------------------------+
+| mask_last_n('eeeéèêëìí1234') |
++------------------------------------+
+| xxxéèêëìínnnn |
++------------------------------------+
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
index 48a1b2aa7f1..4aed8a5d46b 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
@@ -30,6 +30,7 @@ Returns a string after masking uppercase character, lowercase
character and lnum
- If any Parameter is NULL, NULL will be returned.
- Non-alphabetic and non-numeric characters will do not masking
+- Only ASCII letters are supported for replacement, non-ASCII letters (such as
accented Latin letters) will be preserved as is
## Examples
@@ -68,3 +69,15 @@ select mask('abc123EFG', '*', '#', '$');
| ###$$$*** |
+----------------------------------+
```
+
+```sql
+select mask('eeeéèêëìí1234');
+```
+
+```text
++-----------------------------+
+| mask('eeeéèêëìí1234') |
++-----------------------------+
+| xxxéèêëìínnnn |
++-----------------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
index 7798d553fad..2dc03f9f437 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-first-n.md
@@ -28,6 +28,7 @@ MASK_FIRST_N( <str> [, <n> ])
- 任意参数中有一个为 NULL，则返回 NULL
- 非字母和数字会原样返回
+- 仅支持ASCII字母的替换，非ASCII字母（如带重音的拉丁字母）会原样保留
## 举例
@@ -54,3 +55,15 @@ select mask_first_n("1234-5678-8765-4321", null);
| NULL |
+-------------------------------------------+
```
+
+```sql
+select mask_first_n('eeeéèêëìí1234');
+```
+
+```text
++-------------------------------------+
+| mask_first_n('eeeéèêëìí1234') |
++-------------------------------------+
+| xxxéèêëìínnnn |
++-------------------------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index b192f8f2fd3..d76f034a8cb 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -28,6 +28,7 @@ MASK_LAST_N( <str> [, <n> ])
- 任意参数中有一个为 NULL，则返回 NULL
- 非字母和数字会原样返回
+- 仅支持ASCII字母的替换，非ASCII字母（如带重音的拉丁字母）会原样保留
## 举例
@@ -54,3 +55,15 @@ select mask_last_n("1234-5678-8765-4321", null);
| NULL |
+-------------------------------------------+
```
+
+```sql
+select mask_last_n('eeeéèêëìí1234');
+```
+
+```text
++------------------------------------+
+| mask_last_n('eeeéèêëìí1234') |
++------------------------------------+
+| xxxéèêëìínnnn |
++------------------------------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
index 5223577e1f5..720d59e3e17 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
@@ -30,6 +30,7 @@ MASK(<str> [, <upper> [, <lower> [, <number> ]]])
- 任意参数中有一个为 NULL，则返回 NULL
- 非字母和数字会原样返回
+- 仅支持ASCII字母的替换，非ASCII字母（如带重音的拉丁字母）会原样保留
## 举例
@@ -68,3 +69,15 @@ select mask('abc123EFG', '*', '#', '$');
| ###$$$*** |
+----------------------------------+
```
+
+```sql
+select mask('eeeéèêëìí1234');
+```
+
+```text
++-----------------------------+
+| mask('eeeéèêëìí1234') |
++-----------------------------+
+| xxxéèêëìínnnn |
++-----------------------------+
+```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
