[
https://issues.apache.org/jira/browse/IOTDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17396526#comment-17396526
]
GaoYang commented on IOTDB-1539:
--------------------------------
Agree, it is important to prevent the deletion from continuing when paths in
where clause is not "time", or the data may be deleted abnormally.
Before the value filter feature is implemented, I will temporally try to fix
this by return an error message like "For delete statement, where clause can
only contain time expressions, value filter is not currently supported."
> The delete operation is incorrect
> ---------------------------------
>
> Key: IOTDB-1539
> URL: https://issues.apache.org/jira/browse/IOTDB-1539
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Server
> Affects Versions: 0.12.2-SNAPSHOT
> Reporter: 刘珍
> Priority: Critical
> Attachments: image-2021-07-30-16-39-20-761.png,
> image-2021-08-06-16-50-55-695.png, image-2021-08-06-16-59-04-947.png,
> image-2021-08-06-17-04-11-376.png
>
>
> iotdb
> rel/0.12 0728 88bc4289a61950cdb89c823b434931b280b98433
> cli :
> CREATE TIMESERIES root.sg1.dev1.s_1 WITH DATATYPE=INT32, ENCODING=PLAIN;
> CREATE TIMESERIES root.sg1.dev1.s_2 WITH DATATYPE=DOUBLE, ENCODING=PLAIN;
> insert into root.sg1.dev1(time,s_1,s_2 ) values(1,99,0);
> insert into root.sg1.dev1(time,s_1,s_2 ) values(2,199,0);
> insert into root.sg1.dev1(time,s_1,s_2 ) values(3,299,1000);
> insert into root.sg1.dev1(time,s_1,s_2 ) values(4,399,1000);
> insert into root.sg1.dev1(time,s_1,s_2 ) values(5,499,0);
>
> flush;
> delete from root.sg1.dev1 where s_2>0;
> {color:#DE350B}*-- All data is deleted*{color}
> -- Suggestion ： give an error or perform correctly
> !image-2021-07-30-16-39-20-761.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
