[
https://issues.apache.org/jira/browse/IOTDB-6274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yang caiyin reassigned IOTDB-6274:
----------------------------------
Assignee: yang caiyin
> Bug in Group by month
> ---------------------
>
> Key: IOTDB-6274
> URL: https://issues.apache.org/jira/browse/IOTDB-6274
> Project: Apache IoTDB
> Issue Type: Bug
> Reporter: yang caiyin
> Assignee: yang caiyin
> Priority: Major
> Attachments: image-2023-12-21-18-01-42-411.png
>
>
> # can't query with group by month + limit/offset
> # Group by month calculate the wrong results.
> # Can't use __endTime in GROUP BY TIME + ALIGN BY DEVICE
>
> The right way to calcute the time results in group by month should be
> (startTime + count*MonDuration + nonMonDuration*count, endTime +
> (count+intervalNum)*MonDuration + nonMonDuration*(count+intervalNum)] which
> can't be accumulative.
> Example(red is the right result):
> !image-2023-12-21-18-01-42-411.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
