You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2020/12/15 13:33:00 UTC
[jira] [Created] (IOTDB-1060) Delete from does not take effect
Yuan Tian created IOTDB-1060:
--------------------------------
Summary: Delete from does not take effect
Key: IOTDB-1060
URL: https://issues.apache.org/jira/browse/IOTDB-1060
Project: Apache IoTDB
Issue Type: Bug
Components: Core/Engine
Reporter: Yuan Tian
IoTDB> insert into root.sg1.d1(time,s1) values(1,1);
Msg: The statement is executed successfully.
IoTDB>
IoTDB> select last s1 from root.*.*;
+-----------------------------+--------------+-----+
| Time| timeseries|value|
+-----------------------------+--------------+-----+
|1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
+-----------------------------+--------------+-----+
Total line number = 1
It costs 0.077s
IoTDB> delete from root.sg1.d1.s1
Msg: The statement is executed successfully.
IoTDB> select last s1 from root.*.*;
+-----------------------------+--------------+-----+
| Time| timeseries|value|
+-----------------------------+--------------+-----+
|1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
+-----------------------------+--------------+-----+
Total line number = 1
It costs 0.004s
IoTDB> select s1 from root.sg1.d1
+-----------------------------+--------------+
| Time|root.sg1.d1.s1|
+-----------------------------+--------------+
|1970-01-01T08:00:00.001+08:00| 1.0|
+-----------------------------+--------------+
Total line number = 1
It costs 0.072s
IoTDB> delete from root.sg1.d1.s1 where time <= 10;
Msg: The statement is executed successfully.
IoTDB> select last s1 from root.*.*;
+-----------------------------+--------------+-----+
| Time| timeseries|value|
+-----------------------------+--------------+-----+
|1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
+-----------------------------+--------------+-----+
Total line number = 1
It costs 0.004s
IoTDB> select s1 from root.sg1.d1
+----+--------------+
|Time|root.sg1.d1.s1|
+----+--------------+
+----+--------------+
Empty set.
It costs 0.004s
--
This message was sent by Atlassian Jira
(v8.3.4#803005)