You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2023/08/29 09:38:00 UTC
[jira] [Created] (IOTDB-6130) Delete data by pattern didn't work sometimes
Haonan Hou created IOTDB-6130:
---------------------------------
Summary: Delete data by pattern didn't work sometimes
Key: IOTDB-6130
URL: https://issues.apache.org/jira/browse/IOTDB-6130
Project: Apache IoTDB
Issue Type: Bug
Reporter: Haonan Hou
Attachments: image-2023-08-29-17-37-33-557.png
Execute the following sql, you will see data of root.sg.d2.s1 doesn't delete by `delete from root.*.*.s1`.
{code:sql}
IoTDB> insert into root.sg.d2(time,s1,s2) values(1,2,3)
Msg: The statement is executed successfully.
IoTDB> flush
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| 2.0| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.153s
IoTDB> delete from root.*.*.s1
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| 2.0| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.013s
IoTDB> delete from root.**.s1
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| null| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.018s{code}
The following code causes this issue.
!image-2023-08-29-17-37-33-557.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)