This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new f50f817b5fc [fix](function) remove some function docs from 2.1 (#2278)
f50f817b5fc is described below
commit f50f817b5fc17051b3a7ceec61212a00da847332
Author: Mingyu Chen (Rayner) <morning...@163.com>
AuthorDate: Wed Apr 9 15:59:25 2025 -0700
[fix](function) remove some function docs from 2.1 (#2278)
Related to #2251 #2260 #2235
This functions will not be released in 2.1, remove them
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../date-time-functions/months-between.md | 5 +
.../date-time-functions/next-day.md | 7 +-
.../json-functions/json-extract.md | 4 +
.../scalar-functions/map-functions/str-to-map.md | 4 +
.../numeric-functions/format-round.md | 6 +-
.../scalar-functions/string-functions/printf.md | 4 +
.../scalar-functions/string-functions/unhex.md | 4 +
.../string-functions/xpath-string.md | 4 +
.../date-time-functions/months-between.md | 5 +
.../date-time-functions/next-day.md | 7 +-
.../json-functions/json-extract.md | 6 +-
.../scalar-functions/map-functions/str-to-map.md | 6 +-
.../numeric-functions/format-round.md | 4 +
.../scalar-functions/string-functions/printf.md | 6 +-
.../scalar-functions/string-functions/unhex.md | 6 +-
.../string-functions/xpath-string.md | 4 +
.../date-time-functions/months-between.md | 75 ------------
.../date-time-functions/next-day.md | 72 ------------
.../json-functions/json-extract.md | 9 --
.../scalar-functions/map-functions/str-to-map.md | 62 ----------
.../numeric-functions/format-round.md | 130 ---------------------
.../scalar-functions/string-functions/printf.md | 85 --------------
.../scalar-functions/string-functions/unhex.md | 23 +---
.../string-functions/xpath-string.md | 111 ------------------
.../date-time-functions/months-between.md | 5 +-
.../date-time-functions/next-day.md | 7 +-
.../scalar-functions/map-functions/str-to-map.md | 7 +-
.../scalar-functions/string-functions/printf.md | 7 +-
.../string-functions/xpath-string.md | 5 +-
.../date-time-functions/months-between.md | 75 ------------
.../date-time-functions/next-day.md | 72 ------------
.../json-functions/json-extract.md | 11 +-
.../scalar-functions/map-functions/str-to-map.md | 62 ----------
.../numeric-functions/format-round.md | 127 --------------------
.../scalar-functions/string-functions/printf.md | 85 --------------
.../scalar-functions/string-functions/unhex.md | 21 +---
.../string-functions/xpath-string.md | 111 ------------------
.../date-time-functions/months-between.md | 5 +-
.../date-time-functions/next-day.md | 7 +-
.../json-functions/json-extract.md | 4 +-
.../scalar-functions/map-functions/str-to-map.md | 5 +-
.../numeric-functions/format-round.md | 4 +-
.../scalar-functions/string-functions/printf.md | 7 +-
.../scalar-functions/string-functions/unhex.md | 2 +-
.../string-functions/xpath-string.md | 5 +-
versioned_sidebars/version-2.1-sidebars.json | 14 +--
46 files changed, 135 insertions(+), 1162 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
index b76b455c2a6..bf498e4feb4 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
@@ -25,8 +25,13 @@ under the License.
-->
## Description
+
The `MONTHS_BETWEEN` function calculates the floating-point number of months
between two dates. It receives two date arguments and a optional boolean
argument.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
**Note:**
When both `<enddate>` and `<startdate>` are the last day of their respective
months, the function applies special handling.It returns the full month
difference without considering the fractional part based on days. This ensures
consistency when comparing the end of one month to the end of another.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
index c88f7787a76..b839ff62fae 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
@@ -25,8 +25,13 @@ under the License.
-->
## Description
+
The NEXT_DAY function is used to return the first date that is later than the
given date and matches the specified day of the week.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
@@ -67,4 +72,4 @@ select next_day("2020-01-31 02:02:02",
"MONDAY"),next_day("2020-01-31", "MONDAY"
+--------------------------------------------+-----------------------------------+
| 2020-02-03 | 2020-02-03
|
+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
+```
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 0bcd682788b..5412864564e 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
@@ -38,6 +38,10 @@ JSON_EXTRACT is a series of functions that extract the field
specified by json_p
* JSON_EXTRACT_DOUBLE returns the DOUBLE type.
* JSON_EXTRACT_STRING returns the STRING type.
+:::tip
+The `JSON_EXTRACT_NO_QUOTES` function is supported since version 3.0.6.
+:::
+
## Alias
* JSONB_EXTRACT is the same as JSON_EXTRACT.
* JSON_EXTRACT_NO_QUOTES is the same as JSON_EXTRACT_NO_QUOTES.
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/docs/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
index ed32d0296a6..1ddca78b609 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
@@ -28,6 +28,10 @@ under the License.
Constructs a `Map<String, String>` from a string.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
index aa1cd0e3c6a..baf4d36bfa8 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
@@ -28,6 +28,10 @@ under the License.
Formats a number in a format similar to "#,###,###.##", rounds to the
specified decimal places, and returns the result as a string.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
@@ -120,4 +124,4 @@ mysql> select format_round(123456.123456, 6);
+--------------------------------+
| 123,456.123456 |
+--------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
index 46abe8bd99e..fe2650523f0 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
@@ -28,6 +28,10 @@ under the License.
Returns a formatted string using the specified
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
string and arguments.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
index 4a862333f72..c6350058892 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
@@ -29,6 +29,10 @@ under the License.
The `unhex` function is used to convert a hexadecimal string back into the
original string. It converts every two hexadecimal characters into one byte.
When an invalid value is passed as a parameter, it will return empty string.
The `unhex_null` function has the same effect as the `unhex` function.
However, when an invalid value is passed as a parameter, it will return NULL.
+:::tip
+`unhex_null` function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
index 97808da0b2a..6cbd37d353e 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
@@ -28,6 +28,10 @@ under the License.
The XPATH_STRING function is used to parse the XML string and return the first
XML node that matches the [XPath](https://www.w3.org/TR/xpath-10/) expression.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
index 38f0798e7a7..b5595afd7c0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
@@ -25,8 +25,13 @@ under the License.
-->
## 描述
+
`MONTHS_BETWEEN` 函数计算两个日期之间的月份数（浮点数）。它接收两个日期参数和一个可选的布尔参数。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
**注意：**
当 `<enddate>` 和 `<startdate>`
都是各自月份的最后一天时，函数会进行特殊处理。它会返回完整的月份差值，而不考虑基于天数的分数部分。这确保了在比较一个月末与另一个月末时的一致性。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
index 5c633a406a6..0fb8bb5b45f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
@@ -25,8 +25,13 @@ under the License.
-->
## 描述
+
NEXT_DAY 函数用于返回给定日期之后第一个匹配指定星期几的日期。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -67,4 +72,4 @@ select next_day("2020-01-31 02:02:02",
"MONDAY"),next_day("2020-01-31", "MONDAY"
+--------------------------------------------+-----------------------------------+
| 2020-02-03 | 2020-02-03
|
+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
+```
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 ce0b1704976..25aae2263a1 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
@@ -36,6 +36,10 @@ JSON_EXTRACT 是一系列函数，从 JSON 类型的数据中提取 json_path
* JSON_EXTRACT_DOUBLE 返回 DOUBLE 类型
* JSON_EXTRACT_STRING 返回 STRING 类型
+:::tip
+JSON_EXTRACT_NO_QUOTES 函数自 3.0.6 版本开始支持.
+:::
+
## 别名
* JSONB_EXTRACT 同 `JSON_EXTRACT`
* JSON_EXTRACT_NO_QUOTES 同 `JSON_EXTRACT_NO_QUOTES`
@@ -198,4 +202,4 @@ SELECT JSON_EXTRACT_STRING('{"id": 123, "name": "doris"}',
'$.name');
+------------------------------------------------------------------------------+
| doris
|
+------------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
index d92e60ab3ee..cd7bcea9f65 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
@@ -28,6 +28,10 @@ under the License.
将字符串转换为 `Map<String, String>` 类型。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -58,4 +62,4 @@ select str_to_map('a=1&b=2&c=3', '&', '=') as map1,
str_to_map('x:10|y:20|z:30',
+-----------------------------+--------------------------------+
| {"a":"1", "b":"2", "c":"3"} | {"x":"10", "y":"20", "z":"30"} |
+-----------------------------+--------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
index cb3c0452e7d..1c4e54aef02 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
@@ -28,6 +28,10 @@ under the License.
将数字格式化为类似于“#,###,###.##”的格式，四舍五入到指定位小数，并将结果作为字符串返回。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
index e99f800622f..406be46dc1a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
@@ -28,6 +28,10 @@ under the License.
使用指定的
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
格式字符串和参数返回格式化后的字符串。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -81,4 +85,4 @@ select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255,
'test', 3.14159, 25
+-----------------------------------------------------------------------------+
| Int: 255, Str: test, Float: 3.14, Hex: ff |
+-----------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
index 2b8c74dc79b..2c3cfccc240 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
@@ -29,6 +29,10 @@ under the License.
`unhex` 函数用于将十六进制字符串转换为原始字符串。将每两个十六进制字符转换为一个字节。当传入的参数是无效值时，将返回空字符串。
`unhex_null` 函数与`unhex`函数作用一致。但是当传入的参数是无效值时，将返回`NULL`。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -95,4 +99,4 @@ select unhex('4142');
+---------------+
| AB |
+---------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
index 678d082c26d..1b91d830257 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
@@ -28,6 +28,10 @@ under the License.
XPATH_STRING 函数用于解析 XML 字符串并返回第一个匹配 [XPath](https://www.w3.org/TR/xpath-10/)
表达式的 XML 节点。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
deleted file mode 100644
index 52e0236a21a..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++ /dev/null
@@ -1,75 +0,0 @@
- ---
-{
- "title": "MONTHS_BETWEEN",
- "language": "cn"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-> 从版本 2.1.10 开始支持
-
-`MONTHS_BETWEEN` 函数计算两个日期之间的月份数（浮点数）。它接收两个日期参数和一个可选的布尔参数。
-
-**注意：**
-当 `<enddate>` 和 `<startdate>`
都是各自月份的最后一天时，函数会进行特殊处理。它会返回完整的月份差值，而不考虑基于天数的分数部分。这确保了在比较一个月末与另一个月末时的一致性。
-
-例如：
-- `months_between('2024-01-31', '2024-02-29')` 将返回
`-1.0`，因为两个日期都是各自月份的最后一天（1月31日和2月29日），所以结果被视为完整的月份差值，不进行分数调整。
-- `months_between('2024-01-29', '2024-02-29')` 也将返回 `-1.0`，因为月份中的日期相同。
-- `months_between('2024-01-30', '2024-02-29')` 将返回
`-0.96774194`，因为月份中的日期不同且不是月末。
-
-## 语法
-
-```sql
-MONTHS_BETWEEN(<enddate>, <startdate> [, <round_type>])
-```
-
-## 参数
-
-| 参数 | 说明 |
-|-------------------|------------------------------------------------------------|
-| `<enddate>` | 结束日期，表示差值计算中的较晚日期。支持 `DATE`（如 `YYYY-MM-DD`）或 `DATETIME`（如
`YYYY-MM-DD HH:MM:SS`）类型。 |
-| `<startdate>` | 开始日期，表示差值计算中的较早日期。支持 `DATE`（如 `YYYY-MM-DD`）或 `DATETIME`（如
`YYYY-MM-DD HH:MM:SS`）类型。 |
-| `<round_type>` | 是否将结果四舍五入到第八位小数。支持 `true` 或 `false`。默认为 `true`。 |
-
-## 返回值
-
-返回 `<enddate>` 减去 `<startdate>` 得到的月份数（浮点数）
-
-结果 = (`<enddate>.year` - `<startdate>.year`) * 12 + `<enddate>.month` -
`<startdate>.month` + (`<enddate>.day` - `<startdate>.day`) / 31.0
-
-- 当 `<enddate>` 或 `<startdate>` 为 NULL，或两者都为 NULL 时，返回 NULL
-- 当 `<round_type>` 为 `true` 时，结果四舍五入到第八位小数。
-
-## 示例
-
-```sql
-select months_between('2020-12-26','2020-10-25'),months_between('2020-10-25
10:00:00','2020-12-26 11:00:00',false);
-```
-
-```text
-+-------------------------------------------+-------------------------------------------------------------------+
-| months_between('2020-12-26','2020-10-25') | months_between('2020-10-25
10:00:00','2020-12-26 11:00:00',false) |
-+-------------------------------------------+-------------------------------------------------------------------+
-| 2.03225806 |
-2.032258064516129 |
-+-------------------------------------------+-------------------------------------------------------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
deleted file mode 100644
index 2120d64b980..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++ /dev/null
@@ -1,72 +0,0 @@
----
-{
- "title": "NEXT_DAY",
- "language": "cn"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-> 从版本 2.1.10 开始支持
-
-NEXT_DAY 函数用于返回给定日期之后第一个匹配指定星期几的日期。
-
-## 语法
-
-```sql
-NEXT_DAY(<datetime/date>, <day_of_week>)
-```
-
-## 参数
-
-| 参数 | 描述
|
-|-------------------|--------------------------------------------------------------|
-| `<datetime/date>` | 用于查找下一个星期几的日期。 |
-| `<day_of_week>` | 用于标识星期几的字符串表达式。 |
-
-`<day_of_week>` 必须是以下值之一（不区分大小写）：
-- 'SU', 'SUN', 'SUNDAY'
-- 'MO', 'MON', 'MONDAY'
-- 'TU', 'TUE', 'TUESDAY'
-- 'WE', 'WED', 'WEDNESDAY'
-- 'TH', 'THU', 'THURSDAY'
-- 'FR', 'FRI', 'FRIDAY'
-- 'SA', 'SAT', 'SATURDAY'
-
-## 返回值
-无论输入是 DATETIME 还是 DATE 类型，都返回 DATE 类型的值。
-
-特殊情况：
-- 如果 `<datetime/date>` 输入为 NULL，函数返回 NULL。
-- 如果输入是 NEXT_DAY("9999-12-31 12:00:00", `<day_of_week>`)，函数将返回与输入相同的值。
-
-## 示例
-
-``` sql
-select next_day("2020-01-31 02:02:02", "MONDAY"),next_day("2020-01-31",
"MONDAY");
-```
-```text
-+--------------------------------------------+-----------------------------------+
-| next_day("2020-01-31 02:02:02", "MONDAY") | next_day("2020-01-31",
"MONDAY") |
-+--------------------------------------------+-----------------------------------+
-| 2020-02-03 | 2020-02-03
|
-+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index 274a1ee2544..db75c8b86dc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -27,7 +27,6 @@ under the License.
## 描述
JSON_EXTRACT 是一系列函数，从 JSON 类型的数据中提取 json_path 指定的字段，根据要提取的字段类型不同提供不同的系列函数。
* JSON_EXTRACT 对 VARCHAR 类型的 json string 返回 VARCHAR 类型
-* JSON_EXTRACT_NO_QUOTES 对 VARCHAR 类型的 json string 返回 VARCHAR 类型, 如果 json 字段值为
string，则将去掉双引号。
* JSON_EXTRACT_ISNULL 返回是否为 json null 的 BOOLEAN 类型
* JSON_EXTRACT_BOOL 返回 BOOLEAN 类型
* JSON_EXTRACT_INT 返回 INT 类型
@@ -36,13 +35,8 @@ JSON_EXTRACT 是一系列函数，从 JSON 类型的数据中提取 json_path
* JSON_EXTRACT_DOUBLE 返回 DOUBLE 类型
* JSON_EXTRACT_STRING 返回 STRING 类型
-:::tip
-JSON_EXTRACT_NO_QUOTES 函数自 2.1.10 版本开始支持.
-:::
-
## 别名
* JSONB_EXTRACT 同 `JSON_EXTRACT`
-* JSON_EXTRACT_NO_QUOTES 同 `JSON_EXTRACT_NO_QUOTES`
* JSONB_EXTRACT_ISNULL 同 `JSON_EXTRACT_ISNULL`
* JSONB_EXTRACT_BOOL 同 `JSON_EXTRACT_BOOL`
* JSONB_EXTRACT_INT 同 `JSON_EXTRACT_INT`
@@ -56,9 +50,6 @@ JSON_EXTRACT_NO_QUOTES 函数自 2.1.10 版本开始支持.
JSON_EXTRACT (<json_str>, <path>[, path] ...)
```
```sql
-JSON_EXTRACT_NO_QUOTES (<json_str>, <path>[, path] ...)
-```
-```sql
JSON_EXTRACT_ISNULL (<json_str>, <path>)
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
deleted file mode 100644
index 98ce252ae05..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++ /dev/null
@@ -1,62 +0,0 @@
----
-{
- "title": "STR_TO_MAP",
- "language": "cn"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-> 从版本 2.1.10 开始支持
-
-将字符串转换为 `Map<String, String>` 类型。
-
-## 语法
-
-```sql
-STR_TO_MAP(<str> [, <pair_delimiter> [, <key_value_delimiter>]])
-```
-
-## 参数
-
-| 参数 | 说明 |
-| -- | -- |
-| `<str>` | 要转换为 map 的字符串 |
-| `<pair_delimiter>` | 字符串中键值对的分割符，默认为 `,` |
-| `<key_value_delimiter>` | 字符串中键和值的分割符，默认为 `:` |
-
-## 返回值
-
-返回从字符串构造的 `Map<String, String>`。
-
-## 示例
-
-```sql
-select str_to_map('a=1&b=2&c=3', '&', '=') as map1,
str_to_map('x:10|y:20|z:30', '|', ':') as map2;
-```
-
-```text
-+-----------------------------+--------------------------------+
-| map1 | map2 |
-+-----------------------------+--------------------------------+
-| {"a":"1", "b":"2", "c":"3"} | {"x":"10", "y":"20", "z":"30"} |
-+-----------------------------+--------------------------------+
-```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
deleted file mode 100644
index d47e81fca00..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
+++ /dev/null
@@ -1,130 +0,0 @@
----
-{
- "title": "FORMAT_ROUND",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-
-将数字格式化为类似于“#,###,###.##”的格式，四舍五入到指定位小数，并将结果作为字符串返回。
-
-:::tip
-该函数自 2.1.10 版本开始支持.
-:::
-
-## 语法
-
-```sql
-FORMAT_ROUND(<number>, <D>)
-```
-
-## 参数
-
-| 参数 | 说明 |
-| -- | -- |
-| `<number>` | 需要被格式化的数字 |
-| `<D>` | 小数位数 |
-
-## 返回值
-
-返回格式化后的字符串。特殊情况：
-
-- 当参数为 NULL 时，返回 NULL
-- 如果 D 为 0，结果将没有小数点或小数部分。
-
-## 举例
-
-```sql
-mysql> select format_round(17014116, 2);
-+---------------------------+
-| format_round(17014116, 2) |
-+---------------------------+
-| 17,014,116.00 |
-+---------------------------+
-```
-
-```sql
-mysql> select format_round(1123.456, 2);
-+---------------------------+
-| format_round(1123.456, 2) |
-+---------------------------+
-| 1,123.46 |
-+---------------------------+
-```
-
-```sql
-mysql> select format_round(1123.4, 2);
-+-------------------------+
-| format_round(1123.4, 2) |
-+-------------------------+
-| 1,123.40 |
-+-------------------------+
-```
-
-
-
-```sql
-mysql> select format_round(123456, 0);
-+-------------------------+
-| format_round(123456, 0) |
-+-------------------------+
-| 123,456 |
-+-------------------------+
-```
-
-```sql
-mysql> select format_round(123456, 3);
-+-------------------------+
-| format_round(123456, 3) |
-+-------------------------+
-| 123,456.000 |
-+-------------------------+
-```
-
-
-```sql
-mysql> select format_round(123456.123456, 0);
-+--------------------------------+
-| format_round(123456.123456, 0) |
-+--------------------------------+
-| 123,456 |
-+--------------------------------+
-```
-
-```sql
-mysql> select format_round(123456.123456, 3);
-+--------------------------------+
-| format_round(123456.123456, 3) |
-+--------------------------------+
-| 123,456.123 |
-+--------------------------------+
-```
-
-```sql
-mysql> select format_round(123456.123456, 6);
-+--------------------------------+
-| format_round(123456.123456, 6) |
-+--------------------------------+
-| 123,456.123456 |
-+--------------------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
deleted file mode 100644
index 3409f5011c2..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++ /dev/null
@@ -1,85 +0,0 @@
----
-{
- "title": "PRINTF",
- "language": "cn"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-> 从版本 2.1.10 开始支持
-
-使用指定的
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
格式字符串和参数返回格式化后的字符串。
-
-## 语法
-
-```sql
-PRINTF(<format>, [<args>, ...])
-```
-
-## 参数
-
-| 参数 | 说明 |
-| -- | -- |
-| `<format>` | printf 格式字符串。 |
-| `<args>` | 要格式化的参数。 |
-
-## 返回值
-
-使用 printf 模式格式化后的字符串。
-
-## 示例
-
-```sql
-select printf("hello world");
-```
-
-```text
-+-----------------------+
-| printf("hello world") |
-+-----------------------+
-| hello world |
-+-----------------------+
-```
-
-```sql
-select printf('%d-%s-%.2f', 100, 'test', 3.14);
-```
-
-```text
-+-----------------------------------------+
-| printf('%d-%s-%.2f', 100, 'test', 3.14) |
-+-----------------------------------------+
-| 100-test-3.14 |
-+-----------------------------------------+
-```
-
-```sql
-select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159,
255);
-```
-
-```text
-+-----------------------------------------------------------------------------+
-| printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159, 255) |
-+-----------------------------------------------------------------------------+
-| Int: 255, Str: test, Float: 3.14, Hex: ff |
-+-----------------------------------------------------------------------------+
-```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
index 683efc81761..31945c1cf90 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
@@ -27,11 +27,6 @@ under the License.
## 描述
`unhex` 函数用于将十六进制字符串转换为原始字符串。将每两个十六进制字符转换为一个字节。当传入的参数是无效值时，将返回空字符串。
-`unhex_null` 函数与`unhex`函数作用一致。但是当传入的参数是无效值时，将返回`NULL`。
-
-:::tip
-unhex_null 函数自 2.1.10 版本开始支持.
-:::
## 语法
@@ -47,8 +42,8 @@ UNHEX(<str>)
## 返回值
-输入字符串，如果字符串长度为 0 或者为奇数，`unhex`函数返回空串，`unhex_null`函数返回`NULL`；
-如果字符串中包含`[0-9]、[a-f]、[A-F]`之外的字符，`unhex`函数返回空串，`unhex_null`函数返回`NULL`；
+输入字符串，如果字符串长度为 0 或者为奇数，`unhex`函数返回空串。
+如果字符串中包含`[0-9]、[a-f]、[A-F]`之外的字符，`unhex`函数返回空串。
其他情况每两个字符为一组转化为 16 进制后的字符，然后拼接成字符串输出。
## 举例
@@ -65,18 +60,6 @@ select unhex('@');
+------------+
```
-```sql
-select unhex_null('@');
-```
-
-```text
-+-----------------+
-| unhex_null('@') |
-+-----------------+
-| NULL |
-+-----------------+
-```
-
```sql
select unhex('41');
```
@@ -99,4 +82,4 @@ select unhex('4142');
+---------------+
| AB |
+---------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
deleted file mode 100644
index a46842fad7f..00000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++ /dev/null
@@ -1,111 +0,0 @@
----
-{
- "title": "XPATH_STRING",
- "language": "cn"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## 描述
-> 从版本 2.1.10 开始支持
-
-XPATH_STRING 函数用于解析 XML 字符串并返回第一个匹配 [XPath](https://www.w3.org/TR/xpath-10/)
表达式的 XML 节点。
-
-## 语法
-
-```sql
-XPATH_STRING(<xml_string>, <xpath_expression>)
-```
-
-## 参数
-| 参数 | 描述 |
-| --------- | ----------------------------------------------|
-| `<xml_string>` | 源字符串。类型：VARCHAR |
-| `<xpath_expression>` | [XPath](https://www.w3.org/TR/xpath-10/)
表达式。类型：VARCHAR |
-
-## 返回值
-
-返回 VARCHAR 类型，表示匹配 XPath 表达式的第一个 XML 节点的内容。
-
-特殊情况：
-- 如果 XML 或 XPath 格式不正确，函数会报错。
-
-## 示例
-
-1. 基本节点值提取
-```sql
-SELECT xpath_string('<a>123</a>', '/a');
-```
-```text
-+-----------------------------------+
-| xpath_string('<a>123</a>', '/a') |
-+-----------------------------------+
-| 123 |
-+-----------------------------------+
-```
-
-2. 嵌套元素提取
-```sql
-SELECT xpath_string('<a><b>123</b></a>', '/a/b');
-```
-```text
-+--------------------------------------------+
-| xpath_string('<a><b>123</b></a>', '/a/b') |
-+--------------------------------------------+
-| 123 |
-+--------------------------------------------+
-```
-
-3. 使用属性
-```sql
-SELECT xpath_string('<a><b id="1">123</b></a>', '//b[@id="1"]');
-```
-```text
-+----------------------------------------------------------+
-| xpath_string('<a><b id="1">123</b></a>', '//b[@id="1"]') |
-+----------------------------------------------------------+
-| 123 |
-+----------------------------------------------------------+
-```
-
-4. 使用位置谓词
-```sql
-SELECT xpath_string('<a><b>1</b><b>2</b></a>', '/a/b[2]');
-```
-```text
-+----------------------------------------------------+
-| xpath_string('<a><b>1</b><b>2</b></a>', '/a/b[2]') |
-+----------------------------------------------------+
-| 2 |
-+----------------------------------------------------+
-```
-
-5. 处理 CDATA 和注释
-```sql
-SELECT xpath_string('<a><![CDATA[123]]></a>', '/a'), xpath_string('<a><!--
comment -->123</a>', '/a');
-```
-```text
-+-----------------------------------------------+---------------------------------------------------+
-| xpath_string('<a><![CDATA[123]]></a>', '/a') | xpath_string('<a><!--
comment -->123</a>', '/a') |
-+-----------------------------------------------+---------------------------------------------------+
-| 123 | 123
|
-+-----------------------------------------------+---------------------------------------------------+
-```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
index 93c67cdd449..b5595afd7c0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
@@ -25,10 +25,13 @@ under the License.
-->
## 描述
-> 从版本 3.0.6 开始支持
`MONTHS_BETWEEN` 函数计算两个日期之间的月份数（浮点数）。它接收两个日期参数和一个可选的布尔参数。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
**注意：**
当 `<enddate>` 和 `<startdate>`
都是各自月份的最后一天时，函数会进行特殊处理。它会返回完整的月份差值，而不考虑基于天数的分数部分。这确保了在比较一个月末与另一个月末时的一致性。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
index 19b52db8e23..0fb8bb5b45f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
@@ -25,10 +25,13 @@ under the License.
-->
## 描述
-> 从版本 3.0.6 开始支持
NEXT_DAY 函数用于返回给定日期之后第一个匹配指定星期几的日期。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -69,4 +72,4 @@ select next_day("2020-01-31 02:02:02",
"MONDAY"),next_day("2020-01-31", "MONDAY"
+--------------------------------------------+-----------------------------------+
| 2020-02-03 | 2020-02-03
|
+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
index 4694745f36d..cd7bcea9f65 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
@@ -25,10 +25,13 @@ under the License.
-->
## 描述
-> 从版本 3.0.6 开始支持
将字符串转换为 `Map<String, String>` 类型。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -59,4 +62,4 @@ select str_to_map('a=1&b=2&c=3', '&', '=') as map1,
str_to_map('x:10|y:20|z:30',
+-----------------------------+--------------------------------+
| {"a":"1", "b":"2", "c":"3"} | {"x":"10", "y":"20", "z":"30"} |
+-----------------------------+--------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
index 57fa1ffdd47..406be46dc1a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
@@ -25,10 +25,13 @@ under the License.
-->
## 描述
-> 从版本 3.0.6 开始支持
使用指定的
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
格式字符串和参数返回格式化后的字符串。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
@@ -82,4 +85,4 @@ select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255,
'test', 3.14159, 25
+-----------------------------------------------------------------------------+
| Int: 255, Str: test, Float: 3.14, Hex: ff |
+-----------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
index 153ed403be7..1b91d830257 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
@@ -25,10 +25,13 @@ under the License.
-->
## 描述
-> 从版本 3.0.6 开始支持
XPATH_STRING 函数用于解析 XML 字符串并返回第一个匹配 [XPath](https://www.w3.org/TR/xpath-10/)
表达式的 XML 节点。
+:::tip
+该函数自 3.0.6 版本开始支持.
+:::
+
## 语法
```sql
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
deleted file mode 100644
index d6177b06ad6..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++ /dev/null
@@ -1,75 +0,0 @@
----
-{
- "title": "MONTHS_BETWEEN",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-> after version 2.1.10
-
-The `MONTHS_BETWEEN` function calculates the floating-point number of months
between two dates. It receives two date arguments and a optional boolean
argument.
-
-**Note:**
-When both `<enddate>` and `<startdate>` are the last day of their respective
months, the function applies special handling.It returns the full month
difference without considering the fractional part based on days. This ensures
consistency when comparing the end of one month to the end of another.
-
-For example:
-- `months_between('2024-01-31', '2024-02-29')` will return `-1.0`, because
both dates are the last day of their respective months (January 31st and
February 29th), so the result is treated as a full month difference without
fractional adjustments.
-- `months_between('2024-01-29', '2024-02-29')` will also return `-1.0`,
because the day of the month is the same.
-- `months_between('2024-01-30', '2024-02-29')` will return `-0.96774194`,
because the day of the month is not the same and not the last day of the month.
-
-## Syntax
-
-```sql
-MONTHS_BETWEEN(<enddate>, <startdate> [, <round_type>])
-```
-
-## Parameters
-
-| Parameter | Description
|
-|-------------------|------------------------------------------------------------|
-| `<enddate>` | The ending date, representing the later date in the
difference calculation. Supports `DATE` (e.g., `YYYY-MM-DD`) or `DATETIME`
(e.g., `YYYY-MM-DD HH:MM:SS`) types. |
-| `<startdate>` | The starting date, representing the earlier date in the
difference calculation. Supports `DATE` (e.g., `YYYY-MM-DD`) or `DATETIME`
(e.g., `YYYY-MM-DD HH:MM:SS`) types. |
-| `<round_type>` | Whether to round the result to the eighth decimal place.
Supports `true` or `false`. Default is `true`. |
-
-## Return Value
-
-returns the floating-point number of months resulting from `<enddate>` minus
`<startdate>`
-
-result = (`<enddate>.year` - `<startdate>.year`) * 12 + `<enddate>.month` -
`<startdate>.month` + (`<enddate>.day` - `<startdate>.day`) / 31.0
-
-- When either `<enddate>` or `<startdate>` is NULL, or both are NULL, it
returns NULL
-- When `<round_type>` is `true`, the result is rounded to the eighth decimal
place.
-
-## Example
-
-```sql
-select months_between('2020-12-26','2020-10-25'),months_between('2020-10-25
10:00:00','2020-12-26 11:00:00',false);
-```
-
-```text
-+-------------------------------------------+-------------------------------------------------------------------+
-| months_between('2020-12-26','2020-10-25') | months_between('2020-10-25
10:00:00','2020-12-26 11:00:00',false) |
-+-------------------------------------------+-------------------------------------------------------------------+
-| 2.03225806 |
-2.032258064516129 |
-+-------------------------------------------+-------------------------------------------------------------------+
-```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
deleted file mode 100644
index 66c46ad78df..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++ /dev/null
@@ -1,72 +0,0 @@
----
-{
- "title": "NEXT_DAY",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-> after version 2.1.10
-
-The NEXT_DAY function is used to return the first date that is later than the
given date and matches the specified day of the week.
-
-## Syntax
-
-```sql
-NEXT_DAY(<datetime/date>, <day_of_week>)
-```
-
-## Parameters
-
-| Parameter | Description
|
-|-------------------|---------------------------------------------------------------|
-| `<datetime/date>` | The date which will be used to find the next day of the
week. |
-| `<day_of_week>` | A STRING expression identifying a day of the week.
|
-
-`<day_of_week>` must be one of the following (case insensitive):
-- 'SU', 'SUN', 'SUNDAY'
-- 'MO', 'MON', 'MONDAY'
-- 'TU', 'TUE', 'TUESDAY'
-- 'WE', 'WED', 'WEDNESDAY'
-- 'TH', 'THU', 'THURSDAY'
-- 'FR', 'FRI', 'FRIDAY'
-- 'SA', 'SAT', 'SATURDAY'
-
-## Return Value
-A DATE value whatever the input is DATETIME or DATE.
-
-Special cases:
-- If the `<datetime/date>` input is NULL, the function returns NULL.
-- If the input is NEXT_DAY("9999-12-31 12:00:00", `<day_of_week>`), the
function will return same value as the input.
-
-## Example
-
-``` sql
-select next_day("2020-01-31 02:02:02", "MONDAY"),next_day("2020-01-31",
"MONDAY");
-```
-```text
-+--------------------------------------------+-----------------------------------+
-| next_day("2020-01-31 02:02:02", "MONDAY") | next_day("2020-01-31",
"MONDAY") |
-+--------------------------------------------+-----------------------------------+
-| 2020-02-03 | 2020-02-03
|
-+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index 88cff14c151..2e4fc7286d0 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -28,7 +28,6 @@ under the License.
JSON_EXTRACT is a series of functions that extract the field specified by
json_path from JSON data and provide different series of functions according to
the type of the field to be extracted.
* JSON_EXTRACT returns the VARCHAR type for a json string of the VARCHAR type.
-* JSON_EXTRACT_NO_QUOTES returns the VARCHAR type for a json string of the
VARCHAR type, if the value of a JSON field is a string, the double quotes will
be removed.
* JSON_EXTRACT_ISNULL returns the BOOLEAN type indicating whether it is a json
null.
* JSON_EXTRACT_BOOL returns the BOOLEAN type.
* JSON_EXTRACT_INT returns the INT type.
@@ -37,13 +36,8 @@ JSON_EXTRACT is a series of functions that extract the field
specified by json_p
* JSON_EXTRACT_DOUBLE returns the DOUBLE type.
* JSON_EXTRACT_STRING returns the STRING type.
-:::tip
-The `JSON_EXTRACT_NO_QUOTES` function has been supported since version 2.1.10.
-:::
-
## Alias
* JSONB_EXTRACT is the same as JSON_EXTRACT.
-* JSON_EXTRACT_NO_QUOTES is the same as JSON_EXTRACT_NO_QUOTES.
* JSONB_EXTRACT_ISNULL is the same as JSON_EXTRACT_ISNULL.
* JSONB_EXTRACT_BOOL is the same as JSON_EXTRACT_BOOL.
* JSONB_EXTRACT_INT is the same as JSON_EXTRACT_INT.
@@ -57,9 +51,6 @@ The `JSON_EXTRACT_NO_QUOTES` function has been supported
since version 2.1.10.
JSON_EXTRACT (<json_str>, <path>[, path] ...)
```
```sql
-JSON_EXTRACT_NO_QUOTES (<json_str>, <path>[, path] ...)
-```
-```sql
JSON_EXTRACT_ISNULL (<json_str>, <path>)
```
```sql
@@ -203,4 +194,4 @@ SELECT JSON_EXTRACT_STRING('{"id": 123, "name": "doris"}',
'$.name');
+------------------------------------------------------------------------------+
| doris
|
+------------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
deleted file mode 100644
index 82631e849d0..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++ /dev/null
@@ -1,62 +0,0 @@
----
-{
- "title": "STR_TO_MAP",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-> after version 2.1.10
-
-Constructs a `Map<String, String>` from a string.
-
-## Syntax
-
-```sql
-STR_TO_MAP(<str> [, <pair_delimiter> [, <key_value_delimiter>]])
-```
-
-## Parameters
-
-| Parameter | Description |
-| -- | -- |
-| `<str>` | The string to be converted to a map |
-| `<pair_delimiter>` | The delimiter for the pairs in the string, default is
`,` |
-| `<key_value_delimiter>` | The delimiter for the keys and values in the
string, default is `:` |
-
-## Return Value
-
-Returns a `Map<String, String>` constructed from a string.
-
-## Example
-
-```sql
-select str_to_map('a=1&b=2&c=3', '&', '=') as map1,
str_to_map('x:10|y:20|z:30', '|', ':') as map2;
-```
-
-```text
-+-----------------------------+--------------------------------+
-| map1 | map2 |
-+-----------------------------+--------------------------------+
-| {"a":"1", "b":"2", "c":"3"} | {"x":"10", "y":"20", "z":"30"} |
-+-----------------------------+--------------------------------+
-```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
deleted file mode 100644
index 4f9c14a92e4..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
+++ /dev/null
@@ -1,127 +0,0 @@
----
-{
- "title": "FORMAT_ROUND",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-
-Formats a number in a format similar to "#,###,###.##", rounds to the
specified decimal places, and returns the result as a string.
-
-:::tip
-This function has been supported since version 2.1.10.
-:::
-
-## Syntax
-
-```sql
-FORMAT_ROUND(<number>, <D>)
-```
-
-## Parameters
-
-| Parameter | Description |
-| -- | -- |
-| `<number>` | The number to be formatted |
-| `<D>` | Number of decimal places |
-
-## Return Value
-
-Returns the formatted string. Special cases:
-
-- Returns NULL when the parameter is NULL
-- If D is 0, the result will have no decimal point or decimal part.
-
-## Examples
-
-```sql
-mysql> select format_round(17014116, 2);
-+---------------------------+
-| format_round(17014116, 2) |
-+---------------------------+
-| 17,014,116.00 |
-+---------------------------+
-```
-
-```sql
-mysql> select format_round(1123.456, 2);
-+---------------------------+
-| format_round(1123.456, 2) |
-+---------------------------+
-| 1,123.46 |
-+---------------------------+
-```
-
-```sql
-mysql> select format_round(1123.4, 2);
-+-------------------------+
-| format_round(1123.4, 2) |
-+-------------------------+
-| 1,123.40 |
-+-------------------------+
-```
-
-```sql
-mysql> select format_round(123456, 0);
-+-------------------------+
-| format_round(123456, 0) |
-+-------------------------+
-| 123,456 |
-+-------------------------+
-```
-
-```sql
-mysql> select format_round(123456, 3);
-+-------------------------+
-| format_round(123456, 3) |
-+-------------------------+
-| 123,456.000 |
-+-------------------------+
-```
-
-```sql
-mysql> select format_round(123456.123456, 0);
-+--------------------------------+
-| format_round(123456.123456, 0) |
-+--------------------------------+
-| 123,456 |
-+--------------------------------+
-```
-
-```sql
-mysql> select format_round(123456.123456, 3);
-+--------------------------------+
-| format_round(123456.123456, 3) |
-+--------------------------------+
-| 123,456.123 |
-+--------------------------------+
-```
-
-```sql
-mysql> select format_round(123456.123456, 6);
-+--------------------------------+
-| format_round(123456.123456, 6) |
-+--------------------------------+
-| 123,456.123456 |
-+--------------------------------+
-```
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
deleted file mode 100644
index 9d71bf8eeab..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++ /dev/null
@@ -1,85 +0,0 @@
----
-{
- "title": "PRINTF",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-> after version 2.1.10
-
-Returns a formatted string using the specified
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
string and arguments.
-
-## Syntax
-
-```sql
-PRINTF(<format>, [<args>, ...])
-```
-
-## Parameters
-
-| Parameter | Description |
-| -- | -- |
-| `<format>` | The printf format string. |
-| `<args>` | The arguments to be formatted. |
-
-## Return Value
-
-The formatted string using a printf mode.
-
-## Example
-
-```sql
-select printf("hello world");
-```
-
-```text
-+-----------------------+
-| printf("hello world") |
-+-----------------------+
-| hello world |
-+-----------------------+
-```
-
-```sql
-select printf('%d-%s-%.2f', 100, 'test', 3.14);
-```
-
-```text
-+-----------------------------------------+
-| printf('%d-%s-%.2f', 100, 'test', 3.14) |
-+-----------------------------------------+
-| 100-test-3.14 |
-+-----------------------------------------+
-```
-
-```sql
-select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159,
255);
-```
-
-```text
-+-----------------------------------------------------------------------------+
-| printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159, 255) |
-+-----------------------------------------------------------------------------+
-| Int: 255, Str: test, Float: 3.14, Hex: ff |
-+-----------------------------------------------------------------------------+
-```
\ No newline at end of file
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
index 9417a161f67..5c3ebe1254f 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
@@ -27,11 +27,6 @@ under the License.
## Description
The `unhex` function is used to convert a hexadecimal string back into the
original string. It converts every two hexadecimal characters into one byte.
When an invalid value is passed as a parameter, it will return empty string.
-The `unhex_null` function has the same effect as the `unhex` function.
However, when an invalid value is passed as a parameter, it will return NULL.
-
-:::tip
-The `unhex_null` function has been supported since version 2.1.10.
-:::
## Syntax
@@ -47,8 +42,8 @@ UNHEX(<str>)
## Return Value
-If the input string has a length of 0 or is odd, `unhex` function returns an
empty string while `unhex_null` function returns `NULL`.
-If the string contains characters other than [0-9], [a-f], or [A-F], `unhex`
function returns an empty string while `unhex_null` function returns `NULL`.
+If the input string has a length of 0 or is odd, `unhex` function returns an
empty string.
+If the string contains characters other than [0-9], [a-f], or [A-F], `unhex`
function returns an empty string.
In other cases, every two characters are converted to their hexadecimal
representation and concatenated into a string for output.
## Examples
@@ -65,18 +60,6 @@ select unhex('@');
+------------+
```
-```sql
-select unhex_null('@');
-```
-
-```text
-+-----------------+
-| unhex_null('@') |
-+-----------------+
-| NULL |
-+-----------------+
-```
-
```sql
select unhex('41');
```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
deleted file mode 100644
index 54a2a222e64..00000000000
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++ /dev/null
@@ -1,111 +0,0 @@
----
-{
- "title": "XPATH_STRING",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## Description
-> after version 2.1.10
-
-The XPATH_STRING function is used to parse the XML string and return the first
XML node that matches the [XPath](https://www.w3.org/TR/xpath-10/) expression.
-
-## Syntax
-
-```sql
-XPATH_STRING(<xml_string>, <xpath_expression>)
-```
-
-## Parameters
-| Parameter | Description |
-| --------- | ----------------------------------------------|
-| `<xml_string>` | Source string. Type: VARCHAR |
-| `<xpath_expression>` | [XPath](https://www.w3.org/TR/xpath-10/) expression.
Type: VARCHAR |
-
-## Return Value
-
-Returns VARCHAR type, representing the contents of the first XML node that
matches the XPath expression.
-
-Special cases:
-- The function raises an error if xml or xpath are malformed.
-
-## Examples
-
-1. Basic node value extraction
-```sql
-SELECT xpath_string('<a>123</a>', '/a');
-```
-```text
-+-----------------------------------+
-| xpath_string('<a>123</a>', '/a') |
-+-----------------------------------+
-| 123 |
-+-----------------------------------+
-```
-
-2. Nested element extraction
-```sql
-SELECT xpath_string('<a><b>123</b></a>', '/a/b');
-```
-```text
-+--------------------------------------------+
-| xpath_string('<a><b>123</b></a>', '/a/b') |
-+--------------------------------------------+
-| 123 |
-+--------------------------------------------+
-```
-
-3. Using attributes
-```sql
-SELECT xpath_string('<a><b id="1">123</b></a>', '//b[@id="1"]');
-```
-```text
-+----------------------------------------------------------+
-| xpath_string('<a><b id="1">123</b></a>', '//b[@id="1"]') |
-+----------------------------------------------------------+
-| 123 |
-+----------------------------------------------------------+
-```
-
-4. Using position predicates
-```sql
-SELECT xpath_string('<a><b>1</b><b>2</b></a>', '/a/b[2]');
-```
-```text
-+----------------------------------------------------+
-| xpath_string('<a><b>1</b><b>2</b></a>', '/a/b[2]') |
-+----------------------------------------------------+
-| 2 |
-+----------------------------------------------------+
-```
-
-5. Handling CDATA and comments
-```sql
-SELECT xpath_string('<a><![CDATA[123]]></a>', '/a'), xpath_string('<a><!--
comment -->123</a>', '/a');
-```
-```text
-+-----------------------------------------------+---------------------------------------------------+
-| xpath_string('<a><![CDATA[123]]></a>', '/a') | xpath_string('<a><!--
comment -->123</a>', '/a') |
-+-----------------------------------------------+---------------------------------------------------+
-| 123 | 123
|
-+-----------------------------------------------+---------------------------------------------------+
-```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
index 5df9bb9510a..bf498e4feb4 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/months-between.md
@@ -25,10 +25,13 @@ under the License.
-->
## Description
-> after version 3.0.6
The `MONTHS_BETWEEN` function calculates the floating-point number of months
between two dates. It receives two date arguments and a optional boolean
argument.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
**Note:**
When both `<enddate>` and `<startdate>` are the last day of their respective
months, the function applies special handling.It returns the full month
difference without considering the fractional part based on days. This ensures
consistency when comparing the end of one month to the end of another.
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
index 740535262ad..a4f4116fb5a 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/date-time-functions/next-day.md
@@ -25,10 +25,13 @@ under the License.
-->
## Description
-> after version 3.0.6
The NEXT_DAY function is used to return the first date that is later than the
given date and matches the specified day of the week.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
@@ -69,4 +72,4 @@ select next_day("2020-01-31 02:02:02",
"MONDAY"),next_day("2020-01-31", "MONDAY"
+--------------------------------------------+-----------------------------------+
| 2020-02-03 | 2020-02-03
|
+--------------------------------------------+-----------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
index 9de8cf6e99b..83b942253d6 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/json-functions/json-extract.md
@@ -38,7 +38,7 @@ JSON_EXTRACT is a series of functions that extract the field
specified by json_p
* JSON_EXTRACT_STRING returns the STRING type.
:::tip
-The `JSON_EXTRACT_NO_QUOTES` function has been supported since version 3.0.6.
+The `JSON_EXTRACT_NO_QUOTES` function is supported since version 3.0.6.
:::
## Alias
@@ -203,4 +203,4 @@ SELECT JSON_EXTRACT_STRING('{"id": 123, "name": "doris"}',
'$.name');
+------------------------------------------------------------------------------+
| doris
|
+------------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
index 0ccf1fe2a84..1ddca78b609 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/map-functions/str-to-map.md
@@ -25,10 +25,13 @@ under the License.
-->
## Description
-> after version 3.0.6
Constructs a `Map<String, String>` from a string.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
index 3f7c9bd3476..baf4d36bfa8 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/numeric-functions/format-round.md
@@ -29,7 +29,7 @@ under the License.
Formats a number in a format similar to "#,###,###.##", rounds to the
specified decimal places, and returns the result as a string.
:::tip
-This function has been supported since version 3.0.6.
+This function is supported since version 3.0.6.
:::
## Syntax
@@ -124,4 +124,4 @@ mysql> select format_round(123456.123456, 6);
+--------------------------------+
| 123,456.123456 |
+--------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
index 7d841eaab43..b5b84a2636f 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/printf.md
@@ -25,10 +25,13 @@ under the License.
-->
## Description
-> after version 3.0.6
Returns a formatted string using the specified
[printf](https://pubs.opengroup.org/onlinepubs/009695399/functions/fprintf.html)
string and arguments.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
@@ -82,4 +85,4 @@ select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255,
'test', 3.14159, 25
+-----------------------------------------------------------------------------+
| Int: 255, Str: test, Float: 3.14, Hex: ff |
+-----------------------------------------------------------------------------+
-```
\ No newline at end of file
+```
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
index e49e2dec149..f2204121ccd 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/unhex.md
@@ -30,7 +30,7 @@ The `unhex` function is used to convert a hexadecimal string
back into the origi
The `unhex_null` function has the same effect as the `unhex` function.
However, when an invalid value is passed as a parameter, it will return NULL.
:::tip
-The `unhex_null` function has been supported since version 3.0.6.
+The `unhex_null` function is supported since version 3.0.6.
:::
## Syntax
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
index 3b3b2bb6e32..6cbd37d353e 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/scalar-functions/string-functions/xpath-string.md
@@ -25,10 +25,13 @@ under the License.
-->
## Description
-> after version 3.0.6
The XPATH_STRING function is used to parse the XML string and return the first
XML node that matches the [XPath](https://www.w3.org/TR/xpath-10/) expression.
+:::tip
+This function is supported since version 3.0.6.
+:::
+
## Syntax
```sql
diff --git a/versioned_sidebars/version-2.1-sidebars.json
b/versioned_sidebars/version-2.1-sidebars.json
index c9d43a8e2e2..e87998bf9f4 100644
--- a/versioned_sidebars/version-2.1-sidebars.json
+++ b/versioned_sidebars/version-2.1-sidebars.json
@@ -983,7 +983,6 @@
"sql-manual/sql-functions/scalar-functions/numeric-functions/floor",
"sql-manual/sql-functions/scalar-functions/numeric-functions/fmod",
"sql-manual/sql-functions/scalar-functions/numeric-functions/money-format",
-
"sql-manual/sql-functions/scalar-functions/numeric-functions/format-round",
"sql-manual/sql-functions/scalar-functions/numeric-functions/tan",
"sql-manual/sql-functions/scalar-functions/numeric-functions/tanh",
"sql-manual/sql-functions/scalar-functions/numeric-functions/pmod",
@@ -1077,9 +1076,7 @@
"sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-or-null",
"sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace",
"sql-manual/sql-functions/scalar-functions/string-functions/regexp-replace-one",
-
"sql-manual/sql-functions/scalar-functions/string-functions/digital-masking",
-
"sql-manual/sql-functions/scalar-functions/string-functions/printf",
-
"sql-manual/sql-functions/scalar-functions/string-functions/xpath-string"
+
"sql-manual/sql-functions/scalar-functions/string-functions/digital-masking"
]
},
{
@@ -1174,11 +1171,9 @@
"sql-manual/sql-functions/scalar-functions/date-time-functions/months-add",
"sql-manual/sql-functions/scalar-functions/date-time-functions/months-diff",
"sql-manual/sql-functions/scalar-functions/date-time-functions/months-sub",
-
"sql-manual/sql-functions/scalar-functions/date-time-functions/months-between",
"sql-manual/sql-functions/scalar-functions/date-time-functions/years-add",
"sql-manual/sql-functions/scalar-functions/date-time-functions/years-diff",
-
"sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub",
-
"sql-manual/sql-functions/scalar-functions/date-time-functions/next-day"
+
"sql-manual/sql-functions/scalar-functions/date-time-functions/years-sub"
]
},
{
@@ -1309,8 +1304,7 @@
"sql-manual/sql-functions/scalar-functions/map-functions/map-values",
"sql-manual/sql-functions/scalar-functions/map-functions/map-size",
"sql-manual/sql-functions/scalar-functions/map-functions/map-contains-key",
-
"sql-manual/sql-functions/scalar-functions/map-functions/map-contains-value",
-
"sql-manual/sql-functions/scalar-functions/map-functions/str-to-map"
+
"sql-manual/sql-functions/scalar-functions/map-functions/map-contains-value"
]
},
{
@@ -2144,4 +2138,4 @@
]
}
]
-}
\ No newline at end of file
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
