This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 4fa5c155d1c [fix](docs) replace timestamp with datetime in window
examples (#3367)
4fa5c155d1c is described below
commit 4fa5c155d1cdada2498f169a8ce79eba4b37d490
Author: Yongqiang YANG <[email protected]>
AuthorDate: Tue Feb 10 11:21:04 2026 -0800
[fix](docs) replace timestamp with datetime in window examples (#3367)
## Summary
- verify #2056 is still open and the example still uses unsupported
`timestamp`
- replace `closing_date timestamp` with `closing_date datetime` in
window-function example SQL
- propagate the same fix consistently across current and versioned EN +
ZH docs where this example appears
- commit is authored with the original author identity from #2056
## Reference
- redoes issue intent from #2056
Co-authored-by: apna clg <[email protected]>
---
docs/query-data/window-function.md | 4 ++--
.../current/query-data/window-function.md | 2 +-
.../sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md | 4 ++--
.../version-2.0/query/query-data/window-function.md | 2 +-
.../sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md | 2 +-
.../version-2.1/sql-manual/sql-functions/window-functions/overview.md | 2 +-
.../version-3.x/sql-manual/sql-functions/window-functions/overview.md | 2 +-
.../version-4.x/query-data/window-function.md | 2 +-
.../sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md | 4 ++--
versioned_docs/version-2.0/query/query-data/window-function.md | 2 +-
.../sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md | 2 +-
.../version-2.1/sql-manual/sql-functions/window-functions/overview.md | 2 +-
.../version-3.x/sql-manual/sql-functions/window-functions/overview.md | 2 +-
versioned_docs/version-4.x/query-data/window-function.md | 4 ++--
14 files changed, 18 insertions(+), 18 deletions(-)
diff --git a/docs/query-data/window-function.md
b/docs/query-data/window-function.md
index dc6d81f7492..ff84f373b1d 100644
--- a/docs/query-data/window-function.md
+++ b/docs/query-data/window-function.md
@@ -498,7 +498,7 @@ The query results are as follows:
1. Assume we have the following stock data, with stock symbol JDR and daily
closing prices:
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
INSERT INTO stock_ticker VALUES
("JDR", 12.86, "2014-10-02 00:00:00"),
@@ -707,4 +707,4 @@ curl --location-trusted \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
```
-The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
\ No newline at end of file
+The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
index 74fe073241a..057c313345f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/window-function.md
@@ -479,7 +479,7 @@ where year in (1999, 2000, 2001, 2002)
1. 假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
INSERT INTO stock_ticker VALUES
("JDR", 12.86, "2014-10-02 00:00:00"),
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
index d118a0804d1..ddce56e5394 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
@@ -56,7 +56,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
| stock_symbol | closing_price | closing_date |
@@ -90,4 +90,4 @@ from stock_ticker;
### keywords
- WINDOW,FUNCTION
\ No newline at end of file
+ WINDOW,FUNCTION
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/window-function.md
index a0f6232c561..9c9d6c31d11 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-data/window-function.md
@@ -53,7 +53,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
index da1cffb4ce4..cf0a29c9c0e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
@@ -55,7 +55,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
| stock_symbol | closing_price | closing_date |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
index 0667f04a4c8..5d0d5168c84 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
@@ -46,7 +46,7 @@ function(<args>) OVER(
1. 假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
index 0667f04a4c8..6564dd505de 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
@@ -46,7 +46,7 @@ function(<args>) OVER(
1. 假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/window-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/window-function.md
index 74fe073241a..057c313345f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/window-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/query-data/window-function.md
@@ -479,7 +479,7 @@ where year in (1999, 2000, 2001, 2002)
1. 假设我们有如下的股票数据，股票代码是 JDR，closing price 是每天的收盘价。
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
INSERT INTO stock_ticker VALUES
("JDR", 12.86, "2014-10-02 00:00:00"),
diff --git
a/versioned_docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
b/versioned_docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
index d54ef64f632..0a140dfb00d 100644
---
a/versioned_docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
+++
b/versioned_docs/version-1.2/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
@@ -56,7 +56,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
Suppose we have the following stock data, the stock symbol is JDR, and the
closing price is the closing price of each day.
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
| stock_symbol | closing_price | closing_date |
@@ -90,4 +90,4 @@ from stock_ticker;
### keywords
- WINDOW,FUNCTION
\ No newline at end of file
+ WINDOW,FUNCTION
diff --git a/versioned_docs/version-2.0/query/query-data/window-function.md
b/versioned_docs/version-2.0/query/query-data/window-function.md
index 1700823dc63..861e0931da1 100644
--- a/versioned_docs/version-2.0/query/query-data/window-function.md
+++ b/versioned_docs/version-2.0/query/query-data/window-function.md
@@ -51,7 +51,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
Taking the following stock data as an example, the stock code is JDR, and the
"closing price" refers to the daily closing quotation.
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
b/versioned_docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
index afda9990331..4bf3942d47f 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-functions/window-functions/WINDOW-FUNCTION.md
@@ -55,7 +55,7 @@ ROWS BETWEEN [ { m | UNBOUNDED } PRECEDING | CURRENT ROW] [
AND [CURRENT ROW | {
Suppose we have the following stock data, the stock symbol is JDR, and the
closing price is the closing price of each day.
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
| stock_symbol | closing_price | closing_date |
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
index 1100723f9dc..e4e7477f017 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/window-functions/overview.md
@@ -46,7 +46,7 @@ Returns the same data type as the input expression.
1. Assume we have the following stock data, with stock symbol JDR and daily
closing prices:
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
index 1100723f9dc..e4e7477f017 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/window-functions/overview.md
@@ -46,7 +46,7 @@ Returns the same data type as the input expression.
1. Assume we have the following stock data, with stock symbol JDR and daily
closing prices:
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
...load some data...
select * from stock_ticker order by stock_symbol, closing_date
```
diff --git a/versioned_docs/version-4.x/query-data/window-function.md
b/versioned_docs/version-4.x/query-data/window-function.md
index dc6d81f7492..ff84f373b1d 100644
--- a/versioned_docs/version-4.x/query-data/window-function.md
+++ b/versioned_docs/version-4.x/query-data/window-function.md
@@ -498,7 +498,7 @@ The query results are as follows:
1. Assume we have the following stock data, with stock symbol JDR and daily
closing prices:
```sql
-create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date timestamp);
+create table stock_ticker (stock_symbol string, closing_price decimal(8,2),
closing_date datetime);
INSERT INTO stock_ticker VALUES
("JDR", 12.86, "2014-10-02 00:00:00"),
@@ -707,4 +707,4 @@ curl --location-trusted \
http://127.0.0.1:8030/api/doc_tpcds/customer_address/_stream_load
```
-The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
\ No newline at end of file
+The data files ``item_1_10.dat``, ``date-dim_1_10.dat``, ``store_stales.csv``,
and ``customer-address_1_10.dat`` can be downloaded by clicking on the
[link](https://cdn.selectdb.com/static/doc_ddl_dir_d27a752a7b.tar).
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
