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

Null values are not filtered out by in filter

    XMLWordPrintableJSON

Details

    Description

      ```
      CREATE DATABASE root.testNullFilter;
      CREATE ALIGNED TIMESERIES root.testNullFilter.d2(s1 INT32, s2 BOOLEAN, s3 DOUBLE);
      INSERT INTO root.testNullFilter.d2(timestamp,s2,s3) values(1, false, 11.1);
      INSERT INTO root.testNullFilter.d2(timestamp,s1,s2) values(2, 22, true);
      INSERT INTO root.testNullFilter.d2(timestamp,s1,s2) values(3, 22, false);
      select * from root.testNullFilter.d2 where s1 in (22, 23);
      ```

      Attachments

        Issue Links

          Activity

            People

              jackietien Yuan Tian
              jackietien Yuan Tian
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: