Yuan Tian created IOTDB-6338:
--------------------------------

             Summary: Wrong query result while using some value filter + limit
                 Key: IOTDB-6338
                 URL: https://issues.apache.org/jira/browse/IOTDB-6338
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
            Reporter: Yuan Tian
         Attachments: image-2024-06-07-16-00-07-249.png

To replay, using the following sqls:

```
insert into root.db.d1(time, s1, s2) aligned values(now(), 1, 1);
insert into root.db.d1(time, s1, s2) aligned values(now(), 2, 2);
insert into root.db.d1(time, s1, s2) aligned values(now(), 3, 3);
insert into root.db.d1(time, s1, s2) aligned values(now(), 4, 40);
insert into root.db.d1(time, s1, s2) aligned values(now(), 5, 50);
insert into root.db.d1(time, s1, s2) aligned values(now(), 6, 60);
select s1, s2 from root.db.d1 where s1 != s2 limit 1;
```

 

we expect to get the line `4, 40`, but in current version, we got empty result 
set which is wrong.

!image-2024-06-07-16-00-07-249.png!

 



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

Reply via email to