This is an automated email from the ASF dual-hosted git repository.
caogaofei pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new fc0056d Fix query result set
fc0056d is described below
commit fc0056d4f66331873fa3b7f88e43c1ad27de74d2
Author: W1y1r <[email protected]>
AuthorDate: Mon Aug 5 18:48:27 2024 +0800
Fix query result set
---
src/UserGuide/Master/User-Manual/Query-Data.md | 16 ++++++++--------
src/UserGuide/latest/User-Manual/Query-Data.md | 17 +++++++++--------
src/zh/UserGuide/Master/User-Manual/Query-Data.md | 18 +++++++++---------
src/zh/UserGuide/latest/User-Manual/Query-Data.md | 16 ++++++++--------
4 files changed, 34 insertions(+), 33 deletions(-)
diff --git a/src/UserGuide/Master/User-Manual/Query-Data.md
b/src/UserGuide/Master/User-Manual/Query-Data.md
index e016e15..fe0bc93 100644
--- a/src/UserGuide/Master/User-Manual/Query-Data.md
+++ b/src/UserGuide/Master/User-Manual/Query-Data.md
@@ -2071,12 +2071,12 @@ It costs 0.342s
The SQL statement is:
```sql
-select status,temperature from root.ln.wf01.wt01 where time >
2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 2 offset 3
+select status,temperature from root.ln.wf01.wt01 where time >
2024-07-07T00:05:00.000 and time< 2024-07-12T00:12:00.000 limit 5 offset 3
```
which means:
-The selected device is ln group wf01 plant wt01 device; the selected
timeseries is "status" and "temperature". The SQL statement requires rows 3 to
4 of the status and temperature sensor values between the time point of
"2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" (with the first row
numbered as row 0).
+The selected device is ln group wf01 plant wt01 device; the selected
timeseries is "status" and "temperature". The SQL statement requires rows 3 to
4 of the status and temperature sensor values between the time point of
"2024-07-07T00:05:00.000" and "2024-07-12T00:12:00.000" (with the first row
numbered as row 0).
The result is shown below:
@@ -2084,14 +2084,14 @@ The result is shown below:
+-----------------------------+------------------------+-----------------------------+
|
Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
-|2017-11-01T00:03:00.000+08:00| false|
20.18|
-|2017-11-01T00:04:00.000+08:00| false|
21.13|
-|2017-11-01T00:05:00.000+08:00| false|
22.72|
-|2017-11-01T00:06:00.000+08:00| false|
20.71|
-|2017-11-01T00:07:00.000+08:00| false|
21.45|
+|2024-07-09T17:32:11.943+08:00| true|
24.941973|
+|2024-07-09T17:32:12.944+08:00| true|
20.05108|
+|2024-07-09T17:32:13.945+08:00| true|
20.541632|
+|2024-07-09T17:32:14.945+08:00| null|
23.09016|
+|2024-07-09T17:32:14.946+08:00| true|
null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 5
-It costs 0.000s
+It costs 0.070s
```
* Example 4: LIMIT clause combined with GROUP BY clause
diff --git a/src/UserGuide/latest/User-Manual/Query-Data.md
b/src/UserGuide/latest/User-Manual/Query-Data.md
index e016e15..a917344 100644
--- a/src/UserGuide/latest/User-Manual/Query-Data.md
+++ b/src/UserGuide/latest/User-Manual/Query-Data.md
@@ -2070,13 +2070,14 @@ It costs 0.342s
The SQL statement is:
+
```sql
-select status,temperature from root.ln.wf01.wt01 where time >
2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 2 offset 3
+select status,temperature from root.ln.wf01.wt01 where time >
2024-07-07T00:05:00.000 and time< 2024-07-12T00:12:00.000 limit 5 offset 3
```
which means:
-The selected device is ln group wf01 plant wt01 device; the selected
timeseries is "status" and "temperature". The SQL statement requires rows 3 to
4 of the status and temperature sensor values between the time point of
"2017-11-01T00:05:00.000" and "2017-11-01T00:12:00.000" (with the first row
numbered as row 0).
+The selected device is ln group wf01 plant wt01 device; the selected
timeseries is "status" and "temperature". The SQL statement requires rows 3 to
4 of the status and temperature sensor values between the time point of
"2024-07-07T00:05:00.000" and "2024-07-12T00:12:00.000" (with the first row
numbered as row 0).
The result is shown below:
@@ -2084,14 +2085,14 @@ The result is shown below:
+-----------------------------+------------------------+-----------------------------+
|
Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
-|2017-11-01T00:03:00.000+08:00| false|
20.18|
-|2017-11-01T00:04:00.000+08:00| false|
21.13|
-|2017-11-01T00:05:00.000+08:00| false|
22.72|
-|2017-11-01T00:06:00.000+08:00| false|
20.71|
-|2017-11-01T00:07:00.000+08:00| false|
21.45|
+|2024-07-09T17:32:11.943+08:00| true|
24.941973|
+|2024-07-09T17:32:12.944+08:00| true|
20.05108|
+|2024-07-09T17:32:13.945+08:00| true|
20.541632|
+|2024-07-09T17:32:14.945+08:00| null|
23.09016|
+|2024-07-09T17:32:14.946+08:00| true|
null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 5
-It costs 0.000s
+It costs 0.070s
```
* Example 4: LIMIT clause combined with GROUP BY clause
diff --git a/src/zh/UserGuide/Master/User-Manual/Query-Data.md
b/src/zh/UserGuide/Master/User-Manual/Query-Data.md
index 604490c..b52a10b 100644
--- a/src/zh/UserGuide/Master/User-Manual/Query-Data.md
+++ b/src/zh/UserGuide/Master/User-Manual/Query-Data.md
@@ -2229,12 +2229,12 @@ It costs 0.342s
SQL 语句：
```sql
-select status,temperature from root.ln.wf01.wt01 where time >
2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 5 offset 3
+select status,temperature from root.ln.wf01.wt01 where time >
2024-07-07T00:05:00.000 and time< 2024-07-12T00:12:00.000 limit 5 offset 3
```
含义：
-所选设备为 ln 组 wf01 工厂 wt01 设备； 选择的时间序列是“状态”和“温度”。 SQL 语句要求返回时间“
2017-11-01T00：05：00.000”和“ 2017-11-01T00：12：00.000”之间的状态和温度传感器值的第 3 至 4 行（第一行）
编号为第 0 行）。
+所选设备为 ln 组 wf01 工厂 wt01 设备； 选择的时间序列是“状态”和“温度”。 SQL 语句要求返回时间“
2024-07-07T00：05：00.000”和“ 2024-07-12T00：12：00.000”之间的状态和温度传感器值的第 3 至 4 行（第一行）
编号为第 0 行）。
结果如下所示：
@@ -2242,15 +2242,15 @@ select status,temperature from root.ln.wf01.wt01 where
time > 2017-11-01T00:05:0
+-----------------------------+------------------------+-----------------------------+
|
Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
-|2017-11-01T00:03:00.000+08:00| false|
20.18|
-|2017-11-01T00:04:00.000+08:00| false|
21.13|
-|2017-11-01T00:05:00.000+08:00| false|
22.72|
-|2017-11-01T00:06:00.000+08:00| false|
20.71|
-|2017-11-01T00:07:00.000+08:00| false|
21.45|
+|2024-07-09T17:32:11.943+08:00| true|
24.941973|
+|2024-07-09T17:32:12.944+08:00| true|
20.05108|
+|2024-07-09T17:32:13.945+08:00| true|
20.541632|
+|2024-07-09T17:32:14.945+08:00| null|
23.09016|
+|2024-07-09T17:32:14.946+08:00| true|
null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 5
-It costs 0.000s
-```
+It costs 0.070s
+``
- **示例 4：** `LIMIT` 子句与 `GROUP BY` 子句组合
diff --git a/src/zh/UserGuide/latest/User-Manual/Query-Data.md
b/src/zh/UserGuide/latest/User-Manual/Query-Data.md
index 604490c..59a6c2f 100644
--- a/src/zh/UserGuide/latest/User-Manual/Query-Data.md
+++ b/src/zh/UserGuide/latest/User-Manual/Query-Data.md
@@ -2229,12 +2229,12 @@ It costs 0.342s
SQL 语句：
```sql
-select status,temperature from root.ln.wf01.wt01 where time >
2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 5 offset 3
+select status,temperature from root.ln.wf01.wt01 where time >
2024-07-07T00:05:00.000 and time< 2024-07-12T00:12:00.000 limit 5 offset 3
```
含义：
-所选设备为 ln 组 wf01 工厂 wt01 设备； 选择的时间序列是“状态”和“温度”。 SQL 语句要求返回时间“
2017-11-01T00：05：00.000”和“ 2017-11-01T00：12：00.000”之间的状态和温度传感器值的第 3 至 4 行（第一行）
编号为第 0 行）。
+所选设备为 ln 组 wf01 工厂 wt01 设备； 选择的时间序列是“状态”和“温度”。 SQL 语句要求返回时间“
2024-07-07T00：05：00.000”和“ 2024-07-12T00：12：00.000”之间的状态和温度传感器值的第 3 至 4 行（第一行）
编号为第 0 行）。
结果如下所示：
@@ -2242,14 +2242,14 @@ select status,temperature from root.ln.wf01.wt01 where
time > 2017-11-01T00:05:0
+-----------------------------+------------------------+-----------------------------+
|
Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature|
+-----------------------------+------------------------+-----------------------------+
-|2017-11-01T00:03:00.000+08:00| false|
20.18|
-|2017-11-01T00:04:00.000+08:00| false|
21.13|
-|2017-11-01T00:05:00.000+08:00| false|
22.72|
-|2017-11-01T00:06:00.000+08:00| false|
20.71|
-|2017-11-01T00:07:00.000+08:00| false|
21.45|
+|2024-07-09T17:32:11.943+08:00| true|
24.941973|
+|2024-07-09T17:32:12.944+08:00| true|
20.05108|
+|2024-07-09T17:32:13.945+08:00| true|
20.541632|
+|2024-07-09T17:32:14.945+08:00| null|
23.09016|
+|2024-07-09T17:32:14.946+08:00| true|
null|
+-----------------------------+------------------------+-----------------------------+
Total line number = 5
-It costs 0.000s
+It costs 0.070s
```
- **示例 4：** `LIMIT` 子句与 `GROUP BY` 子句组合
