You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "GaoYang (Jira)" <ji...@apache.org> on 2021/08/06 09:07:00 UTC
[jira] [Commented] (IOTDB-1539) The delete operation is incorrect
[ https://issues.apache.org/jira/browse/IOTDB-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17394645#comment-17394645 ]
GaoYang commented on IOTDB-1539:
--------------------------------
Also meet this problem today.
I find this in the [UserGuide|https://iotdb.apache.org/UserGuide/Master/Appendix/SQL-Reference.html]
It looks like *all conditions in the where will be treated as TimeExpr* without any prompt or error.
!image-2021-08-06-16-50-55-695.png!
And here is the code where processing delete conditions
!image-2021-08-06-16-59-04-947.png!
If datatype is not INT32 or INT64, will get this error
!image-2021-08-06-17-04-11-376.png!
> 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)