This is an automated email from the ASF dual-hosted git repository.
eldenmoon 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 26c63805046 [fix](array) fix array function: array_remove (#2862)
26c63805046 is described below
commit 26c63805046a8a5c5c0118e05b1b5ac6df48211a
Author: Sun Chenyang <[email protected]>
AuthorDate: Wed Sep 10 11:30:57 2025 +0800
[fix](array) fix array function: array_remove (#2862)
---
.../scalar-functions/array-functions/array-remove.md | 8 +++++---
.../scalar-functions/array-functions/array-remove.md | 10 ++++++----
.../scalar-functions/array-functions/array-sort.md | 2 +-
3 files changed, 12 insertions(+), 8 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
index e49a98012c2..3b5ce7df191 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
@@ -21,11 +21,11 @@ Remove all elements equal to the given value from an array
while preserving the
## Return value
- Returns `ARRAY<T>` of the same type as the input.
-- If `arr` or `target` is `NULL`, returns `NULL`.
+- If `arr` is `NULL`, returns `NULL`.
## Usage notes
-- Matching rule: only elements whose value equals `target` are removed. `NULL`
elements are not equal to any non-`NULL` value, so they are not removed.
+- Matching rule: only elements whose value equals `target` are removed. `NULL`
is equal to `NULL`.
## Examples
@@ -33,8 +33,10 @@ Remove all elements equal to the given value from an array
while preserving the
- `ARRAY_REMOVE([1,2,3], 1)` -> `[2,3]`
- `ARRAY_REMOVE([1,2,3,null], 1)` -> `[2,3,null]`
-- If either `arr` or `target` is `NULL`, returns `NULL`
+- If `target` is `NULL`, remove `NULL` in `arr`.
- `ARRAY_REMOVE(['a','b','c',NULL], NULL)` -> `NULL`
+
+- If `arr` is `NULL`, returns `NULL`
- `ARRAY_REMOVE(NULL, 2)` -> `NULL`
- No match
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
index e42e5c5659a..03911868ee4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-remove.md
@@ -21,11 +21,11 @@
## 返回值
- 返回与输入同类型的 `ARRAY<T>`。
-- 若 `arr` 或 `target` 为 `NULL`，返回 `NULL`。
+- 如果 `arr` 输入 `NULL`, 返回 `NULL`.
## 使用说明
-- 匹配规则：仅移除与 `target` 值相等的元素；`NULL` 元素不会与任何非 `NULL` 值相等，因此不会被移除。
+- 匹配规则：移除与 `target` 值相等的元素；`NULL` 元素与 `NULL` 值相等。
## 示例
@@ -33,8 +33,10 @@
- `ARRAY_REMOVE([1,2,3], 1)` -> `[2,3]`
- `ARRAY_REMOVE([1,2,3,null], 1)` -> `[2,3,null]`
-- `arr` 或 `target` 为 `NULL`，返回 `NULL`
- - `ARRAY_REMOVE(['a','b','c',NULL], NULL)` -> `NULL`
+- `target` 为 `NULL`，移除 `arr` 中 `NULL`
+ - `ARRAY_REMOVE(['a','b','c',NULL], NULL)` -> `['a', 'b', 'c']`
+
+- `arr` 为 `NULL`， 返回 `NULL`
- `ARRAY_REMOVE(NULL, 2)` -> `NULL`
- 无匹配情况
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sort.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sort.md
index 60e25884408..5785c8e2643 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sort.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sort.md
@@ -29,7 +29,7 @@
## 示例
-- 基本: `NULL` 元素放在返回的数组最后面
+- 基本: `NULL` 元素放在返回的数组最前面
- `ARRAY_SORT([2,1,3,null])` -> `[null, 1, 2, 3]`
- 输入为 `NULL`，返回 `NULL`; 输入为空数组 `[]`，返回空数组。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
