Yuan Tian created IOTDB-1387: -------------------------------- Summary: Without Null ALL doesn't take effect in align by device clause Key: IOTDB-1387 URL: https://issues.apache.org/jira/browse/IOTDB-1387 Project: Apache IoTDB Issue Type: Bug Components: Core/Engine Reporter: Yuan Tian Assignee: Yuan Tian Attachments: image-2021-05-21-15-30-19-233.png
The insert sql as following: insert into root.sg1.d1(time,s1) values (1,1); insert into root.sg1.d2(time,s1) values (1,1); insert into root.sg1.d3(time,s1) values (1,1); The query sql is: select first_value(s1) from root.sg1.* group by ([1, 10), 1ms) order by time desc without null all limit 2 align by device; The result set is: !image-2021-05-21-15-30-19-233.png! The result set still contains null -- This message was sent by Atlassian Jira (v8.3.4#803005)