You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "Minghui Liu (Jira)" <ji...@apache.org> on 2022/10/27 13:14:00 UTC

[jira] [Created] (IOTDB-4781) The NOT LIKE value filter does not work

Minghui Liu created IOTDB-4781:
----------------------------------

             Summary: The NOT LIKE value filter does not work
                 Key: IOTDB-4781
                 URL: https://issues.apache.org/jira/browse/IOTDB-4781
             Project: Apache IoTDB
          Issue Type: Bug
    Affects Versions: 0.13.3-SNAPSHOT
            Reporter: Minghui Liu
            Assignee: Minghui Liu
             Fix For: 0.13.3-SNAPSHOT
         Attachments: image-2022-10-27-21-07-19-702.png, image-2022-10-27-21-07-33-928.png, image-2022-10-27-21-12-53-897.png

insert into root.t1.wf01.wt01 (time,status) values (1509465600000,'1');
insert into root.t1.wf01.wt01 (time,status) values (1509465660000,'14');
insert into root.t1.wf01.wt01 (time,status) values (1509465720000,'616');
insert into root.t1.wf01.wt01 (time,status) values (1509465780000,'626');
insert into root.t1.wf01.wt01 (time,status) values (1509465840000,'6116');
insert into root.t1.wf01.wt01 (time,status) values (1509465900000,'6%16');
insert into root.t1.wf01.wt01 (time,status) values (1509465960000,'8[sS]*');
insert into root.t1.wf01.wt01 (time,status) values (1509466020000,'%123');
insert into root.t1.wf01.wt01 (time,status) values (1509466080000,'123%');
insert into root.t1.wf01.wt01 (time,status) values (1509466090000,'\\\\');

select status from root.t1.wf01.wt01 where status like '6%6';
!image-2022-10-27-21-07-19-702.png|width=413,height=200!

select status from root.t1.wf01.wt01 where not (status like '6%6');
!image-2022-10-27-21-07-33-928.png|width=421,height=185!

 

Fixed:

!image-2022-10-27-21-12-53-897.png|width=381,height=194!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)