This is an automated email from the ASF dual-hosted git repository.
kassiez 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 11081793b60 [doc](function) fix some not suitable description about
lead/lag function (#2282)
11081793b60 is described below
commit 11081793b6054ac991cea0e3fe8564328ff9fba6
Author: zhangstar333 <zhangs...@selectdb.com>
AuthorDate: Wed Apr 23 20:14:41 2025 +0800
[doc](function) fix some not suitable description about lead/lag function
(#2282)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/sql-manual/sql-functions/window-functions/lag.md | 2 +-
docs/sql-manual/sql-functions/window-functions/lead.md | 2 +-
.../current/sql-manual/sql-functions/window-functions/lag.md | 2 +-
.../current/sql-manual/sql-functions/window-functions/lead.md | 2 +-
.../version-2.1/sql-manual/sql-functions/window-functions/lag.md | 2 +-
.../version-2.1/sql-manual/sql-functions/window-functions/lead.md | 4 ++--
.../version-3.0/sql-manual/sql-functions/window-functions/lag.md | 2 +-
.../version-3.0/sql-manual/sql-functions/window-functions/lead.md | 2 +-
.../version-2.1/sql-manual/sql-functions/window-functions/lag.md | 4 ++--
.../version-2.1/sql-manual/sql-functions/window-functions/lead.md | 4 ++--
.../version-3.0/sql-manual/sql-functions/window-functions/lag.md | 4 ++--
.../version-3.0/sql-manual/sql-functions/window-functions/lead.md | 2 +-
12 files changed, 16 insertions(+), 16 deletions(-)
diff --git a/docs/sql-manual/sql-functions/window-functions/lag.md
b/docs/sql-manual/sql-functions/window-functions/lag.md
index 6c07c9b0f07..67b941b9353 100644
--- a/docs/sql-manual/sql-functions/window-functions/lag.md
+++ b/docs/sql-manual/sql-functions/window-functions/lag.md
@@ -25,7 +25,7 @@ LAG ( <expr> [, <offset> [, <default> ] ] )
| Parameter | Description
|
| ------------------- |
--------------------------------------------------------------------------------------------------
|
| expr | The expression whose value is to be retrieved
|
-| offset | Optional. Number of rows to look backward. Default is
1. When negative, behaves like LEAD function |
+| offset | Optional. Number of rows to look ahead. Default is 1. |
| default | Optional. Value to return when the offset goes beyond
window bounds. Default is NULL |
## Return Value
diff --git a/docs/sql-manual/sql-functions/window-functions/lead.md
b/docs/sql-manual/sql-functions/window-functions/lead.md
index 8fbd4de040a..65bd9c21412 100644
--- a/docs/sql-manual/sql-functions/window-functions/lead.md
+++ b/docs/sql-manual/sql-functions/window-functions/lead.md
@@ -25,7 +25,7 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| Parameter | Description
|
| ------------------- |
---------------------------------------------------------------------------------------------------------------------------------------------------------
|
| expr | The expression whose value needs to be retrieved
|
-| offset | Optional. Number of rows to look ahead. Default is 1.
When negative, behaves like LAG function. Maximum value is 1,000,000 when
IGNORE NULLS is specified |
+| offset | Optional. Number of rows to look backward. Default is
1. |
| default | Optional. Default value to return when the offset goes
beyond the window range. Default is NULL
|
## Return Value
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lag.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lag.md
index 5251ebaaea7..e34d5e10001 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lag.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lag.md
@@ -25,7 +25,7 @@ LAG ( <expr> [, <offset> [, <default> ] ] )
| 参数 | 说明
|
| ------------------- |
---------------------------------------------------------------------- |
| expr | 需要获取值的表达式
|
-| offset | 可选。向前偏移的行数。默认值为 1。设置为负数时效果等同于使用 LEAD 函数 |
+| offset | 可选。向前偏移的行数。默认值为 1。|
| default | 可选。当偏移超出窗口范围时返回的默认值。默认为 NULL |
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lead.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lead.md
index 2cd0b7197dc..c6dbc68f932 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lead.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/window-functions/lead.md
@@ -25,7 +25,7 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| 参数 | 说明
|
| ------------------- |
-----------------------------------------------------------------------------------------------------------------
|
| expr | 需要获取值的表达式
|
-| offset | 可选。向后偏移的行数。默认值为 1。设置为负数时效果等同于使用 LAG 函数。当指定 IGNORE
NULLS 时，最大值为 1,000,000 |
+| offset | 可选。向后偏移的行数。默认值为 1。|
| default | 可选。当偏移超出窗口范围时返回的默认值。默认为 NULL
|
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
index c4781edd42c..96149cd3d35 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
@@ -25,7 +25,7 @@ LAG ( <expr>, <offset>, <default> )
| 参数 | 说明
|
| ------------------- |
----------------------------------------------------------------- |
| expr | 需要获取值的表达式
|
-| offset | 向前偏移的行数。设置为负数时效果等同于使用 LEAD 函数 |
+| offset | 向前偏移的行数。|
| default | 当偏移超出窗口范围时返回的默认值 |
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
index 2cd0b7197dc..0e95d631965 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
@@ -25,8 +25,8 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| 参数 | 说明
|
| ------------------- |
-----------------------------------------------------------------------------------------------------------------
|
| expr | 需要获取值的表达式
|
-| offset | 可选。向后偏移的行数。默认值为 1。设置为负数时效果等同于使用 LAG 函数。当指定 IGNORE
NULLS 时，最大值为 1,000,000 |
-| default | 可选。当偏移超出窗口范围时返回的默认值。默认为 NULL
|
+| offset | 向后偏移的行数。|
+| default | 当偏移超出窗口范围时返回的默认值。
|
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
index c4781edd42c..96149cd3d35 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
@@ -25,7 +25,7 @@ LAG ( <expr>, <offset>, <default> )
| 参数 | 说明
|
| ------------------- |
----------------------------------------------------------------- |
| expr | 需要获取值的表达式
|
-| offset | 向前偏移的行数。设置为负数时效果等同于使用 LEAD 函数 |
+| offset | 向前偏移的行数。|
| default | 当偏移超出窗口范围时返回的默认值 |
## 返回值
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
index 2cd0b7197dc..c6dbc68f932 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
@@ -25,7 +25,7 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| 参数 | 说明
|
| ------------------- |
-----------------------------------------------------------------------------------------------------------------
|
| expr | 需要获取值的表达式
|
-| offset | 可选。向后偏移的行数。默认值为 1。设置为负数时效果等同于使用 LAG 函数。当指定 IGNORE
NULLS 时，最大值为 1,000,000 |
+| offset | 可选。向后偏移的行数。默认值为 1。|
| default | 可选。当偏移超出窗口范围时返回的默认值。默认为 NULL
|
## 返回值
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
index 29be617dbb2..37ed7bcbe3f 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lag.md
@@ -25,8 +25,8 @@ LAG ( <expr>, <offset>, <default> )
| Parameter | Description
|
| -------------------
|-----------------------------------------------------------------------------------------|
| expr | The expression whose value is to be retrieved
|
-| offset | Number of rows to look backward. When negative,
behaves like LEAD function |
-| default | Value to return when the offset goes beyond window
bounds. |
+| offset | Number of rows to look ahead. |
+| default | Value to return when the offset goes beyond window
bounds. |
## Return Value
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
index 8fbd4de040a..9262759a2ee 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/lead.md
@@ -25,8 +25,8 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| Parameter | Description
|
| ------------------- |
---------------------------------------------------------------------------------------------------------------------------------------------------------
|
| expr | The expression whose value needs to be retrieved
|
-| offset | Optional. Number of rows to look ahead. Default is 1.
When negative, behaves like LAG function. Maximum value is 1,000,000 when
IGNORE NULLS is specified |
-| default | Optional. Default value to return when the offset goes
beyond the window range. Default is NULL
|
+| offset | Number of rows to look backward. |
+| default | Default value to return when the offset goes beyond
the window range. |
## Return Value
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
index 29be617dbb2..6f33d0d0891 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lag.md
@@ -25,8 +25,8 @@ LAG ( <expr>, <offset>, <default> )
| Parameter | Description
|
| -------------------
|-----------------------------------------------------------------------------------------|
| expr | The expression whose value is to be retrieved
|
-| offset | Number of rows to look backward. When negative,
behaves like LEAD function |
-| default | Value to return when the offset goes beyond window
bounds. |
+| offset | Number of rows to look ahead.|
+| default | Value to return when the offset goes beyond window
bounds. |
## Return Value
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
b/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
index 8fbd4de040a..98f434ef4f0 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-functions/window-functions/lead.md
@@ -25,7 +25,7 @@ LEAD ( <expr> [ , <offset> [ , <default> ] ] )
| Parameter | Description
|
| ------------------- |
---------------------------------------------------------------------------------------------------------------------------------------------------------
|
| expr | The expression whose value needs to be retrieved
|
-| offset | Optional. Number of rows to look ahead. Default is 1.
When negative, behaves like LAG function. Maximum value is 1,000,000 when
IGNORE NULLS is specified |
+| offset | Optional. Number of rows to look backward. Default is
1.|
| default | Optional. Default value to return when the offset goes
beyond the window range. Default is NULL
|
## Return Value
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
