[IOTDB-6254] Missing some data points while using limit in aligned sensor cases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master
• Fix Version/s: master branch
• Component/s: Core/Query
• Labels: pull-request-available
• Assignee: Yuan Tian
• Reporter: Yuan Tian
• Created: 22/Nov/23 12:30
• Updated: 23/Nov/23 01:22
• Resolved: 23/Nov/23 01:22

Description

using the following sqls, you can replay the case:

```
insert into root.db.d1(time,s1,s2) aligned values(1,1,1);
insert into root.db.d1(time,s1,s2) aligned values(2,2,2);
insert into root.db.d1(time,s1,s2) aligned values(3,3,3);
insert into root.db.d1(time,s1,s2) aligned values(4,4,4);
flush;
```

 

if you execute `select s1 from root.db.d1 where time >= 3 limit 2;`, you will get empty result.

 

Issue Links

• links to: GitHub Pull Request #11599