You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2022/08/09 05:26:54 UTC
[GitHub] [iotdb] panlw opened a new issue, #6925: `select last`查询结果有问题
panlw opened a new issue, #6925:
URL: https://github.com/apache/iotdb/issues/6925
# `select last`查询结果有问题
> IoTDB 服务版本: 0.13.0
`select query` 查询结果与预期的不符，下面的两个查询，不加`last`都是 ok 的，对`dk2`做了一次`select last`发现其返回的数据不对，似乎它返回的是`dk1`的数据。
```
IoTDB> select iot_sts from root.t1.mk1.sts.dk1;
+------------------------+---------------------------+
| Time|root.t1.mk1.sts.dk1.iot_sts|
+------------------------+---------------------------+
|2022-08-09T05:00:15.156Z| true|
+------------------------+---------------------------+
Total line number = 1
It costs 0.012s
IoTDB> select iot_sts from root.t1.mk1.sts.dk2;
+------------------------+---------------------------+
| Time|root.t1.mk1.sts.dk2.iot_sts|
+------------------------+---------------------------+
|2022-08-09T05:10:50.221Z| false|
+------------------------+---------------------------+
Total line number = 1
It costs 0.018s
IoTDB> select last iot_sts from root.t1.mk1.sts.dk2;
+------------------------+---------------------------+-----+--------+
| Time| timeseries|value|dataType|
+------------------------+---------------------------+-----+--------+
|2022-08-09T05:00:15.156Z|root.t1.mk1.sts.dk2.iot_sts| true| BOOLEAN|
+------------------------+---------------------------+-----+--------+
Total line number = 1
It costs 0.018s
IoTDB>
```
--
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 #6925: `select last`查询结果有问题
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6925:
URL: https://github.com/apache/iotdb/issues/6925#issuecomment-1208941684
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] panlw commented on issue #6925: `select last`查询结果有问题
Posted by GitBox <gi...@apache.org>.
panlw commented on issue #6925:
URL: https://github.com/apache/iotdb/issues/6925#issuecomment-1209088710
升级到 0.13.1，确认了下，问题已解决 :-)
--
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] HTHou commented on issue #6925: `select last`查询结果有问题
Posted by GitBox <gi...@apache.org>.
HTHou commented on issue #6925:
URL: https://github.com/apache/iotdb/issues/6925#issuecomment-1209060713
@panlw 这里是不是使用了模版，如果是，可以更新一下0.13.1版本，这个bug已经修复了。
--
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] panlw closed issue #6925: `select last`查询结果有问题
Posted by GitBox <gi...@apache.org>.
panlw closed issue #6925: `select last`查询结果有问题
URL: https://github.com/apache/iotdb/issues/6925
--
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] Haze-Lan commented on issue #6925: `select last`查询结果有问题
Posted by GitBox <gi...@apache.org>.
Haze-Lan commented on issue #6925:
URL: https://github.com/apache/iotdb/issues/6925#issuecomment-1209002026
确实有问题
这个是直接通过cli查询的值
这个是通过执行代码dataIterator.getString(3)获取到的值，这个值的类型是int64
这个是通过执行代码dataIterator.getLong(3)获取到的值，跟数据库存的完全不一样
--
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