You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2022/07/20 06:48:00 UTC
[jira] [Assigned] (IOTDB-3894) In the case that the template is used, the latest query result is incorrect
[ https://issues.apache.org/jira/browse/IOTDB-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haonan Hou reassigned IOTDB-3894:
---------------------------------
Assignee: Yukun Zhou
> In the case that the template is used, the latest query result is incorrect
> ---------------------------------------------------------------------------
>
> Key: IOTDB-3894
> URL: https://issues.apache.org/jira/browse/IOTDB-3894
> Project: Apache IoTDB
> Issue Type: Bug
> Affects Versions: 0.13.1-SNAPSHOT
> Reporter: suchenglong
> Assignee: Yukun Zhou
> Priority: Major
>
> 使用模板的情况下，最新点查询查询结果不正确，开启了最新点缓存.
> 场景如下:
> 创建存储组：root.clsu1
> 创建模板： t1(s1,int32),
> 该模板挂载到root.clsu1
> 插入一个实体和物理量
> insert into root.clsu1.device1(time,s1) values (220,200)
> 插入另一个实体和物理量
> insert into root.clsu1.device2(time,s1) values (320,200)
> 查询最新点数据，发现结果为device1的数据
> select last s1 from root.clsu1.device2
>
> 结果示例：
> IoTDB> select last s1 from root.clsu1.device1
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
> | Time| timeseries|value|dataType|
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
> |1970-01-01T08:00:00.220+08:00|root.clsu1.device1.s1| 200| INT32|
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
> Total line number = 1
> It costs 0.007s
> IoTDB> select s1 from root.clsu1.device2
> {+}----------------------------{-}{-}{+}--------------------+
> | Time|root.clsu1.device2.s1|
> {+}----------------------------{-}{-}{+}--------------------+
> |1970-01-01T08:00:00.320+08:00| 200|
> {+}----------------------------{-}{-}{+}--------------------+
> Total line number = 1
> It costs 0.012s
> IoTDB> select last s1 from root.clsu1.device2
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
> | Time| timeseries|value|dataType|
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
> |1970-01-01T08:00:00.220+08:00|root.clsu1.device2.s1| 200| INT32|
> {+}----------------------------{-}{-}{+}-------------------{-}++{-}---{-}{-}-------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)