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)

Reply via email to