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)

Reply via email to