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)