iotdb [Bug] window assigns error #11286

support natural months with fixed time other (ie. 1mo1d) base on the original and handle natural year as 12month

Now the execution result is correct

IoTDB> select * from root.hess.test.AK1407120700022.** +-----------------------------+-------------------------------------------------+---------------------------------------------------+ | Time|root.hess.test.AK1407120700022.testdata.epv_total|root.hess.test.AK1407120700022.testdata.eload_total| +-----------------------------+-------------------------------------------------+---------------------------------------------------+ |1970-01-31T00:00:00.000+08:00| 10.0| 10.0| |1970-01-31T08:00:00.000+08:00| 1.0| 1.0| |1970-02-27T23:59:59.999+08:00| 20.0| 20.0| |1970-02-28T00:00:00.000+08:00| 30.0| 30.0| |1970-02-28T07:59:59.999+08:00| 2.0| 2.0| |1970-02-28T08:00:00.000+08:00| 3.0| 3.0| |1970-03-30T23:59:59.999+08:00| 40.0| 40.0| |1970-03-31T00:00:00.000+08:00| 50.0| 50.0| |1970-03-31T07:59:59.999+08:00| 4.0| 4.0| |1970-03-31T08:00:00.000+08:00| 5.0| 5.0| +-----------------------------+-------------------------------------------------+---------------------------------------------------+ Total line number = 10 It costs 0.038s IoTDB> select SUM(epv_total) as pv,SUM(eload_total) as load from root.hess.**.AK1407120700022.** group by ([1970-02-28T08:00:00, 1970-05-31), 1mo , 2mo) +-----------------------------+----+----+ | Time| pv|load| +-----------------------------+----+----+ |1970-02-28T08:00:00.000+08:00|97.0|97.0| |1970-04-30T08:00:00.000+08:00|null|null| +-----------------------------+----+----+ Total line number = 2 It costs 0.034s IoTDB> select SUM(epv_total) as pv,SUM(eload_total) as load from root.hess.**.AK1407120700022.** group by ([1970-02-28T08:00:00, 1970-05-31), 1mo , 1mo) +-----------------------------+----+----+ | Time| pv|load| +-----------------------------+----+----+ |1970-02-28T08:00:00.000+08:00|97.0|97.0| |1970-03-31T08:00:00.000+08:00| 5.0| 5.0| |1970-04-30T08:00:00.000+08:00|null|null| +-----------------------------+----+----+ Total line number = 3 It costs 0.034s IoTDB> select SUM(epv_total) as pv,SUM(eload_total) as load from root.hess.**.AK1407120700022.** group by ([1970-02-28T08:00:00, 1970-05-31), 1mo1ms , 1mo1ms) +-----------------------------+-----+-----+ | Time| pv| load| +-----------------------------+-----+-----+ |1970-02-28T08:00:00.000+08:00|102.0|102.0| |1970-03-31T08:00:00.001+08:00| null| null| |1970-04-30T08:00:00.002+08:00| null| null| +-----------------------------+-----+-----+ Total line number = 3 It costs 0.022s IoTDB> select SUM(epv_total) as pv,SUM(eload_total) as load from root.hess.**.AK1407120700022.** group by ([1970-02-28T08:00:00, 1970-05-31), 1mo1ms , 1mo) +-----------------------------+-----+-----+ | Time| pv| load| +-----------------------------+-----+-----+ |1970-02-28T08:00:00.000+08:00|102.0|102.0| |1970-03-31T08:00:00.000+08:00| 5.0| 5.0| |1970-04-30T08:00:00.000+08:00| null| null| +-----------------------------+-----+-----+

IoTDB> select SUM(epv_total) as pv,SUM(eload_total) as load from root.hess.**.AK1407120700022.** group by ([1970-02-28T08:00:00, 1970-05-31), 1mo , 1mo1ms) +-----------------------------+----+----+ | Time| pv|load| +-----------------------------+----+----+ |1970-02-28T08:00:00.000+08:00|97.0|97.0| |1970-03-31T08:00:00.001+08:00|null|null| |1970-04-30T08:00:00.002+08:00|null|null| +-----------------------------+----+----+

Oct 12 '23 07:10 cqzhang7

I can't find some useful information, does the error need to be fixed by me?

Oct 13 '23 03:10 cqzhang7

Is anyone following up on this PR...?

Oct 27 '23 01:10 cqzhang7