[
https://issues.apache.org/jira/browse/IOTDB-6338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yuan Tian reassigned IOTDB-6338:
--------------------------------
Assignee: Minghui Liu
> 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
> Assignee: Minghui Liu
> Priority: Major
> 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)
