[Bug] query by limit offset missing records

[onlylin]

Search before asking

• I searched in the issues and found nothing similar.

Version

v1.1.0

Describe the bug and provide the minimal reproduce step

query sql statement

SELECT * FROM root.p_95.d_9081.SQ order by time desc limit 30 offset 0 align by device

and

SELECT * FROM root.p_95.d_9081.SQ order by time desc limit 20 offset 0 align by device

What did you expect to see?

The first 20 pieces of data should be the same

What did you see instead?

missing records 2023-06-02T09:00:01.000+08:00 and 2023-06-02T08:50:01.000+08:00

Anything else?

No response

Are you willing to submit a PR?

• I'm willing to submit a PR!

[github-actions]

Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!

[liuminghui233]

Fixed by #9437