[IOTDB-5891] Fill null value order by query meet exceptions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master
• Component/s: Core/Query
• Assignee: yang caiyin
• Reporter: xiaozhihong
• Created: 17/May/23 08:01
• Updated: 29/May/23 05:51
• Resolved: 29/May/23 05:51

Description

Branch : Master 

commit ab43262e3974574334ca7ff131e8d11e7f5da69f

Fill null value order by query meet exceptions.

IoTDB> select s1, s3 from root.sg.d1 where time >= 1 and time <= 10 fill(previous);
+-----------------------------+-------------+-------------+
|                         Time|root.sg.d1.s1|root.sg.d1.s3|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00|            1|          1.1|
|1970-01-01T08:00:00.002+08:00|            2|          2.2|
|1970-01-01T08:00:00.003+08:00|            3|          2.2|
|1970-01-01T08:00:00.004+08:00|            4|          4.4|
|1970-01-01T08:00:00.005+08:00|            5|          5.5|
|1970-01-01T08:00:00.006+08:00|            6|          5.5|
|1970-01-01T08:00:00.007+08:00|            7|        100.1|
|1970-01-01T08:00:00.008+08:00|           55|          0.0|
|1970-01-01T08:00:00.009+08:00|          -15|          0.0|
|1970-01-01T08:00:00.010+08:00|            0|         10.1|
+-----------------------------+-------------+-------------+
Total line number = 10
It costs 0.014s
IoTDB> select s1, s3 from root.sg.d1 where time >= 1 and time <= 10 fill(previous) order by s2,time desc align by device;
Msg: 301: There is not enough memory to execute current fragment instance, current remaining free memory is 122812237, estimated memory usage for current fragment instance is 158203904
 

Issue Links

• links to: github pr