[IOTDB-4781] [Query] The NOT LIKE value filter does not work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.13.4
• Labels: pull-request-available
• Sprint: 2022-10-Cluster
• Assignee: Minghui Liu
• Reporter: Minghui Liu
• Created: 27/Oct/22 13:13
• Updated: 28/Oct/22 02:44
• Resolved: 28/Oct/22 02:44

Description

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';

select status from root.t1.wf01.wt01 where not (status like '6%6');

 

Fixed:

Issue Links

• links to: GitHub Pull Request #7764