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)