Minghui Liu created IOTDB-3724:
----------------------------------

             Summary: Incorrect result when querying with linear fill & order 
by time desc
                 Key: IOTDB-3724
                 URL: https://issues.apache.org/jira/browse/IOTDB-3724
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: Minghui Liu
            Assignee: Yuan Tian
             Fix For: 0.14.0-SNAPSHOT
         Attachments: image-2022-07-01-21-08-43-242.png, 
image-2022-07-01-21-08-49-996.png

SQL:

SET STORAGE GROUP TO root.sg1;
create aligned timeseries root.sg1.d1(s1 INT32, s2 INT64, s3 FLOAT, s4 DOUBLE, 
s5 BOOLEAN, s6 TEXT);
insert into root.sg1.d1(time, s2, s4, s6) aligned values(1, 1, 1.0, 't1');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5, s6) aligned values(2, 2, 2, 
2.0, 2.0, true, 't2');
insert into root.sg1.d1(time, s1, s3, s5) aligned values(3, 3, 3.0, false);
insert into root.sg1.d1(time, s2, s4, s6) aligned values(4, 4, 4.0, 't4');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5, s6) aligned values(5, 5, 5, 
5.0, 5.0, false, 't5');
insert into root.sg1.d1(time, s2, s4, s6) aligned values(6, 6, 6.0, 't6');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5, s6) aligned values(8, 8, 8, 
8.0, 8.0, true, 't8');
insert into root.sg1.d1(time, s1, s3, s5) aligned values(9, 9, 9.0, true);

select s1, s2, s3, s4 from root.sg1.d1 fill(linear) order by time desc;

 

!image-2022-07-01-21-05-19-464.png|width=358,height=162!

 

!image-2022-07-01-21-05-30-630.png|width=481,height=448!

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to