[
https://issues.apache.org/jira/browse/IOTDB-2450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17479118#comment-17479118
]
FengQingxin commented on IOTDB-2450:
------------------------------------
数据错误导致，写入程序没有达到预期效果。
所以导致查询语句select min_value(s_13) from root.test.g_0.* group by ([now()-60s ,
now()),10s);出现某一段时间全部是空值；
确认方式：
不再执行最新数据查询，在一段时间上来做查询：数据时间段 2022-01-20T14:38:43.000+08:00 ~
2022-01-20T14:39:02.000+08:00 20秒的数据，之后无值
!image-2022-01-20-14-41-37-336.png!
通过后不断变化SQL语句查询窗口，确认当一段时间全部为NULL是结果为NULL，有数据则参考数据计算结果
!image-2022-01-20-14-42-27-127.png!
> Wrong result when query with 'null' value
> -----------------------------------------
>
> Key: IOTDB-2450
> URL: https://issues.apache.org/jira/browse/IOTDB-2450
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Query
> Affects Versions: 0.13.0-SNAPSHOT
> Reporter: FengQingxin
> Assignee: Minghui Liu
> Priority: Blocker
> Attachments: image-2022-01-20-11-08-25-795.png,
> image-2022-01-20-11-09-26-797.png, image-2022-01-20-11-09-40-754.png,
> image-2022-01-20-11-21-16-831.png, image-2022-01-20-14-41-37-336.png,
> image-2022-01-20-14-42-27-127.png
>
>
> 原始数据（20秒）
> !image-2022-01-20-11-08-25-795.png!
> 按10秒聚合查询最大、最小、平均结果都返回前十秒正确值，后十秒NULL（错误值）
> !image-2022-01-20-11-09-26-797.png!
> !image-2022-01-20-11-09-40-754.png!
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
