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)
