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)