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 6222ac8c6a0 [fix] correct small errors in array, bitmap, and bitwise
function docs (#3707)
6222ac8c6a0 is described below
commit 6222ac8c6a0e01d6689f2f805d46b71e1f012015
Author: boluor <[email protected]>
AuthorDate: Wed May 20 09:00:17 2026 -0700
[fix] correct small errors in array, bitmap, and bitwise function docs
(#3707)
## Summary
Fixes 9 small documentation issues across array, bitmap, and bitwise
function references. Each item below is independent.
- **array-sortby.md** — example `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])`
with keys `[true,false,false]` showed result `[1,2,3]`. Sorting with
these keys (false sorts before true; stable order) yields `[2,3,1]`.
- **array-filter.md** — the closing border of the first result table was
42 dashes while the cells above were 50. Widened to match.
- **array-shuffle.md** — removed an orphan empty `- ` bullet sitting
between the notes list and the `## Examples` heading.
- **array-first.md** — two error-example captions were swapped (each
described the other's error). Restored the correct mapping.
- **arrays-overlap.md** — replaced a stray `◊` placeholder in the
description and `## Function` paragraph with `determine` (the intended
verb).
- **array.md** — frontmatter `"language": "en-US"` → `"en"`; the
parameter line used a full-width Chinese `：` instead of an ASCII `: `.
- **bitmap-hash.md** — the example `select
bitmap_to_string(bitmap_hash(NULL));` had no column alias, but the
result-table header showed `res`. Added `AS res` to the query.
- **bitshiftright.md** — frontmatter `"language": "zh-CN"` in an English
doc → `"en"`.
- **xor.md** (bitwise-functions) — same `"zh-CN"` → `"en"` frontmatter
fix.
## Test plan
- [ ] CI doc build passes
- [ ] Spot-check the affected pages render correctly (array-sortby
result, array-filter table border, array-shuffle notes list, array-first
error sections, arrays-overlap description, array.md parameter line,
bitmap-hash query/result, language metadata for bitshiftright and xor)
---
.../sql-functions/scalar-functions/array-functions/array-filter.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-first.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/array-shuffle.md | 1 -
.../sql-functions/scalar-functions/array-functions/array-sortby.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/arrays-overlap.md | 4 ++--
.../sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md | 2 +-
.../sql-functions/scalar-functions/bitwise-functions/bitshiftright.md | 2 +-
.../sql-functions/scalar-functions/bitwise-functions/xor.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-filter.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-first.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/array-shuffle.md | 1 -
.../sql-functions/scalar-functions/array-functions/array-sortby.md | 2 +-
.../sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-filter.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-first.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/array-shuffle.md | 1 -
.../sql-functions/scalar-functions/array-functions/array-sortby.md | 2 +-
.../sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-filter.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array-first.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/array-shuffle.md | 1 -
.../sql-functions/scalar-functions/array-functions/array-sortby.md | 2 +-
.../sql-functions/scalar-functions/array-functions/array.md | 4 ++--
.../sql-functions/scalar-functions/array-functions/arrays-overlap.md | 4 ++--
.../sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md | 2 +-
.../sql-functions/scalar-functions/bitwise-functions/bitshiftright.md | 2 +-
.../sql-functions/scalar-functions/bitwise-functions/xor.md | 2 +-
28 files changed, 32 insertions(+), 36 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
index ec6d380d8b6..6aa1997e7e1 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
@@ -96,7 +96,7 @@ SELECT array_filter(x -> length(x) > 2, string_array) FROM
array_filter_test WHE
| array_filter(x -> length(x) > 2, string_array) |
+--------------------------------------------------+
| ["ccc", "dddd", "eeeee"] |
-+------------------------------------------+
++--------------------------------------------------+
```
Using boolean array to filter elements:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
index c4498a99f04..b8900b95abd 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
@@ -136,13 +136,13 @@ SELECT array_first(x -> x['a'] > 10, [{'a':5}, {'a':15},
{'a':20}]);
+---------------------------------------------------------------+
```
-Error when parameter count is wrong:
+Error when the number of parameters in lambda expression doesn't match the
number of array parameters:
```sql
SELECT array_first(x -> x > 0, [1,2,3], [4,5,6], [7,8,9]);
ERROR 1105 (HY000): errCode = 2, detailMessage = lambda x -> (x > 0)
arguments' size is not equal parameters' size
```
-Error when the number of parameters in lambda expression doesn't match the
number of array parameters:
+Error when parameter count is wrong:
```sql
SELECT array_first((x, y) -> x > y, [1,2,3], [4,5]);
ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.6)[INVALID_ARGUMENT]in array map function, the input column size are
not equal completely, nested column data rows 1st size is 3, 2th size is 2.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
index 68511d487ef..34ebff32f52 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
@@ -29,7 +29,6 @@ Randomly shuffle the order of elements in an array.
- If the input `arr` is `NULL`, returns `NULL`.
- Providing a `seed` yields reproducible results; omitting it may yield
different results per execution.
- `ARRAY_SHUFFLE` has an alias `SHUFFLE`; they are equivalent.
--
## Examples
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
index 5c0078aa9d0..9f4de51cba0 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
@@ -41,7 +41,7 @@ Sort the `values` array according to the order of a `keys`
array.
- Higher-order: compute `keys` via `lambda`, then sort.
- `ARRAY_SORTBY(x -> x + 1, [3,1,2])` -> `[1,2,3]` (with `keys` `[4,2,3]`)
- - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[1,2,3]` (with `keys`
`[true,false,false]`)
+ - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[2,3,1]` (with `keys`
`[true,false,false]`)
- When `keys` or `values` is `NULL`, return `values` unchanged.
- `array_sortby([10,20,30], NULL)` -> `[10, 20, 30]`
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array.md
index 353b6f00b7d..a782b7a6d85 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array.md
@@ -1,7 +1,7 @@
---
{
"title": "ARRAY | Array Functions",
- "language": "en-US",
+ "language": "en",
"description": "Creates an array. The function accepts zero or more
parameters and returns an array containing all input elements.",
"sidebar_label": "ARRAY"
}
@@ -27,7 +27,7 @@ array([element1, element2, ...])
### Parameters
-- `element1, element2, ...`：Any type, elements to be included in the array.
Supports zero or more parameters.
+- `element1, element2, ...`: Any type, elements to be included in the array.
Supports zero or more parameters.
**Supported element types:**
- Numeric types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE,
DECIMAL
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
index c47a4c5fdcd..83ce038c5ee 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
@@ -2,13 +2,13 @@
{
"title": "ARRAYS_OVERLAP",
"language": "en",
- "description": "ARRAYSOVERLAP is used to ◊ whether two arrays have at
least one common element. Returns true if they do, otherwise returns false."
+ "description": "ARRAYSOVERLAP is used to determine whether two arrays have
at least one common element. Returns true if they do, otherwise returns false."
}
---
## Function
-`ARRAYS_OVERLAP` is used to ◊ whether two arrays have at least one common
element. Returns `true` if they do, otherwise returns `false`.
+`ARRAYS_OVERLAP` is used to determine whether two arrays have at least one
common element. Returns `true` if they do, otherwise returns `false`.
## Syntax
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
b/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
index 55e0093c751..182ba7f0658 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
@@ -70,7 +70,7 @@ The result will be:
```
```sql
-select bitmap_to_string(bitmap_hash(NULL));
+select bitmap_to_string(bitmap_hash(NULL)) AS res;
```
The result will be:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
b/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
index 8d8034a56c8..cfc044b6f3b 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
@@ -1,7 +1,7 @@
---
{
"title": "BIT_SHIFT_RIGHT",
- "language": "zh-CN",
+ "language": "en",
"description": "Performs a right shift bitwise operation, which moves all
bits of a binary number to the right by a specified number of positions."
}
---
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
b/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
index cdaf5def6da..cee374a1a8a 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
@@ -1,7 +1,7 @@
---
{
"title": "XOR | Bitwise Functions",
- "language": "zh-CN",
+ "language": "en",
"description": "Performs a bitwise XOR operation on two BOOLEAN values.",
"sidebar_label": "XOR"
}
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
index aa3314cd554..2a77943d5a9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
@@ -96,7 +96,7 @@ SELECT array_filter(x -> length(x) > 2, string_array) FROM
array_filter_test WHE
| array_filter(x -> length(x) > 2, string_array) |
+--------------------------------------------------+
| ["ccc", "dddd", "eeeee"] |
-+------------------------------------------+
++--------------------------------------------------+
```
使用布尔数组过滤元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
index f9125677798..1577b434446 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
@@ -136,13 +136,13 @@ SELECT array_first(x -> x['a'] > 10, [{'a':5}, {'a':15},
{'a':20}]);
+---------------------------------------------------------------+
```
-参数数量错误会报错：
+lambda 表达式中参数个数和数组参数个数不一致报错：
```sql
SELECT array_first(x -> x > 0, [1,2,3], [4,5,6], [7,8,9]);
ERROR 1105 (HY000): errCode = 2, detailMessage = lambda x -> (x > 0)
arguments' size is not equal parameters' size
```
-lambda 表达式中参数个数和数组参数个数不一致报错：
+参数数量错误会报错：
```sql
SELECT array_first((x, y) -> x > y, [1,2,3], [4,5]);
ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.6)[INVALID_ARGUMENT]in array map function, the input column size are
not equal completely, nested column data rows 1st size is 3, 2th size is 2.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
index 02dde1de9ff..327e2d61234 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
@@ -29,7 +29,6 @@
- 输入的 `arr` 是 `NULL` 时，返回 `NULL`。
- 指定 `seed` 可获得可复现结果；不指定则每次执行结果可能不同。
- `ARRAY_SHUFFLE`的函数别名是 `SHUFFLE`，两个函数功能一致。
--
## 示例
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
index b21dc31080a..d95f723dd20 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
@@ -41,7 +41,7 @@
- 高阶用法：先执行 `lambda` 表达式产生 `keys`，然后再排序。
- `ARRAY_SORTBY(x -> x + 1, [3,1,2])` -> `[1,2,3]` （ `key`为 `[4,2,3]`）
- - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[1,2,3]`（ `key`为
`[true,false,false]`）
+ - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[2,3,1]`（ `key`为
`[true,false,false]`）
- 当 `keys` 或者 `values` 为 `NULL` 时，返回 `values` 保持不变。
- `array_sortby([10,20,30], NULL)` -> `[10, 20, 30]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
index 987a4b869b1..cb1da1b66ed 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
@@ -71,7 +71,7 @@ select bitmap_count(bitmap_union(bitmap_hash(`word`))) from
`words`;
```sql
-select bitmap_to_string(bitmap_hash(NULL));
+select bitmap_to_string(bitmap_hash(NULL)) AS res;
```
结果如下：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
index aa3314cd554..2a77943d5a9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
@@ -96,7 +96,7 @@ SELECT array_filter(x -> length(x) > 2, string_array) FROM
array_filter_test WHE
| array_filter(x -> length(x) > 2, string_array) |
+--------------------------------------------------+
| ["ccc", "dddd", "eeeee"] |
-+------------------------------------------+
++--------------------------------------------------+
```
使用布尔数组过滤元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
index f9125677798..1577b434446 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
@@ -136,13 +136,13 @@ SELECT array_first(x -> x['a'] > 10, [{'a':5}, {'a':15},
{'a':20}]);
+---------------------------------------------------------------+
```
-参数数量错误会报错：
+lambda 表达式中参数个数和数组参数个数不一致报错：
```sql
SELECT array_first(x -> x > 0, [1,2,3], [4,5,6], [7,8,9]);
ERROR 1105 (HY000): errCode = 2, detailMessage = lambda x -> (x > 0)
arguments' size is not equal parameters' size
```
-lambda 表达式中参数个数和数组参数个数不一致报错：
+参数数量错误会报错：
```sql
SELECT array_first((x, y) -> x > y, [1,2,3], [4,5]);
ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.6)[INVALID_ARGUMENT]in array map function, the input column size are
not equal completely, nested column data rows 1st size is 3, 2th size is 2.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
index 02dde1de9ff..327e2d61234 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
@@ -29,7 +29,6 @@
- 输入的 `arr` 是 `NULL` 时，返回 `NULL`。
- 指定 `seed` 可获得可复现结果；不指定则每次执行结果可能不同。
- `ARRAY_SHUFFLE`的函数别名是 `SHUFFLE`，两个函数功能一致。
--
## 示例
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
index b21dc31080a..d95f723dd20 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
@@ -41,7 +41,7 @@
- 高阶用法：先执行 `lambda` 表达式产生 `keys`，然后再排序。
- `ARRAY_SORTBY(x -> x + 1, [3,1,2])` -> `[1,2,3]` （ `key`为 `[4,2,3]`）
- - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[1,2,3]`（ `key`为
`[true,false,false]`）
+ - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[2,3,1]`（ `key`为
`[true,false,false]`）
- 当 `keys` 或者 `values` 为 `NULL` 时，返回 `values` 保持不变。
- `array_sortby([10,20,30], NULL)` -> `[10, 20, 30]`
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
index 987a4b869b1..cb1da1b66ed 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
@@ -71,7 +71,7 @@ select bitmap_count(bitmap_union(bitmap_hash(`word`))) from
`words`;
```sql
-select bitmap_to_string(bitmap_hash(NULL));
+select bitmap_to_string(bitmap_hash(NULL)) AS res;
```
结果如下：
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
index ec6d380d8b6..6aa1997e7e1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-filter.md
@@ -96,7 +96,7 @@ SELECT array_filter(x -> length(x) > 2, string_array) FROM
array_filter_test WHE
| array_filter(x -> length(x) > 2, string_array) |
+--------------------------------------------------+
| ["ccc", "dddd", "eeeee"] |
-+------------------------------------------+
++--------------------------------------------------+
```
Using boolean array to filter elements:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
index c4498a99f04..b8900b95abd 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-first.md
@@ -136,13 +136,13 @@ SELECT array_first(x -> x['a'] > 10, [{'a':5}, {'a':15},
{'a':20}]);
+---------------------------------------------------------------+
```
-Error when parameter count is wrong:
+Error when the number of parameters in lambda expression doesn't match the
number of array parameters:
```sql
SELECT array_first(x -> x > 0, [1,2,3], [4,5,6], [7,8,9]);
ERROR 1105 (HY000): errCode = 2, detailMessage = lambda x -> (x > 0)
arguments' size is not equal parameters' size
```
-Error when the number of parameters in lambda expression doesn't match the
number of array parameters:
+Error when parameter count is wrong:
```sql
SELECT array_first((x, y) -> x > y, [1,2,3], [4,5]);
ERROR 1105 (HY000): errCode = 2, detailMessage =
(10.16.10.6)[INVALID_ARGUMENT]in array map function, the input column size are
not equal completely, nested column data rows 1st size is 3, 2th size is 2.
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
index 68511d487ef..34ebff32f52 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-shuffle.md
@@ -29,7 +29,6 @@ Randomly shuffle the order of elements in an array.
- If the input `arr` is `NULL`, returns `NULL`.
- Providing a `seed` yields reproducible results; omitting it may yield
different results per execution.
- `ARRAY_SHUFFLE` has an alias `SHUFFLE`; they are equivalent.
--
## Examples
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
index 5c0078aa9d0..9f4de51cba0 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-sortby.md
@@ -41,7 +41,7 @@ Sort the `values` array according to the order of a `keys`
array.
- Higher-order: compute `keys` via `lambda`, then sort.
- `ARRAY_SORTBY(x -> x + 1, [3,1,2])` -> `[1,2,3]` (with `keys` `[4,2,3]`)
- - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[1,2,3]` (with `keys`
`[true,false,false]`)
+ - `ARRAY_SORTBY(x -> x*2 <= 2, [1,2,3])` -> `[2,3,1]` (with `keys`
`[true,false,false]`)
- When `keys` or `values` is `NULL`, return `values` unchanged.
- `array_sortby([10,20,30], NULL)` -> `[10, 20, 30]`
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
index 353b6f00b7d..a782b7a6d85 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
@@ -1,7 +1,7 @@
---
{
"title": "ARRAY | Array Functions",
- "language": "en-US",
+ "language": "en",
"description": "Creates an array. The function accepts zero or more
parameters and returns an array containing all input elements.",
"sidebar_label": "ARRAY"
}
@@ -27,7 +27,7 @@ array([element1, element2, ...])
### Parameters
-- `element1, element2, ...`：Any type, elements to be included in the array.
Supports zero or more parameters.
+- `element1, element2, ...`: Any type, elements to be included in the array.
Supports zero or more parameters.
**Supported element types:**
- Numeric types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE,
DECIMAL
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
index c47a4c5fdcd..83ce038c5ee 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/arrays-overlap.md
@@ -2,13 +2,13 @@
{
"title": "ARRAYS_OVERLAP",
"language": "en",
- "description": "ARRAYSOVERLAP is used to ◊ whether two arrays have at
least one common element. Returns true if they do, otherwise returns false."
+ "description": "ARRAYSOVERLAP is used to determine whether two arrays have
at least one common element. Returns true if they do, otherwise returns false."
}
---
## Function
-`ARRAYS_OVERLAP` is used to ◊ whether two arrays have at least one common
element. Returns `true` if they do, otherwise returns `false`.
+`ARRAYS_OVERLAP` is used to determine whether two arrays have at least one
common element. Returns `true` if they do, otherwise returns `false`.
## Syntax
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
index 55e0093c751..182ba7f0658 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-hash.md
@@ -70,7 +70,7 @@ The result will be:
```
```sql
-select bitmap_to_string(bitmap_hash(NULL));
+select bitmap_to_string(bitmap_hash(NULL)) AS res;
```
The result will be:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
index 8d8034a56c8..cfc044b6f3b 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/bitshiftright.md
@@ -1,7 +1,7 @@
---
{
"title": "BIT_SHIFT_RIGHT",
- "language": "zh-CN",
+ "language": "en",
"description": "Performs a right shift bitwise operation, which moves all
bits of a binary number to the right by a specified number of positions."
}
---
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
index cdaf5def6da..cee374a1a8a 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitwise-functions/xor.md
@@ -1,7 +1,7 @@
---
{
"title": "XOR | Bitwise Functions",
- "language": "zh-CN",
+ "language": "en",
"description": "Performs a bitwise XOR operation on two BOOLEAN values.",
"sidebar_label": "XOR"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
