This is an automated email from the ASF dual-hosted git repository.
haonan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/iotdb.git
The following commit(s) were added to refs/heads/master by this push:
new ea15331 [IOTDB-1342] modify error message about LIMIT and OFFSET used
in conjunction with the FILL clause (#4149)
ea15331 is described below
commit ea153312c4b5db4f05e5ef14d8bf4ef908ac97cd
Author: Qian.Sun <[email protected]>
AuthorDate: Sat Oct 16 10:39:22 2021 +0800
[IOTDB-1342] modify error message about LIMIT and OFFSET used in
conjunction with the FILL clause (#4149)
---
docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md | 6 +++---
.../UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md | 6 +++---
2 files changed, 6 insertions(+), 6 deletions(-)
diff --git
a/docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
b/docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
index 6f038e3..06cdc46 100644
--- a/docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
+++ b/docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
@@ -1449,7 +1449,7 @@ select temperature from root.sgcc.wf03.wt01 where time =
2017-11-01T16:37:50.000
The SQL statement will not be executed and the corresponding error prompt is
given as follows:
```
-Msg: 401: line 1:107 mismatched input 'limit' expecting {<EOF>, SLIMIT,
SOFFSET, GROUP, DISABLE, ALIGN}
+Msg: 401: line 1:107 mismatched input 'limit' expecting {<EOF>, ';'}
```
#### Column Control over Query Results
@@ -1641,7 +1641,7 @@ select status,temperature from root.ln.wf01.wt01 where
time > 2017-11-01T00:05:0
The SQL statement will not be executed and the corresponding error prompt is
given as follows:
```
-Msg: 401: line 1:129 mismatched input '.' expecting {<EOF>, SLIMIT, OFFSET,
SOFFSET, GROUP, DISABLE, ALIGN}
+Msg: 401: line 1:129 mismatched input '.' expecting {<EOF>, ';'}
```
If the parameter OFFSET of LIMIT clause exceeds the size of the result set,
IoTDB will return an empty result set. For example, executing the following SQL
statement:
@@ -1809,7 +1809,7 @@ delete from root.ln.wf02.wt02.* where time <=
2017-11-01T16:26:00;
It should be noted that when the deleted path does not exist, IoTDB will not
prompt that the path does not exist, but that the execution is successful,
because SQL is a declarative programming method. Unless it is a syntax error,
insufficient permissions and so on, it is not considered an error, as shown
below:
```
IoTDB> delete from root.ln.wf03.wt02.status where time < now()
-Msg: The statement is executed successfully.
+Msg: TimeSeries does not exist and its data cannot be deleted
```
### Delete Time Partition (experimental)
diff --git
a/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
b/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
index e3bc114..d1444ce 100644
--- a/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
+++ b/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
@@ -1443,7 +1443,7 @@ select temperature from root.sgcc.wf03.wt01 where time =
2017-11-01T16:37:50.000
SQL 语句将不会执行，并且相应的错误提示如下：
```
-Msg: 401: Error occured while parsing SQL to physical plan: line 1:101
mismatched input 'limit' expecting {<EOF>, SLIMIT, SOFFSET, GROUP, DISABLE,
ALIGN}
+Msg: 401: Error occured while parsing SQL to physical plan: line 1:101
mismatched input 'limit' expecting {<EOF>, ';'}
```
#### 列控制
@@ -1635,7 +1635,7 @@ select status,temperature from root.ln.wf01.wt01 where
time > 2017-11-01T00:05:0
SQL 语句将不会执行，并且相应的错误提示如下：
```
-Msg: 401: line 1:129 mismatched input '.' expecting {<EOF>, SLIMIT, OFFSET,
SOFFSET, GROUP, DISABLE, ALIGN}
+Msg: 401: line 1:129 mismatched input '.' expecting {<EOF>, ';'}
```
当 LIMIT 子句的参数 OFFSET 超过结果集的大小时，IoTDB 将返回空结果集。 例如，执行以下 SQL 语句：
@@ -1781,7 +1781,7 @@ delete from root.ln.wf02.wt02.* where time <=
2017-11-01T16:26:00;
```sql
IoTDB> delete from root.ln.wf03.wt02.status where time < now()
-Msg: The statement is executed successfully.
+Msg: TimeSeries does not exist and its data cannot be deleted
```
### 删除时间分区 （实验性功能）
