[
https://issues.apache.org/jira/browse/IOTDB-6130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yanze chen reassigned IOTDB-6130:
---------------------------------
Assignee: yanze chen
> Delete data by specific pattern didn't work
> -------------------------------------------
>
> Key: IOTDB-6130
> URL: https://issues.apache.org/jira/browse/IOTDB-6130
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: 1.1.2
> Reporter: Haonan Hou
> Assignee: yanze chen
> Priority: Minor
> 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|width=364,height=261!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
