Yuan Tian created IOTDB-6350:
--------------------------------

             Summary: Null values are not filtered out by in filter
                 Key: IOTDB-6350
                 URL: https://issues.apache.org/jira/browse/IOTDB-6350
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
            Reporter: Yuan Tian
            Assignee: Yuan Tian
         Attachments: image-2024-08-29-15-17-58-608.png

```
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);
```

!image-2024-08-29-15-17-58-608.png!



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

Reply via email to