You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "onlylin (via GitHub)" <gi...@apache.org> on 2023/06/02 08:37:09 UTC
[GitHub] [iotdb] onlylin opened a new issue, #10037: [Bug] query by limit offset missing records
onlylin opened a new issue, #10037:
URL: https://github.com/apache/iotdb/issues/10037
### Search before asking
- [X] I searched in the [issues](https://github.com/apache/iotdb/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?
<img width="744" alt="image" src="https://github.com/apache/iotdb/assets/3665406/6dcd44d8-ac06-4b04-a39a-fc14006ed0eb">
<img width="750" alt="image" src="https://github.com/apache/iotdb/assets/3665406/553b5a66-f8ad-41dc-9ebe-ccdcd9004b5a">
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!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] github-actions[bot] commented on issue #10037: [Bug] query by limit offset missing records
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #10037:
URL: https://github.com/apache/iotdb/issues/10037#issuecomment-1573368339
Hi, this is your first issue in IoTDB project. Thanks for your report. Welcome to join the community!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] liuminghui233 commented on issue #10037: [Bug] query by limit offset missing records
Posted by "liuminghui233 (via GitHub)" <gi...@apache.org>.
liuminghui233 commented on issue #10037:
URL: https://github.com/apache/iotdb/issues/10037#issuecomment-1582010065
Fixed by #9437
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] jixuan1989 closed issue #10037: [Bug] query by limit offset missing records
Posted by "jixuan1989 (via GitHub)" <gi...@apache.org>.
jixuan1989 closed issue #10037: [Bug] query by limit offset missing records
URL: https://github.com/apache/iotdb/issues/10037
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org