[
https://issues.apache.org/jira/browse/IOTDB-3894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17570771#comment-17570771
]
Yukun Zhou commented on IOTDB-3894:
-----------------------------------
https://github.com/apache/iotdb/pull/6761
> 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
> Labels: pull-request-available
>
> 使用模板的情况下，最新点查询查询结果不正确，开启了最新点缓存.
> 场景如下:
> 创建存储组：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)
