[ 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)