This is an automated email from the ASF dual-hosted git repository.
zclllyybb 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 bd36eeaff3b [Fix](doc) Fix the inaccurate behavior of some functions
in the document (#3869)
bd36eeaff3b is described below
commit bd36eeaff3b4c51445e5931a214ace5f7741b81d
Author: linrrarity <[email protected]>
AuthorDate: Tue Jun 2 10:17:47 2026 +0800
[Fix](doc) Fix the inaccurate behavior of some functions in the document
(#3869)
## Versions
- [x] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1 or older (not covered by version/language sync gate)
## Languages
- [x] Chinese
- [x] English
- [ ] Japanese candidate translation needed
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
- [ ] Updated required version and language counterparts, or explained
why not
- [ ] If only one language changed, confirmed whether source/translation
counterparts need sync
---
.../aggregate-functions/count-by-enum.md | 2 ++
.../scalar-functions/array-functions/array.md | 10 +++----
.../scalar-functions/numeric-functions/signbit.md | 32 +++++++++++-----------
.../scalar-functions/string-functions/ends-with.md | 2 +-
.../string-functions/mask-last-n.md | 2 +-
.../scalar-functions/string-functions/mask.md | 2 +-
.../scalar-functions/string-functions/position.md | 10 +++----
.../scalar-functions/string-functions/reverse.md | 10 +++----
docs/table-design/data-model/aggregate.md | 2 +-
.../aggregate-functions/count-by-enum.md | 2 ++
.../scalar-functions/array-functions/array.md | 10 +++----
.../scalar-functions/numeric-functions/signbit.md | 32 +++++++++++-----------
.../scalar-functions/string-functions/ends-with.md | 2 +-
.../string-functions/mask-last-n.md | 2 +-
.../scalar-functions/string-functions/mask.md | 2 +-
.../scalar-functions/string-functions/position.md | 10 +++----
.../scalar-functions/string-functions/reverse.md | 10 +++----
.../current/table-design/data-model/aggregate.md | 2 +-
.../aggregate-functions/count-by-enum.md | 2 ++
.../scalar-functions/array-functions/array.md | 10 +++----
.../scalar-functions/numeric-functions/signbit.md | 32 +++++++++++-----------
.../scalar-functions/string-functions/ends-with.md | 2 +-
.../string-functions/mask-last-n.md | 2 +-
.../scalar-functions/string-functions/mask.md | 2 +-
.../scalar-functions/string-functions/position.md | 10 +++----
.../scalar-functions/string-functions/reverse.md | 10 +++----
.../table-design/data-model/aggregate.md | 2 +-
.../aggregate-functions/count-by-enum.md | 2 ++
.../scalar-functions/array-functions/array.md | 10 +++----
.../scalar-functions/numeric-functions/signbit.md | 32 +++++++++++-----------
.../scalar-functions/string-functions/ends-with.md | 2 +-
.../string-functions/mask-last-n.md | 2 +-
.../scalar-functions/string-functions/mask.md | 2 +-
.../scalar-functions/string-functions/position.md | 10 +++----
.../scalar-functions/string-functions/reverse.md | 10 +++----
.../table-design/data-model/aggregate.md | 2 +-
36 files changed, 148 insertions(+), 140 deletions(-)
diff --git a/docs/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
b/docs/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
index fee4c17c63c..07b6fb95206 100644
--- a/docs/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
+++ b/docs/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
@@ -67,6 +67,8 @@ Description: The return value is a JSON array string, and the
order of internal
## Example
+Because the order of JSON objects in the result is not stable, the result may
be:
+
```sql
CREATE TABLE count_by_enum_test(
`id` varchar(1024) NULL,
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 a782b7a6d85..c4b604173b8 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
@@ -65,11 +65,11 @@ SELECT array(1, 2, 3, 4, 5);
Create an array with elements of different types:
```sql
SELECT array(1, 'hello', 3.14, true);
-+----------------------------------+
-| array(1, 'hello', 3.14, true) |
-+----------------------------------+
-| ["1", "hello", "3.14", "true"] |
-+----------------------------------+
++-------------------------------+
+| array(1, 'hello', 3.14, true) |
++-------------------------------+
+| ["1", "hello", "3.14", "1"] |
++-------------------------------+
```
Create an empty array:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 253d79e0146..c0eae62d1e0 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -53,11 +53,11 @@ select signbit(-1.0);
```
```text
-+-----------------------------+
-| signbit(cast(-1 as DOUBLE)) |
-+-----------------------------+
-| true |
-+-----------------------------+
++---------------+
+| signbit(-1.0) |
++---------------+
+| 1 |
++---------------+
```
```sql
@@ -65,11 +65,11 @@ select signbit(0.0);
```
```text
-+----------------------------+
-| signbit(cast(0 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(0.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -77,11 +77,11 @@ select signbit(1.0);
```
```text
-+----------------------------+
-| signbit(cast(1 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(1.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| false | true |
+| 0 | 1 |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
index e0e9d028957..75b450ba851 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
@@ -97,7 +97,7 @@ SELECT ENDS_WITH('test', 'test'), ENDS_WITH('testing',
'test');
+---------------------------+------------------------------+
| ENDS_WITH('test', 'test') | ENDS_WITH('testing', 'test') |
+---------------------------+------------------------------+
-| 1 | 1 |
+| 1 | 0 |
+---------------------------+------------------------------+
```
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 905d9d811d5..3ab696edb57 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
@@ -144,7 +144,7 @@ SELECT mask_last_n('ABC-123-xyz', 7);
10. UTF-8 character handling (masks by byte)
```sql
-SELECT mask_last_n('Helloṭṛ123', 9);
+SELECT mask_last_n('Hello你好123', 9);
```
```text
+--------------------------------+
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 c922360b272..80df0ef1983 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
@@ -128,7 +128,7 @@ SELECT mask('Test123', 'ABC', 'xyz', '999');
+--------------------------------------+
| mask('Test123', 'ABC', 'xyz', '999') |
+--------------------------------------+
-| Xxxx999 |
+| Axxx999 |
+--------------------------------------+
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index 7c7ff828613..225a1def47f 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -121,11 +121,11 @@ SELECT POSITION('a', 'banana', 1), POSITION('a',
'banana', 3);
SELECT POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello'), POSITION('hello', 'ṭṛì ḍḍumai
hello', 8);
```
```text
-+--------------------------------------+-------------------------------------------+
-| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello', 'ṭṛì ḍḍumai
hello', 8) |
-+--------------------------------------+-------------------------------------------+
-| 5 |
13 |
-+--------------------------------------+-------------------------------------------+
++-------------------------------------------------------+---------------------------------------------------+
+| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello',
'ṭṛì ḍḍumai hello', 8) |
++-------------------------------------------------------+---------------------------------------------------+
+| 5 |
12 |
++-------------------------------------------------------+---------------------------------------------------+
```
8. Special character search
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index e1892f149b8..2ea4a4b22f4 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -113,11 +113,11 @@ SELECT REVERSE('12345'), REVERSE('!@#$%');
SELECT REVERSE('ṭṛì ḍḍumai'), REVERSE('ḍḍumannàri');
```
```text
-+-----------------------+------------------------+
-| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
-+-----------------------+------------------------+
-| iamuḍḍ ìṛṭ | irànnaumuḍḍ |
-+-----------------------+------------------------+
++--------------------------------+----------------------------+
+| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
++--------------------------------+----------------------------+
+| iamuḍḍ ìṛṭ | irànnamuḍḍ |
++--------------------------------+----------------------------+
```
8. Mixed character types
diff --git a/docs/table-design/data-model/aggregate.md
b/docs/table-design/data-model/aggregate.md
index 5b68d136b68..fa57a18255c 100644
--- a/docs/table-design/data-model/aggregate.md
+++ b/docs/table-design/data-model/aggregate.md
@@ -168,7 +168,7 @@ The computation in the table at this point is shown in the
following figure:
-The query results are as follows:
+Because `group_concat` is order-sensitive, the result is unstable. The query
results are as follows:
```sql
mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
index b0b5b01143b..3bd2dc1a10c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
@@ -66,6 +66,8 @@ COUNT_BY_ENUM(<expr1>, <expr2>, ... , <exprN>)
## 举例
+由于结果中的 JSON 对象顺序可能不固定，下面结果可能为：
+
```sql
CREATE TABLE count_by_enum_test(
`id` varchar(1024) NULL,
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array.md
index fb6d9109937..72631e18d85 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array.md
@@ -65,11 +65,11 @@ SELECT array(1, 2, 3, 4, 5);
创建包含不同类型元素的数组：
```sql
SELECT array(1, 'hello', 3.14, true);
-+----------------------------------+
-| array(1, 'hello', 3.14, true) |
-+----------------------------------+
-| ["1", "hello", "3.14", "true"] |
-+----------------------------------+
++-------------------------------+
+| array(1, 'hello', 3.14, true) |
++-------------------------------+
+| ["1", "hello", "3.14", "1"] |
++-------------------------------+
```
创建空数组：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index cb4a6bcac4a..dd680684459 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -53,11 +53,11 @@ select signbit(-1.0);
```
```text
-+-----------------------------+
-| signbit(cast(-1 as DOUBLE)) |
-+-----------------------------+
-| true |
-+-----------------------------+
++---------------+
+| signbit(-1.0) |
++---------------+
+| 1 |
++---------------+
```
```sql
@@ -65,11 +65,11 @@ select signbit(0.0);
```
```text
-+----------------------------+
-| signbit(cast(0 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(0.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -77,11 +77,11 @@ select signbit(1.0);
```
```text
-+----------------------------+
-| signbit(cast(1 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(1.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| false | true |
+| 0 | 1 |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
index 02bd80125ab..6b844f05ff7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
@@ -97,7 +97,7 @@ SELECT ENDS_WITH('test', 'test'), ENDS_WITH('testing',
'test');
+---------------------------+------------------------------+
| ENDS_WITH('test', 'test') | ENDS_WITH('testing', 'test') |
+---------------------------+------------------------------+
-| 1 | 1 |
+| 1 | 0 |
+---------------------------+------------------------------+
```
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 e632f602aa1..0b8de159820 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
@@ -157,7 +157,7 @@ SELECT mask_last_n('ABC-123-xyz', 7);
10. UTF-8 字符处理（按字节脱敏）
```sql
-SELECT mask_last_n('Helloṭṛ123', 9);
+SELECT mask_last_n('Hello你好123', 9);
```
```text
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 676124aaba4..186012302ed 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
@@ -138,7 +138,7 @@ SELECT mask('Test123', 'ABC', 'xyz', '999');
+--------------------------------------+
| mask('Test123', 'ABC', 'xyz', '999') |
+--------------------------------------+
-| Xxxx999 |
+| Axxx999 |
+--------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index e54059eb9bc..a83d7e3be3d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -121,11 +121,11 @@ SELECT POSITION('a', 'banana', 1), POSITION('a',
'banana', 3);
SELECT POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello'), POSITION('hello', 'ṭṛì ḍḍumai
hello', 8);
```
```text
-+--------------------------------------+-------------------------------------------+
-| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello', 'ṭṛì ḍḍumai
hello', 8) |
-+--------------------------------------+-------------------------------------------+
-| 5 |
13 |
-+--------------------------------------+-------------------------------------------+
++-------------------------------------------------------+---------------------------------------------------+
+| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello',
'ṭṛì ḍḍumai hello', 8) |
++-------------------------------------------------------+---------------------------------------------------+
+| 5 |
12 |
++-------------------------------------------------------+---------------------------------------------------+
```
8. 特殊字符查找
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index a89a5289cdd..d6fb7451094 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -113,11 +113,11 @@ SELECT REVERSE('12345'), REVERSE('!@#$%');
SELECT REVERSE('ṭṛì ḍḍumai'), REVERSE('ḍḍumannàri');
```
```text
-+-----------------------+------------------------+
-| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
-+-----------------------+------------------------+
-| iamuḍḍ ìṛṭ | irànnaumuḍḍ |
-+-----------------------+------------------------+
++--------------------------------+----------------------------+
+| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
++--------------------------------+----------------------------+
+| iamuḍḍ ìṛṭ | irànnamuḍḍ |
++--------------------------------+----------------------------+
```
8. 混合字符类型
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
index 42de20f8d52..8c01de4b914 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
@@ -168,7 +168,7 @@ SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
-查询结果如下：
+由于 group_concat 对顺序有要求，结果是不稳定的，结果可能为：
```sql
mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
index b0b5b01143b..3bd2dc1a10c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
@@ -66,6 +66,8 @@ COUNT_BY_ENUM(<expr1>, <expr2>, ... , <exprN>)
## 举例
+由于结果中的 JSON 对象顺序可能不固定，下面结果可能为：
+
```sql
CREATE TABLE count_by_enum_test(
`id` varchar(1024) NULL,
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
index fb6d9109937..72631e18d85 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array.md
@@ -65,11 +65,11 @@ SELECT array(1, 2, 3, 4, 5);
创建包含不同类型元素的数组：
```sql
SELECT array(1, 'hello', 3.14, true);
-+----------------------------------+
-| array(1, 'hello', 3.14, true) |
-+----------------------------------+
-| ["1", "hello", "3.14", "true"] |
-+----------------------------------+
++-------------------------------+
+| array(1, 'hello', 3.14, true) |
++-------------------------------+
+| ["1", "hello", "3.14", "1"] |
++-------------------------------+
```
创建空数组：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index cb4a6bcac4a..dd680684459 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -53,11 +53,11 @@ select signbit(-1.0);
```
```text
-+-----------------------------+
-| signbit(cast(-1 as DOUBLE)) |
-+-----------------------------+
-| true |
-+-----------------------------+
++---------------+
+| signbit(-1.0) |
++---------------+
+| 1 |
++---------------+
```
```sql
@@ -65,11 +65,11 @@ select signbit(0.0);
```
```text
-+----------------------------+
-| signbit(cast(0 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(0.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -77,11 +77,11 @@ select signbit(1.0);
```
```text
-+----------------------------+
-| signbit(cast(1 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(1.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| false | true |
+| 0 | 1 |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
index 02bd80125ab..6b844f05ff7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
@@ -97,7 +97,7 @@ SELECT ENDS_WITH('test', 'test'), ENDS_WITH('testing',
'test');
+---------------------------+------------------------------+
| ENDS_WITH('test', 'test') | ENDS_WITH('testing', 'test') |
+---------------------------+------------------------------+
-| 1 | 1 |
+| 1 | 0 |
+---------------------------+------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index e632f602aa1..0b8de159820 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -157,7 +157,7 @@ SELECT mask_last_n('ABC-123-xyz', 7);
10. UTF-8 字符处理（按字节脱敏）
```sql
-SELECT mask_last_n('Helloṭṛ123', 9);
+SELECT mask_last_n('Hello你好123', 9);
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
index 676124aaba4..186012302ed 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
@@ -138,7 +138,7 @@ SELECT mask('Test123', 'ABC', 'xyz', '999');
+--------------------------------------+
| mask('Test123', 'ABC', 'xyz', '999') |
+--------------------------------------+
-| Xxxx999 |
+| Axxx999 |
+--------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index e54059eb9bc..a83d7e3be3d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -121,11 +121,11 @@ SELECT POSITION('a', 'banana', 1), POSITION('a',
'banana', 3);
SELECT POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello'), POSITION('hello', 'ṭṛì ḍḍumai
hello', 8);
```
```text
-+--------------------------------------+-------------------------------------------+
-| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello', 'ṭṛì ḍḍumai
hello', 8) |
-+--------------------------------------+-------------------------------------------+
-| 5 |
13 |
-+--------------------------------------+-------------------------------------------+
++-------------------------------------------------------+---------------------------------------------------+
+| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello',
'ṭṛì ḍḍumai hello', 8) |
++-------------------------------------------------------+---------------------------------------------------+
+| 5 |
12 |
++-------------------------------------------------------+---------------------------------------------------+
```
8. 特殊字符查找
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index a89a5289cdd..d6fb7451094 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -113,11 +113,11 @@ SELECT REVERSE('12345'), REVERSE('!@#$%');
SELECT REVERSE('ṭṛì ḍḍumai'), REVERSE('ḍḍumannàri');
```
```text
-+-----------------------+------------------------+
-| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
-+-----------------------+------------------------+
-| iamuḍḍ ìṛṭ | irànnaumuḍḍ |
-+-----------------------+------------------------+
++--------------------------------+----------------------------+
+| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
++--------------------------------+----------------------------+
+| iamuḍḍ ìṛṭ | irànnamuḍḍ |
++--------------------------------+----------------------------+
```
8. 混合字符类型
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
index 42de20f8d52..8c01de4b914 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
@@ -168,7 +168,7 @@ SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
-查询结果如下：
+由于 group_concat 对顺序有要求，结果是不稳定的，结果可能为：
```sql
mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
index fee4c17c63c..07b6fb95206 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/aggregate-functions/count-by-enum.md
@@ -67,6 +67,8 @@ Description: The return value is a JSON array string, and the
order of internal
## Example
+Because the order of JSON objects in the result is not stable, the result may
be:
+
```sql
CREATE TABLE count_by_enum_test(
`id` varchar(1024) NULL,
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 a782b7a6d85..c4b604173b8 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
@@ -65,11 +65,11 @@ SELECT array(1, 2, 3, 4, 5);
Create an array with elements of different types:
```sql
SELECT array(1, 'hello', 3.14, true);
-+----------------------------------+
-| array(1, 'hello', 3.14, true) |
-+----------------------------------+
-| ["1", "hello", "3.14", "true"] |
-+----------------------------------+
++-------------------------------+
+| array(1, 'hello', 3.14, true) |
++-------------------------------+
+| ["1", "hello", "3.14", "1"] |
++-------------------------------+
```
Create an empty array:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
index 253d79e0146..c0eae62d1e0 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/signbit.md
@@ -53,11 +53,11 @@ select signbit(-1.0);
```
```text
-+-----------------------------+
-| signbit(cast(-1 as DOUBLE)) |
-+-----------------------------+
-| true |
-+-----------------------------+
++---------------+
+| signbit(-1.0) |
++---------------+
+| 1 |
++---------------+
```
```sql
@@ -65,11 +65,11 @@ select signbit(0.0);
```
```text
-+----------------------------+
-| signbit(cast(0 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(0.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -77,11 +77,11 @@ select signbit(1.0);
```
```text
-+----------------------------+
-| signbit(cast(1 as DOUBLE)) |
-+----------------------------+
-| false |
-+----------------------------+
++--------------+
+| signbit(1.0) |
++--------------+
+| 0 |
++--------------+
```
```sql
@@ -92,6 +92,6 @@ select signbit(cast('+0.0' as double)) , signbit(cast('-0.0'
as double));
+---------------------------------+---------------------------------+
| signbit(cast('+0.0' as double)) | signbit(cast('-0.0' as double)) |
+---------------------------------+---------------------------------+
-| false | true |
+| 0 | 1 |
+---------------------------------+---------------------------------+
```
\ No newline at end of file
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
index e0e9d028957..75b450ba851 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/ends-with.md
@@ -97,7 +97,7 @@ SELECT ENDS_WITH('test', 'test'), ENDS_WITH('testing',
'test');
+---------------------------+------------------------------+
| ENDS_WITH('test', 'test') | ENDS_WITH('testing', 'test') |
+---------------------------+------------------------------+
-| 1 | 1 |
+| 1 | 0 |
+---------------------------+------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
index 905d9d811d5..3ab696edb57 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask-last-n.md
@@ -144,7 +144,7 @@ SELECT mask_last_n('ABC-123-xyz', 7);
10. UTF-8 character handling (masks by byte)
```sql
-SELECT mask_last_n('Helloṭṛ123', 9);
+SELECT mask_last_n('Hello你好123', 9);
```
```text
+--------------------------------+
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
index c922360b272..80df0ef1983 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/mask.md
@@ -128,7 +128,7 @@ SELECT mask('Test123', 'ABC', 'xyz', '999');
+--------------------------------------+
| mask('Test123', 'ABC', 'xyz', '999') |
+--------------------------------------+
-| Xxxx999 |
+| Axxx999 |
+--------------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
index 7c7ff828613..225a1def47f 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/position.md
@@ -121,11 +121,11 @@ SELECT POSITION('a', 'banana', 1), POSITION('a',
'banana', 3);
SELECT POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello'), POSITION('hello', 'ṭṛì ḍḍumai
hello', 8);
```
```text
-+--------------------------------------+-------------------------------------------+
-| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello', 'ṭṛì ḍḍumai
hello', 8) |
-+--------------------------------------+-------------------------------------------+
-| 5 |
13 |
-+--------------------------------------+-------------------------------------------+
++-------------------------------------------------------+---------------------------------------------------+
+| POSITION('ḍḍumai' IN 'ṭṛì ḍḍumai hello') | POSITION('hello',
'ṭṛì ḍḍumai hello', 8) |
++-------------------------------------------------------+---------------------------------------------------+
+| 5 |
12 |
++-------------------------------------------------------+---------------------------------------------------+
```
8. Special character search
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
index e1892f149b8..2ea4a4b22f4 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/reverse.md
@@ -113,11 +113,11 @@ SELECT REVERSE('12345'), REVERSE('!@#$%');
SELECT REVERSE('ṭṛì ḍḍumai'), REVERSE('ḍḍumannàri');
```
```text
-+-----------------------+------------------------+
-| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
-+-----------------------+------------------------+
-| iamuḍḍ ìṛṭ | irànnaumuḍḍ |
-+-----------------------+------------------------+
++--------------------------------+----------------------------+
+| REVERSE('ṭṛì ḍḍumai') | REVERSE('ḍḍumannàri') |
++--------------------------------+----------------------------+
+| iamuḍḍ ìṛṭ | irànnamuḍḍ |
++--------------------------------+----------------------------+
```
8. Mixed character types
diff --git a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
index 5b68d136b68..fa57a18255c 100644
--- a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
@@ -168,7 +168,7 @@ The computation in the table at this point is shown in the
following figure:
-The query results are as follows:
+Because `group_concat` is order-sensitive, the result is unstable. The query
results are as follows:
```sql
mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
