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 326b8c9a6f7 [Fix](doc) Fix the inaccurate behavior of some functions
in the document (#3913)
326b8c9a6f7 is described below
commit 326b8c9a6f7366f5abf9d0a2deaa9df2aaa0753e
Author: linrrarity <[email protected]>
AuthorDate: Thu Jun 11 20:10:04 2026 +0800
[Fix](doc) Fix the inaccurate behavior of some functions in the document
(#3913)
## Versions
- [x] dev
- [x] 4.x
- [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
---
.../ai-functions/distance-functions/cosine-distance.md | 2 +-
.../ai-functions/distance-functions/l2-distance.md | 2 +-
.../scalar-functions/array-functions/array-concat.md | 4 ++--
.../scalar-functions/array-functions/array-cum-sum.md | 5 +++--
.../scalar-functions/array-functions/array-popback.md | 8 ++++----
.../scalar-functions/array-functions/array-popfront.md | 8 ++++----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 4 ++--
.../scalar-functions/date-time-functions/extract.md | 10 +++++-----
.../scalar-functions/date-time-functions/month-floor.md | 10 +++++-----
.../scalar-functions/date-time-functions/timediff.md | 10 +++++-----
.../scalar-functions/json-functions/json-extract.md | 12 ++++++------
.../scalar-functions/numeric-functions/fmod.md | 10 +++++-----
.../string-functions/auto-partition-name.md | 10 +++++-----
.../scalar-functions/string-functions/to-base64.md | 2 +-
.../ai-functions/distance-functions/cosine-distance.md | 2 +-
.../ai-functions/distance-functions/l2-distance.md | 2 +-
.../scalar-functions/array-functions/array-concat.md | 4 ++--
.../scalar-functions/array-functions/array-cum-sum.md | 2 +-
.../scalar-functions/array-functions/array-popback.md | 8 ++++----
.../scalar-functions/array-functions/array-popfront.md | 8 ++++----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 4 ++--
.../scalar-functions/date-time-functions/extract.md | 10 +++++-----
.../scalar-functions/date-time-functions/month-floor.md | 2 +-
.../scalar-functions/date-time-functions/timediff.md | 10 +++++-----
.../scalar-functions/json-functions/json-extract.md | 14 +++++++-------
.../scalar-functions/numeric-functions/fmod.md | 10 +++++-----
.../string-functions/auto-partition-name.md | 10 +++++-----
.../scalar-functions/string-functions/from-base64.md | 4 ++--
.../scalar-functions/string-functions/instr.md | 10 +++++-----
.../scalar-functions/string-functions/length.md | 10 +++++-----
.../scalar-functions/string-functions/locate.md | 2 +-
.../scalar-functions/string-functions/lpad.md | 2 +-
.../scalar-functions/string-functions/to-base64.md | 2 +-
.../scalar-functions/array-functions/array-exists.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 10 +++++-----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 12 ++++++------
.../scalar-functions/json-functions/json-extract.md | 5 ++---
.../scalar-functions/numeric-functions/fmod.md | 10 +++++-----
.../ai-functions/distance-functions/cosine-distance.md | 2 +-
.../ai-functions/distance-functions/l2-distance.md | 2 +-
.../scalar-functions/array-functions/array-concat.md | 4 ++--
.../scalar-functions/array-functions/array-cum-sum.md | 2 +-
.../scalar-functions/array-functions/array-popback.md | 8 ++++----
.../scalar-functions/array-functions/array-popfront.md | 8 ++++----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 4 ++--
.../scalar-functions/date-time-functions/extract.md | 10 +++++-----
.../scalar-functions/date-time-functions/month-floor.md | 2 +-
.../scalar-functions/date-time-functions/timediff.md | 10 +++++-----
.../scalar-functions/json-functions/json-extract.md | 14 +++++++-------
.../scalar-functions/numeric-functions/fmod.md | 10 +++++-----
.../string-functions/auto-partition-name.md | 10 +++++-----
.../scalar-functions/string-functions/instr.md | 10 +++++-----
.../scalar-functions/string-functions/length.md | 10 +++++-----
.../scalar-functions/string-functions/to-base64.md | 2 +-
.../scalar-functions/array-functions/array-exists.md | 2 +-
.../scalar-functions/array-functions/array-split.md | 10 +++++-----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 12 ++++++------
.../scalar-functions/json-functions/json-extract.md | 4 ++--
.../scalar-functions/numeric-functions/fmod.md | 12 ++++++------
.../ai-functions/distance-functions/cosine-distance.md | 2 +-
.../ai-functions/distance-functions/l2-distance.md | 2 +-
.../scalar-functions/array-functions/array-concat.md | 4 ++--
.../scalar-functions/array-functions/array-cum-sum.md | 2 +-
.../scalar-functions/array-functions/array-popback.md | 8 ++++----
.../scalar-functions/array-functions/array-popfront.md | 8 ++++----
.../scalar-functions/bitmap-functions/bitmap-to-base64.md | 4 ++--
.../scalar-functions/date-time-functions/extract.md | 10 +++++-----
.../scalar-functions/date-time-functions/month-floor.md | 10 +++++-----
.../scalar-functions/date-time-functions/timediff.md | 10 +++++-----
.../scalar-functions/json-functions/json-extract.md | 12 ++++++------
.../scalar-functions/numeric-functions/fmod.md | 10 +++++-----
.../string-functions/auto-partition-name.md | 10 +++++-----
.../scalar-functions/string-functions/to-base64.md | 2 +-
73 files changed, 247 insertions(+), 247 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
index e6cbe12c507..316bfd72c6f 100644
---
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
+++
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
@@ -37,6 +37,6 @@ SELECT COSINE_DISTANCE([1, 2], [2, 3]),COSINE_DISTANCE([3,
6], [4, 7]);
+---------------------------------+---------------------------------+
| cosine_distance([1, 2], [2, 3]) | cosine_distance([3, 6], [4, 7]) |
+---------------------------------+---------------------------------+
-| 0.007722123286332261 | 0.0015396467945875125 |
+| 0.007722139 | 0.001539648 |
+---------------------------------+---------------------------------+
```
diff --git
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
index 82f823bf1bd..917f8ef883e 100644
---
a/docs/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
+++
b/docs/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
@@ -37,6 +37,6 @@ SELECT L2_DISTANCE([4, 5], [6, 8]),L2_DISTANCE([3, 6], [4,
5]);
+-----------------------------+-----------------------------+
| l2_distance([4, 5], [6, 8]) | l2_distance([3, 6], [4, 5]) |
+-----------------------------+-----------------------------+
-| 3.605551275463989 | 1.4142135623730951 |
+| 3.605551 | 1.414214 |
+-----------------------------+-----------------------------+
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
index d2703bb107b..a67c7e0772c 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
@@ -125,13 +125,13 @@ SELECT array_concat(int_array1, int_array2) FROM
array_concat_test WHERE id = 5;
+--------------------------------------+
```
-Type compatibility example: concatenating int_array1 and string_array1, string
elements cannot be converted to int, resulting in null.
+Type compatibility example: concatenating int_array1 and string_array1
converts integer elements to strings and retains all elements.
```sql
SELECT array_concat(int_array1, string_array1) FROM array_concat_test WHERE id
= 1;
+-----------------------------------------+
| array_concat(int_array1, string_array1) |
+-----------------------------------------+
-| [1, 2, 3, null, null] |
+| ["1", "2", "3", "a", "b"] |
+-----------------------------------------+
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
index cbdc198a864..95a269c29cd 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
@@ -100,10 +100,11 @@ SELECT array_cum_sum(['a', 1, 'b', 2, 'c', 3]);
+-----------------------------------------+
| array_cum_sum(['a', 1, 'b', 2, 'c', 3]) |
+-----------------------------------------+
-| [0, 1, 1, 3, 3, 6] |
+| [null, 1, null, 3, null, 6] |
+-----------------------------------------+
```
-
+Hello Hello.,Hello123hello
+Hello Hello.,Hello123hello
Empty array returns empty array:
```sql
SELECT array_cum_sum(int_array) FROM array_cum_sum_test WHERE id = 3;
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
index 08f34ec8d26..6b8c071af56 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
@@ -122,11 +122,11 @@ SELECT array_popback([[1, 2], [3, 4], [5, 6]]);
Remove the last element from a MAP array:
```sql
SELECT array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
| array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Alice","age":20}, {"name":"Bob","age":30}]
|
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
+| [{"name":"Alice", "age":"20"}, {"name":"Bob", "age":"30"}]
|
++--------------------------------------------------------------------------------------------------+
```
Remove the last element from a STRUCT array:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
index 15189721183..9a3f05eb5d1 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
@@ -122,11 +122,11 @@ SELECT array_popfront([[1, 2], [3, 4], [5, 6]]);
Remove the first element from a MAP array:
```sql
SELECT array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
| array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Bob","age":30}, {"name":"Charlie","age":40}]
|
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
+| [{"name":"Bob", "age":"30"}, {"name":"Charlie", "age":"40"}]
|
++---------------------------------------------------------------------------------------------------+
```
Remove the first element from a STRUCT array:
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index e6a5ff2257d..cd5cb79f2ec 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ The result will be:
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -96,6 +96,6 @@ The result will be:
+---------------------------------------------------------+
| bitmap_to_base64(bitmap_from_string("1,9999999")) |
+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
+| BQIBAAAAAAAAAH+WmAAAAAAA |
+---------------------------------------------------------+
```
\ No newline at end of file
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index bd6458a5a75..4f15924f9e1 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -120,11 +120,11 @@ select extract(year_month from '2026-01-01
11:45:14.123456') as year_month,
extract(minute_microsecond from '2026-01-01 11:45:14.123456') as
minute_microsecond,
extract(second_microsecond from '2026-01-01 11:45:14.123456') as
second_microsecond;
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second|
minute_microsecond | second_microsecond |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| 2026-01 | 1 11 | 1 11:45 | 1 11:45:14 | 1 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second |
minute_microsecond | second_microsecond |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| 2026-01 | 01 11 | 01 11:45 | 01 11:45:14 | 01 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
-- Input unit does not exist, reports error
select extract(uint from '2024-01-07') as week;
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index 20e7dd0581c..ebba6af595f 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -96,11 +96,11 @@ SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00') AS result;
-- Datetime with scale, time component and decimal places are all truncated to 0
SELECT MONTH_FLOOR('2023-07-13 22:28:18.456789', 5) AS result;
-+---------------------+
-| result |
-+---------------------+
-| 2023-06-01 00:00:00 |
-+---------------------+
++----------------------------+
+| result |
++----------------------------+
+| 2023-05-01 00:00:00.000000 |
++----------------------------+
-- Input is of DATE type (default time 00:00:00)
SELECT MONTH_FLOOR('2023-07-13', 3) AS result;
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
index d39830da8b4..0cd9744b917 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
@@ -80,11 +80,11 @@ SELECT TIMEDIFF('2024-01-01 00:00:01', '2023-12-31
23:59:59') AS result;
-- When returned time is not an integer number of seconds, returns time with
scale
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2023-07-13 12:34:50.123') AS
result;
-+-----------+
-| result |
-+-----------+
-| 00:00:06 |
-+-----------+
++--------------+
+| result |
++--------------+
+| 00:00:06.666 |
++--------------+
-- Calculation result exceeds time size range, returns error
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2024-07-13 12:34:50.123') AS
result;
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index c7e9b59e30c..5f589aeb9f6 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -121,14 +121,14 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
```
> Even if there is only one match, it will be returned in array form
```sql
- select JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists');
+ SELECT json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name');
```
```
-
+---------------------------------------------------------------------------------+
- | JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists') |
-
+---------------------------------------------------------------------------------+
- | ["doris"]
|
-
+---------------------------------------------------------------------------------+
+ +-----------------------------------------------------------------+
+ | json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+ +-----------------------------------------------------------------+
+ | ["doris"] |
+ +-----------------------------------------------------------------+
```
> If all paths have no matches, return NULL
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index 73a6bcfeb1d..5298f2d32ba 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index 78b487e3d98..8a86c44c9d6 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -93,11 +93,11 @@ SELECT auto_partition_name('list', 'hello', 'world');
SELECT auto_partition_name('list', 'ṭṛì', 'ḍḍumai');
```
```text
-+------------------------------------------------+
-| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
-+------------------------------------------------+
-| pṭṛì9ḍḍumai12 |
-+------------------------------------------------+
++-------------------------------------------------------+
+| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
++-------------------------------------------------------+
+| p1e6d1e5bec31e0d1e0dumai6 |
++-------------------------------------------------------+
```
6. Invalid unit parameter
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index d1ab82607f4..98a11051913 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -107,7 +107,7 @@ SELECT TO_BASE64('ṭṛì'), TO_BASE64('ḍḍumai hello');
+-------------------+---------------------------+
| TO_BASE64('ṭṛì') | TO_BASE64('ḍḍumai hello') |
+-------------------+---------------------------+
-| 4bmt4bmb4bmA | 4bmN4bmNdW1haSBoZWxsbw== |
+| 4bmt4bmbw6w= | 4bmN4bmNdW1haSBoZWxsbw== |
+-------------------+---------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
index 53a06725476..9f5c80d0c51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
@@ -37,6 +37,6 @@ SELECT COSINE_DISTANCE([1, 2], [2, 3]),COSINE_DISTANCE([3,
6], [4, 7]);
+---------------------------------+---------------------------------+
| cosine_distance([1, 2], [2, 3]) | cosine_distance([3, 6], [4, 7]) |
+---------------------------------+---------------------------------+
-| 0.007722123286332261 | 0.0015396467945875125 |
+| 0.007722139 | 0.001539648 |
+---------------------------------+---------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
index 6a17a1b6f39..bf878782e46 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
@@ -37,6 +37,6 @@ SELECT L2_DISTANCE([4, 5], [6, 8]),L2_DISTANCE([3, 6], [4,
5]);
+-----------------------------+-----------------------------+
| l2_distance([4, 5], [6, 8]) | l2_distance([3, 6], [4, 5]) |
+-----------------------------+-----------------------------+
-| 3.605551275463989 | 1.4142135623730951 |
+| 3.605551 | 1.414214 |
+-----------------------------+-----------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
index 693c1eee5d5..1fb4a254550 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
@@ -124,13 +124,13 @@ SELECT array_concat(int_array1, int_array2) FROM
array_concat_test WHERE id = 5;
+--------------------------------------+
```
-类型兼容性示例：int_array1 和 string_array1 拼接，string 元素无法转换为 int，结果为 null。
+类型兼容性示例：int_array1 和 string_array1 拼接，int 元素会转换为 string，所有元素都会保留。
```sql
SELECT array_concat(int_array1, string_array1) FROM array_concat_test WHERE id
= 1;
+-----------------------------------------+
| array_concat(int_array1, string_array1) |
+-----------------------------------------+
-| [1, 2, 3, null, null] |
+| ["1", "2", "3", "a", "b"] |
+-----------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
index f2996a452f6..a557e991e5a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
@@ -95,7 +95,7 @@ SELECT array_cum_sum(['a', 1, 'b', 2, 'c', 3]);
+-----------------------------------------+
| array_cum_sum(['a', 1, 'b', 2, 'c', 3]) |
+-----------------------------------------+
-| [0, 1, 1, 3, 3, 6] |
+| [null, 1, null, 3, null, 6] |
+-----------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
index 2a8d3f815a1..07b310be4e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
@@ -122,11 +122,11 @@ SELECT array_popback([[1, 2], [3, 4], [5, 6]]);
移除 MAP 数组的最后一个元素：
```sql
SELECT array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
| array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Alice","age":20}, {"name":"Bob","age":30}]
|
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
+| [{"name":"Alice", "age":"20"}, {"name":"Bob", "age":"30"}]
|
++--------------------------------------------------------------------------------------------------+
```
移除 STRUCT 数组的最后一个元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
index 64d8ba27712..a5d6e856fc3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
@@ -126,11 +126,11 @@ SELECT array_popfront([[1, 2], [3, 4], [5, 6]]);
移除 MAP 数组的第一个元素：
```sql
SELECT array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
| array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Bob","age":30}, {"name":"Charlie","age":40}]
|
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
+| [{"name":"Bob", "age":"30"}, {"name":"Charlie", "age":"40"}]
|
++---------------------------------------------------------------------------------------------------+
```
移除 STRUCT 数组的第一个元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index ca53107a122..f8910fd66d8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ select bitmap_to_base64(to_bitmap(1));
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -96,6 +96,6 @@ select bitmap_to_base64(bitmap_from_string("1,9999999"));
+---------------------------------------------------------+
| bitmap_to_base64(bitmap_from_string("1,9999999")) |
+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
+| BQIBAAAAAAAAAH+WmAAAAAAA |
+---------------------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index 72ec083c22e..9f7258f21fe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -119,11 +119,11 @@ select extract(year_month from '2026-01-01
11:45:14.123456') as year_month,
extract(minute_microsecond from '2026-01-01 11:45:14.123456') as
minute_microsecond,
extract(second_microsecond from '2026-01-01 11:45:14.123456') as
second_microsecond;
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second|
minute_microsecond | second_microsecond |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| 2026-01 | 1 11 | 1 11:45 | 1 11:45:14 | 1 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second |
minute_microsecond | second_microsecond |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| 2026-01 | 01 11 | 01 11:45 | 01 11:45:14 | 01 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
-- 输入单位不存在，报错
select extract(uint from '2024-01-07') as week;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index 584b226698b..fe7e13e4b28 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -92,7 +92,7 @@ SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00') AS result;
+---------------------+
| result |
+---------------------+
-| 2023-07-13 22:25:00 |
+| 2023-06-01 00:00:00 |
+---------------------+
--- 带有 scale 的 datetime，会把小数位全部截断为 0
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
index 3103c1ba174..7c1ff0465b7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
@@ -79,11 +79,11 @@ SELECT TIMEDIFF('2024-01-01 00:00:01', '2023-12-31
23:59:59') AS result;
-- 返回时间不是整数秒时，返回时间带有 scale
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2023-07-13 12:34:50.123') AS
result;
-+-----------+
-| result |
-+-----------+
-| 00:00:06 |
-+-----------+
++--------------+
+| result |
++--------------+
+| 00:00:06.666 |
++--------------+
---计算结果超出 time 大小范围，返回错误
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2024-07-13 12:34:50.123') AS
result;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index d0296536e5b..2e7bb69a762 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -26,7 +26,7 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
## 使用说明
- 如果 `<json_object>` 是 NULL，或者 `<path>` 是 NULL，返回 NULL。
- 对于单个 `<path>` 参数的情况，如果 `<path>` 如果路径不存在，返回 NULL。
-- 对于多个 `<path>` 参数的情况，不存在的路径会被忽略，匹配到的元素组成 JSON 数组返回。如果一个匹配也没有则返回 NULL。
+- 对于多个 `<path>` 参数的情况，如果所有字段都不在 JSON 中，返回 NULL；否则跳过不存在的字段，将匹配到的元素组成 JSON 数组返回。
- 如果 `<path>` 不是一个合法的路径，报错。
- 如果 `<path>` 对应的值是字符串，返回的字符串会被双引号（`"`）包围，如果要得到没有双引号的结果，请对结果使用函数
[`JSON_UNQUOTE`](./json-unquote.md) 以去掉双引号。
- `<path>` 的语法如下
@@ -122,14 +122,14 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
```
> 即使只有一个匹配也会以数组形式返回
```sql
- select JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists');
+ SELECT json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name');
```
```
-
+---------------------------------------------------------------------------------+
- | JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists') |
-
+---------------------------------------------------------------------------------+
- | ["doris"]
|
-
+---------------------------------------------------------------------------------+
+ +-----------------------------------------------------------------+
+ | json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+ +-----------------------------------------------------------------+
+ | ["doris"] |
+ +-----------------------------------------------------------------+
```
```sql
> 如果所有路径都没有匹配则返回 NULL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index fb529f1fa8c..7666cc6f54f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index e9b95cf0d82..04792f2d774 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -93,11 +93,11 @@ SELECT auto_partition_name('list', 'hello', 'world');
SELECT auto_partition_name('list', 'ṭṛì', 'ḍḍumai');
```
```text
-+------------------------------------------------+
-| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
-+------------------------------------------------+
-| pṭṛì9ḍḍumai12 |
-+------------------------------------------------+
++-------------------------------------------------------+
+| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
++-------------------------------------------------------+
+| p1e6d1e5bec31e0d1e0dumai6 |
++-------------------------------------------------------+
```
6. 无效的 unit 参数
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/from-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/from-base64.md
index 349fb31bfb7..64549a71af0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/from-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/from-base64.md
@@ -115,11 +115,11 @@ SELECT FROM_BASE64('SGVsbG8gV29ybGQ='),
FROM_BASE64('VGhlIHF1aWNrIGJyb3duIGZveA=
7. UTF-8 多字节字符解码
```sql
-SELECT FROM_BASE64('4bmt4bmb4bmA'), FROM_BASE64('4bmN4bmNdW1haSBoZWxsbw==');
+SELECT FROM_BASE64('4bmt4bmbw6w='), FROM_BASE64('4bmN4bmNdW1haSBoZWxsbw==');
```
```text
+---------------------------+---------------------------------------+
-| FROM_BASE64('4bmt4bmb4bmA') | FROM_BASE64('4bmN4bmNdW1haSBoZWxsbw==') |
+| FROM_BASE64('4bmt4bmbw6w=') | FROM_BASE64('4bmN4bmNdW1haSBoZWxsbw==') |
+---------------------------+---------------------------------------+
| ṭṛì | ḍḍumai hello |
+---------------------------+---------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
index 956007c8efa..d5d0a4947a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
@@ -119,11 +119,11 @@ SELECT INSTR('[email protected]', '@'), INSTR('price:
$99.99', '$');
SELECT INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai'), INSTR('ṭṛì ḍḍumai hello', 'hello');
```
```text
-+------------------------------------+-----------------------------------+
-| INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai') | INSTR('ṭṛì ḍḍumai hello', 'hello') |
-+------------------------------------+-----------------------------------+
-| 5 | 13 |
-+------------------------------------+-----------------------------------+
++--------------------------------------------------+---------------------------------------------+
+| INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai') | INSTR('ṭṛì ḍḍumai hello',
'hello') |
++--------------------------------------------------+---------------------------------------------+
+| 5 |
12 |
++--------------------------------------------------+---------------------------------------------+
```
8. 数字字符串
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/length.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/length.md
index 7098d98ae49..732a9139ede 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/length.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/length.md
@@ -119,11 +119,11 @@ SELECT LENGTH('\t\n\r'), LENGTH(' ');
SELECT LENGTH('ṭṛì'), CHAR_LENGTH('ṭṛì');
```
```text
-+----------------+---------------------+
-| LENGTH('ṭṛì') | CHAR_LENGTH('ṭṛì') |
-+----------------+---------------------+
-| 9 | 3 |
-+----------------+---------------------+
++--------------------+-------------------------+
+| LENGTH('ṭṛì') | CHAR_LENGTH('ṭṛì') |
++--------------------+-------------------------+
+| 8 | 3 |
++--------------------+-------------------------+
```
8. Emoji 字符（每个emoji通常占4字节）
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/locate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/locate.md
index 195df739d1e..1d9a2a8d85c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/locate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/locate.md
@@ -112,7 +112,7 @@ SELECT LOCATE('o', 'foobar', 1), LOCATE('o', 'foobar', 2),
LOCATE('o', 'foobar',
+--------------------------+--------------------------+--------------------------+
| LOCATE('o', 'foobar', 1) | LOCATE('o', 'foobar', 2) | LOCATE('o', 'foobar',
4) |
+--------------------------+--------------------------+--------------------------+
-| 2 | 3 |
0 |
+| 2 | 2 |
0 |
+--------------------------+--------------------------+--------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lpad.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lpad.md
index 12fcccccd56..f6042962777 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lpad.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/lpad.md
@@ -110,7 +110,7 @@ SELECT LPAD('123', 10, 'abc'), LPAD('X', 7, 'HELLO');
+--------------------------+-------------------------+
| LPAD('123', 10, 'abc') | LPAD('X', 7, 'HELLO') |
+--------------------------+-------------------------+
-| abcabca123 | HELLOX |
+| abcabca123 | HELLOHX |
+--------------------------+-------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index f7d86c9c902..b24b5accffa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -107,7 +107,7 @@ SELECT TO_BASE64('ṭṛì'), TO_BASE64('ḍḍumai hello');
+-------------------+---------------------------+
| TO_BASE64('ṭṛì') | TO_BASE64('ḍḍumai hello') |
+-------------------+---------------------------+
-| 4bmt4bmb4bmA | 4bmN4bmNdW1haSBoZWxsbw== |
+| 4bmt4bmbw6w= | 4bmN4bmNdW1haSBoZWxsbw== |
+-------------------+---------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
index 5569bad9afe..7800ff3ece6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
@@ -109,7 +109,7 @@ select *, array_exists(c_array1) from array_test2 order by
id;
+------+-----------------+-------------------------+--------------------------+
| id | c_array1 | c_array2 | array_exists(`c_array1`) |
+------+-----------------+-------------------------+--------------------------+
-| 1 | [1, 2, 3, 0, 5] | [10, 20, -40, 80, -100] | [1, 1, 1, 0, 1] |
+| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [1, 1, 1, 1, 1] |
| 2 | [6, 7, 8] | [10, 12, 13] | [1, 1, 1] |
| 3 | [1] | [-100] | [1] |
| 4 | NULL | NULL | NULL |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index 848fb3fe9f7..23764a43b87 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -72,9 +72,9 @@ select array_split(x->(year(x)>2013),["2020-12-12",
"2013-12-12", "2015-12-12",
```
```text
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| array_split(['2020-12-12', '2013-12-12', '2015-12-12', NULL], array_map(x ->
(year(cast(x as DATEV2)) > 2013), ['2020-12-12', '2013-12-12', '2015-12-12',
NULL])) |
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| [["2020-12-12", "2013-12-12"], ["2015-12-12"], [null]]
|
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------+
+| array_split(x->(year(x)>2013),["2020-12-12", "2013-12-12", "2015-12-12",
null]) |
++---------------------------------------------------------------------------------+
+| [["2020-12-12", "2013-12-12"], ["2015-12-12", null]]
|
++---------------------------------------------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index ca53107a122..21021fbb734 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ select bitmap_to_base64(to_bitmap(1));
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -93,9 +93,9 @@ select bitmap_to_base64(bitmap_from_string("1,9999999"));
结果如下：
```text
-+---------------------------------------------------------+
-| bitmap_to_base64(bitmap_from_string("1,9999999")) |
-+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
-+---------------------------------------------------------+
++---------------------------------------------------+
+| bitmap_to_base64(bitmap_from_string("1,9999999")) |
++---------------------------------------------------+
+| BQIBAAAAAAAAAH+WmAAAAAAA |
++---------------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index d7ef025b6d3..1142a7f484c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -80,7 +80,7 @@ JSON_EXTRACT_STRING (<json_str>, <path>)
## 返回值
根据要提取的字段类型不同，返回目标 JSON 中 指定 JSON_PATH 的数据类型。特殊情况处理如下：
-* 如果 json_path 指定的字段在 JSON 中不存在，返回 NULL
+* 如果 json_path 指定的字段全部不在 JSON 中，返回 NULL；否则跳过不存在的字段
* 如果 json_path 指定的字段在 JSON 中的实际类型和 json_extract_t 指定的类型不一致，如果能无损转换成指定类型返回指定类型
t，如果不能则返回 NULL
@@ -124,7 +124,7 @@ SELECT json_extract('{"id": 123, "name": "doris"}',
'$.aaa', '$.name');
+-----------------------------------------------------------------+
| json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+-----------------------------------------------------------------+
-| [null,"doris"] |
+| ["doris"] |
+-----------------------------------------------------------------+
```
```sql
@@ -187,4 +187,3 @@ SELECT JSON_EXTRACT_STRING('{"id": 123, "name": "doris"}',
'$.name');
| doris
|
+------------------------------------------------------------------------------+
```
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index 4dbdba2bb67..e6d07168760 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
index 53a06725476..9f5c80d0c51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
@@ -37,6 +37,6 @@ SELECT COSINE_DISTANCE([1, 2], [2, 3]),COSINE_DISTANCE([3,
6], [4, 7]);
+---------------------------------+---------------------------------+
| cosine_distance([1, 2], [2, 3]) | cosine_distance([3, 6], [4, 7]) |
+---------------------------------+---------------------------------+
-| 0.007722123286332261 | 0.0015396467945875125 |
+| 0.007722139 | 0.001539648 |
+---------------------------------+---------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
index 6a17a1b6f39..bf878782e46 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
@@ -37,6 +37,6 @@ SELECT L2_DISTANCE([4, 5], [6, 8]),L2_DISTANCE([3, 6], [4,
5]);
+-----------------------------+-----------------------------+
| l2_distance([4, 5], [6, 8]) | l2_distance([3, 6], [4, 5]) |
+-----------------------------+-----------------------------+
-| 3.605551275463989 | 1.4142135623730951 |
+| 3.605551 | 1.414214 |
+-----------------------------+-----------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
index 693c1eee5d5..1fb4a254550 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
@@ -124,13 +124,13 @@ SELECT array_concat(int_array1, int_array2) FROM
array_concat_test WHERE id = 5;
+--------------------------------------+
```
-类型兼容性示例：int_array1 和 string_array1 拼接，string 元素无法转换为 int，结果为 null。
+类型兼容性示例：int_array1 和 string_array1 拼接，int 元素会转换为 string，所有元素都会保留。
```sql
SELECT array_concat(int_array1, string_array1) FROM array_concat_test WHERE id
= 1;
+-----------------------------------------+
| array_concat(int_array1, string_array1) |
+-----------------------------------------+
-| [1, 2, 3, null, null] |
+| ["1", "2", "3", "a", "b"] |
+-----------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
index f2996a452f6..a557e991e5a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
@@ -95,7 +95,7 @@ SELECT array_cum_sum(['a', 1, 'b', 2, 'c', 3]);
+-----------------------------------------+
| array_cum_sum(['a', 1, 'b', 2, 'c', 3]) |
+-----------------------------------------+
-| [0, 1, 1, 3, 3, 6] |
+| [null, 1, null, 3, null, 6] |
+-----------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
index 2a8d3f815a1..07b310be4e3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
@@ -122,11 +122,11 @@ SELECT array_popback([[1, 2], [3, 4], [5, 6]]);
移除 MAP 数组的最后一个元素：
```sql
SELECT array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
| array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Alice","age":20}, {"name":"Bob","age":30}]
|
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
+| [{"name":"Alice", "age":"20"}, {"name":"Bob", "age":"30"}]
|
++--------------------------------------------------------------------------------------------------+
```
移除 STRUCT 数组的最后一个元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
index 64d8ba27712..a5d6e856fc3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
@@ -126,11 +126,11 @@ SELECT array_popfront([[1, 2], [3, 4], [5, 6]]);
移除 MAP 数组的第一个元素：
```sql
SELECT array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
| array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Bob","age":30}, {"name":"Charlie","age":40}]
|
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
+| [{"name":"Bob", "age":"30"}, {"name":"Charlie", "age":"40"}]
|
++---------------------------------------------------------------------------------------------------+
```
移除 STRUCT 数组的第一个元素：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index ca53107a122..f8910fd66d8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ select bitmap_to_base64(to_bitmap(1));
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -96,6 +96,6 @@ select bitmap_to_base64(bitmap_from_string("1,9999999"));
+---------------------------------------------------------+
| bitmap_to_base64(bitmap_from_string("1,9999999")) |
+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
+| BQIBAAAAAAAAAH+WmAAAAAAA |
+---------------------------------------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index 72ec083c22e..9f7258f21fe 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -119,11 +119,11 @@ select extract(year_month from '2026-01-01
11:45:14.123456') as year_month,
extract(minute_microsecond from '2026-01-01 11:45:14.123456') as
minute_microsecond,
extract(second_microsecond from '2026-01-01 11:45:14.123456') as
second_microsecond;
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second|
minute_microsecond | second_microsecond |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| 2026-01 | 1 11 | 1 11:45 | 1 11:45:14 | 1 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second |
minute_microsecond | second_microsecond |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| 2026-01 | 01 11 | 01 11:45 | 01 11:45:14 | 01 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
-- 输入单位不存在，报错
select extract(uint from '2024-01-07') as week;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index 584b226698b..fe7e13e4b28 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -92,7 +92,7 @@ SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00') AS result;
+---------------------+
| result |
+---------------------+
-| 2023-07-13 22:25:00 |
+| 2023-06-01 00:00:00 |
+---------------------+
--- 带有 scale 的 datetime，会把小数位全部截断为 0
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
index 3103c1ba174..7c1ff0465b7 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
@@ -79,11 +79,11 @@ SELECT TIMEDIFF('2024-01-01 00:00:01', '2023-12-31
23:59:59') AS result;
-- 返回时间不是整数秒时，返回时间带有 scale
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2023-07-13 12:34:50.123') AS
result;
-+-----------+
-| result |
-+-----------+
-| 00:00:06 |
-+-----------+
++--------------+
+| result |
++--------------+
+| 00:00:06.666 |
++--------------+
---计算结果超出 time 大小范围，返回错误
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2024-07-13 12:34:50.123') AS
result;
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index d0296536e5b..2e7bb69a762 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -26,7 +26,7 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
## 使用说明
- 如果 `<json_object>` 是 NULL，或者 `<path>` 是 NULL，返回 NULL。
- 对于单个 `<path>` 参数的情况，如果 `<path>` 如果路径不存在，返回 NULL。
-- 对于多个 `<path>` 参数的情况，不存在的路径会被忽略，匹配到的元素组成 JSON 数组返回。如果一个匹配也没有则返回 NULL。
+- 对于多个 `<path>` 参数的情况，如果所有字段都不在 JSON 中，返回 NULL；否则跳过不存在的字段，将匹配到的元素组成 JSON 数组返回。
- 如果 `<path>` 不是一个合法的路径，报错。
- 如果 `<path>` 对应的值是字符串，返回的字符串会被双引号（`"`）包围，如果要得到没有双引号的结果，请对结果使用函数
[`JSON_UNQUOTE`](./json-unquote.md) 以去掉双引号。
- `<path>` 的语法如下
@@ -122,14 +122,14 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
```
> 即使只有一个匹配也会以数组形式返回
```sql
- select JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists');
+ SELECT json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name');
```
```
-
+---------------------------------------------------------------------------------+
- | JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists') |
-
+---------------------------------------------------------------------------------+
- | ["doris"]
|
-
+---------------------------------------------------------------------------------+
+ +-----------------------------------------------------------------+
+ | json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+ +-----------------------------------------------------------------+
+ | ["doris"] |
+ +-----------------------------------------------------------------+
```
```sql
> 如果所有路径都没有匹配则返回 NULL
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index fb529f1fa8c..7666cc6f54f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index e9b95cf0d82..04792f2d774 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -93,11 +93,11 @@ SELECT auto_partition_name('list', 'hello', 'world');
SELECT auto_partition_name('list', 'ṭṛì', 'ḍḍumai');
```
```text
-+------------------------------------------------+
-| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
-+------------------------------------------------+
-| pṭṛì9ḍḍumai12 |
-+------------------------------------------------+
++-------------------------------------------------------+
+| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
++-------------------------------------------------------+
+| p1e6d1e5bec31e0d1e0dumai6 |
++-------------------------------------------------------+
```
6. 无效的 unit 参数
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
index ec5398d833b..d5d0a4947a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/instr.md
@@ -119,11 +119,11 @@ SELECT INSTR('[email protected]', '@'), INSTR('price:
$99.99', '$');
SELECT INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai'), INSTR('ṭṛì ḍḍumai hello', 'hello');
```
```text
-+------------------------------------+-----------------------------------+
-| INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai') | INSTR('ṭṛì ḍḍumai hello', 'hello') |
-+------------------------------------+-----------------------------------+
-| 5 | 12 |
-+------------------------------------+-----------------------------------+
++--------------------------------------------------+---------------------------------------------+
+| INSTR('ṭṛì ḍḍumai hello', 'ḍḍumai') | INSTR('ṭṛì ḍḍumai hello',
'hello') |
++--------------------------------------------------+---------------------------------------------+
+| 5 |
12 |
++--------------------------------------------------+---------------------------------------------+
```
8. 数字字符串
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
index d7ad81f4118..732a9139ede 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/length.md
@@ -119,11 +119,11 @@ SELECT LENGTH('\t\n\r'), LENGTH(' ');
SELECT LENGTH('ṭṛì'), CHAR_LENGTH('ṭṛì');
```
```text
-+----------------+---------------------+
-| LENGTH('ṭṛì') | CHAR_LENGTH('ṭṛì') |
-+----------------+---------------------+
-| 8 | 3 |
-+----------------+---------------------+
++--------------------+-------------------------+
+| LENGTH('ṭṛì') | CHAR_LENGTH('ṭṛì') |
++--------------------+-------------------------+
+| 8 | 3 |
++--------------------+-------------------------+
```
8. Emoji 字符（每个emoji通常占4字节）
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index f7d86c9c902..b24b5accffa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -107,7 +107,7 @@ SELECT TO_BASE64('ṭṛì'), TO_BASE64('ḍḍumai hello');
+-------------------+---------------------------+
| TO_BASE64('ṭṛì') | TO_BASE64('ḍḍumai hello') |
+-------------------+---------------------------+
-| 4bmt4bmb4bmA | 4bmN4bmNdW1haSBoZWxsbw== |
+| 4bmt4bmbw6w= | 4bmN4bmNdW1haSBoZWxsbw== |
+-------------------+---------------------------+
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
index 3a20db238dd..e12362fc233 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-exists.md
@@ -107,7 +107,7 @@ select *, array_exists(c_array1) from array_test2 order by
id;
+------+-----------------+-------------------------+--------------------------+
| id | c_array1 | c_array2 | array_exists(`c_array1`) |
+------+-----------------+-------------------------+--------------------------+
-| 1 | [1, 2, 3, 0, 5] | [10, 20, -40, 80, -100] | [1, 1, 1, 0, 1] |
+| 1 | [1, 2, 3, 4, 5] | [10, 20, -40, 80, -100] | [1, 1, 1, 1, 1] |
| 2 | [6, 7, 8] | [10, 12, 13] | [1, 1, 1] |
| 3 | [1] | [-100] | [1] |
| 4 | NULL | NULL | NULL |
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
index f6df79b2e9c..2992e817516 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/array-functions/array-split.md
@@ -72,9 +72,9 @@ select array_split(x->(year(x)>2013),["2020-12-12",
"2013-12-12", "2015-12-12",
```
```text
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| array_split(['2020-12-12', '2013-12-12', '2015-12-12', NULL], array_map(x ->
(year(cast(x as DATEV2)) > 2013), ['2020-12-12', '2013-12-12', '2015-12-12',
NULL])) |
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| [["2020-12-12", "2013-12-12"], ["2015-12-12"], [null]]
|
-+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------+
+| array_split(x->(year(x)>2013),["2020-12-12", "2013-12-12", "2015-12-12",
null]) |
++---------------------------------------------------------------------------------+
+| [["2020-12-12", "2013-12-12"], ["2015-12-12", null]]
|
++---------------------------------------------------------------------------------+
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index e6a5ff2257d..16a83a09e42 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ The result will be:
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -93,9 +93,9 @@ select bitmap_to_base64(bitmap_from_string("1,9999999"));
The result will be:
```text
-+---------------------------------------------------------+
-| bitmap_to_base64(bitmap_from_string("1,9999999")) |
-+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
-+---------------------------------------------------------+
++---------------------------------------------------+
+| bitmap_to_base64(bitmap_from_string("1,9999999")) |
++---------------------------------------------------+
+| BQIBAAAAAAAAAH+WmAAAAAAA |
++---------------------------------------------------+
```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index eaa6f4afe76..bc3ad1408a2 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -80,7 +80,7 @@ json path syntax:
## Return Values
According to the type of the field to be extracted, return the data type of
the specified JSON_PATH in the target JSON. Special case handling is as follows:
-* If the field specified by json_path does not exist in the JSON, return NULL.
+* If none of the fields specified by json_path exist in the JSON, return NULL.
Otherwise, skip the non-existent fields.
* If the actual type of the field specified by json_path in the JSON is
inconsistent with the type specified by json_extract_t.
* if it can be losslessly converted to the specified type, return the
specified type t; if not, return NULL.
@@ -125,7 +125,7 @@ SELECT json_extract('{"id": 123, "name": "doris"}',
'$.aaa', '$.name');
+-----------------------------------------------------------------+
| json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+-----------------------------------------------------------------+
-| [null,"doris"] |
+| ["doris"] |
+-----------------------------------------------------------------+
```
```sql
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index b20937aca6c..fcf5ad4e411 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
@@ -53,4 +53,4 @@ select fmod(10.1, 0);
+---------------+
| NULL |
+---------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
index e6cbe12c507..316bfd72c6f 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/cosine-distance.md
@@ -37,6 +37,6 @@ SELECT COSINE_DISTANCE([1, 2], [2, 3]),COSINE_DISTANCE([3,
6], [4, 7]);
+---------------------------------+---------------------------------+
| cosine_distance([1, 2], [2, 3]) | cosine_distance([3, 6], [4, 7]) |
+---------------------------------+---------------------------------+
-| 0.007722123286332261 | 0.0015396467945875125 |
+| 0.007722139 | 0.001539648 |
+---------------------------------+---------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
index 82f823bf1bd..917f8ef883e 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/ai-functions/distance-functions/l2-distance.md
@@ -37,6 +37,6 @@ SELECT L2_DISTANCE([4, 5], [6, 8]),L2_DISTANCE([3, 6], [4,
5]);
+-----------------------------+-----------------------------+
| l2_distance([4, 5], [6, 8]) | l2_distance([3, 6], [4, 5]) |
+-----------------------------+-----------------------------+
-| 3.605551275463989 | 1.4142135623730951 |
+| 3.605551 | 1.414214 |
+-----------------------------+-----------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
index d2703bb107b..a67c7e0772c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-concat.md
@@ -125,13 +125,13 @@ SELECT array_concat(int_array1, int_array2) FROM
array_concat_test WHERE id = 5;
+--------------------------------------+
```
-Type compatibility example: concatenating int_array1 and string_array1, string
elements cannot be converted to int, resulting in null.
+Type compatibility example: concatenating int_array1 and string_array1
converts integer elements to strings and retains all elements.
```sql
SELECT array_concat(int_array1, string_array1) FROM array_concat_test WHERE id
= 1;
+-----------------------------------------+
| array_concat(int_array1, string_array1) |
+-----------------------------------------+
-| [1, 2, 3, null, null] |
+| ["1", "2", "3", "a", "b"] |
+-----------------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
index cbdc198a864..0688655c9a9 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-cum-sum.md
@@ -100,7 +100,7 @@ SELECT array_cum_sum(['a', 1, 'b', 2, 'c', 3]);
+-----------------------------------------+
| array_cum_sum(['a', 1, 'b', 2, 'c', 3]) |
+-----------------------------------------+
-| [0, 1, 1, 3, 3, 6] |
+| [null, 1, null, 3, null, 6] |
+-----------------------------------------+
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
index 08f34ec8d26..6b8c071af56 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popback.md
@@ -122,11 +122,11 @@ SELECT array_popback([[1, 2], [3, 4], [5, 6]]);
Remove the last element from a MAP array:
```sql
SELECT array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
| array_popback([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Alice","age":20}, {"name":"Bob","age":30}]
|
-+------------------------------------------------------------------------------------------+
++--------------------------------------------------------------------------------------------------+
+| [{"name":"Alice", "age":"20"}, {"name":"Bob", "age":"30"}]
|
++--------------------------------------------------------------------------------------------------+
```
Remove the last element from a STRUCT array:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
index 15189721183..9a3f05eb5d1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/array-functions/array-popfront.md
@@ -122,11 +122,11 @@ SELECT array_popfront([[1, 2], [3, 4], [5, 6]]);
Remove the first element from a MAP array:
```sql
SELECT array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]);
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
| array_popfront([{'name':'Alice','age':20}, {'name':'Bob','age':30},
{'name':'Charlie','age':40}]) |
-+------------------------------------------------------------------------------------------+
-| [{"name":"Bob","age":30}, {"name":"Charlie","age":40}]
|
-+------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------+
+| [{"name":"Bob", "age":"30"}, {"name":"Charlie", "age":"40"}]
|
++---------------------------------------------------------------------------------------------------+
```
Remove the first element from a STRUCT array:
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
index e6a5ff2257d..cd5cb79f2ec 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/bitmap-functions/bitmap-to-base64.md
@@ -80,7 +80,7 @@ The result will be:
+--------------------------------+
| bitmap_to_base64(to_bitmap(1)) |
+--------------------------------+
-| AQEAAAA= |
+| BQEBAAAAAAAAAA== |
+--------------------------------+
```
@@ -96,6 +96,6 @@ The result will be:
+---------------------------------------------------------+
| bitmap_to_base64(bitmap_from_string("1,9999999")) |
+---------------------------------------------------------+
-| AjowAAACAAAAAAAAAJgAAAAYAAAAGgAAAAEAf5Y= |
+| BQIBAAAAAAAAAH+WmAAAAAAA |
+---------------------------------------------------------+
```
\ No newline at end of file
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
index bd6458a5a75..4f15924f9e1 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/extract.md
@@ -120,11 +120,11 @@ select extract(year_month from '2026-01-01
11:45:14.123456') as year_month,
extract(minute_microsecond from '2026-01-01 11:45:14.123456') as
minute_microsecond,
extract(second_microsecond from '2026-01-01 11:45:14.123456') as
second_microsecond;
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second|
minute_microsecond | second_microsecond |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
-| 2026-01 | 1 11 | 1 11:45 | 1 11:45:14 | 1 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
-+------------+----------+------------+-------------+-----------------------+-------------+-------------+-----------------------+--------------+----------------------+-------------------+
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| year_month | day_hour | day_minute | day_second | day_microsecond |
hour_minute | hour_second | hour_microsecond | minute_second |
minute_microsecond | second_microsecond |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
+| 2026-01 | 01 11 | 01 11:45 | 01 11:45:14 | 01 11:45:14.123456 |
11:45 | 11:45:14 | 11:45:14.123456 | 45:14 | 45:14.123456
| 14.123456 |
++------------+----------+------------+-------------+--------------------+-------------+-------------+------------------+---------------+--------------------+--------------------+
-- Input unit does not exist, reports error
select extract(uint from '2024-01-07') as week;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
index 20e7dd0581c..ebba6af595f 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/month-floor.md
@@ -96,11 +96,11 @@ SELECT MONTH_FLOOR('2023-07-13 22:28:18', 5, '2023-01-01
00:00:00') AS result;
-- Datetime with scale, time component and decimal places are all truncated to 0
SELECT MONTH_FLOOR('2023-07-13 22:28:18.456789', 5) AS result;
-+---------------------+
-| result |
-+---------------------+
-| 2023-06-01 00:00:00 |
-+---------------------+
++----------------------------+
+| result |
++----------------------------+
+| 2023-05-01 00:00:00.000000 |
++----------------------------+
-- Input is of DATE type (default time 00:00:00)
SELECT MONTH_FLOOR('2023-07-13', 3) AS result;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
index d39830da8b4..0cd9744b917 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/date-time-functions/timediff.md
@@ -80,11 +80,11 @@ SELECT TIMEDIFF('2024-01-01 00:00:01', '2023-12-31
23:59:59') AS result;
-- When returned time is not an integer number of seconds, returns time with
scale
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2023-07-13 12:34:50.123') AS
result;
-+-----------+
-| result |
-+-----------+
-| 00:00:06 |
-+-----------+
++--------------+
+| result |
++--------------+
+| 00:00:06.666 |
++--------------+
-- Calculation result exceeds time size range, returns error
SELECT TIMEDIFF('2023-07-13 12:34:56.789', '2024-07-13 12:34:50.123') AS
result;
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index 3f249ddbda6..9cbaad74010 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -121,14 +121,14 @@ JSON_EXTRACT (<json_object>, <path>[, <path2>, ...])
```
> Even if there is only one match, it will be returned in array form
```sql
- select JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists');
+ SELECT json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name');
```
```
-
+---------------------------------------------------------------------------------+
- | JSON_EXTRACT('{"id": 123, "name": "doris"}', '$.name', '$.id2',
'$.not_exists') |
-
+---------------------------------------------------------------------------------+
- | ["doris"]
|
-
+---------------------------------------------------------------------------------+
+ +-----------------------------------------------------------------+
+ | json_extract('{"id": 123, "name": "doris"}', '$.aaa', '$.name') |
+ +-----------------------------------------------------------------+
+ | ["doris"] |
+ +-----------------------------------------------------------------+
```
> If all paths have no matches, return NULL
```sql
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
index 73a6bcfeb1d..5298f2d32ba 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/fmod.md
@@ -36,11 +36,11 @@ select fmod(10.1, 3.2);
```
```text
-+-----------------+
-| fmod(10.1, 3.2) |
-+-----------------+
-| 0.50000024 |
-+-----------------+
++--------------------+
+| fmod(10.1, 3.2) |
++--------------------+
+| 0.4999999999999991 |
++--------------------+
```
```sql
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
index 78b487e3d98..8a86c44c9d6 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/auto-partition-name.md
@@ -93,11 +93,11 @@ SELECT auto_partition_name('list', 'hello', 'world');
SELECT auto_partition_name('list', 'ṭṛì', 'ḍḍumai');
```
```text
-+------------------------------------------------+
-| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
-+------------------------------------------------+
-| pṭṛì9ḍḍumai12 |
-+------------------------------------------------+
++-------------------------------------------------------+
+| auto_partition_name('list', 'ṭṛì', 'ḍḍumai') |
++-------------------------------------------------------+
+| p1e6d1e5bec31e0d1e0dumai6 |
++-------------------------------------------------------+
```
6. Invalid unit parameter
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
index d1ab82607f4..98a11051913 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/to-base64.md
@@ -107,7 +107,7 @@ SELECT TO_BASE64('ṭṛì'), TO_BASE64('ḍḍumai hello');
+-------------------+---------------------------+
| TO_BASE64('ṭṛì') | TO_BASE64('ḍḍumai hello') |
+-------------------+---------------------------+
-| 4bmt4bmb4bmA | 4bmN4bmNdW1haSBoZWxsbw== |
+| 4bmt4bmbw6w= | 4bmN4bmNdW1haSBoZWxsbw== |
+-------------------+---------------------------+
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
