yang caiyin created IOTDB-6274:
----------------------------------
Summary: 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
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)