Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-4781

[Query] The NOT LIKE value filter does not work

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.0
    • 0.13.4
    • None
    • 2022-10-Cluster

    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:

      Attachments

        1. image-2022-10-27-21-12-53-897.png
          46 kB
          Minghui Liu
        2. image-2022-10-27-21-07-33-928.png
          39 kB
          Minghui Liu
        3. image-2022-10-27-21-07-19-702.png
          38 kB
          Minghui Liu

        Issue Links

          Activity

            People

              liuminghui Minghui Liu
              liuminghui Minghui Liu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: