Minghui Liu created IOTDB-4215:
----------------------------------

             Summary: Incorrect aggregate query results due to wrong unseq file 
traversal order
                 Key: IOTDB-4215
                 URL: https://issues.apache.org/jira/browse/IOTDB-4215
             Project: Apache IoTDB
          Issue Type: Improvement
            Reporter: Minghui Liu
            Assignee: Minghui Liu
             Fix For: master branch, 0.12.5-SNAPSHOT, 0.13.1-SNAPSHOT


*sqls:*

insert into root.sg1.d1(time, s1) values (12, 12);
flush;
insert into root.sg1.d1(time, s2) values (30, 30);
flush;
insert into root.sg1.d1(time, s1) values (0, 0);
insert into root.sg1.d1(time, s1) values (8, 8);
flush;
insert into root.sg1.d1(time, s1) values (0, 0);
insert into root.sg1.d1(time, s1) values (10, 10);
flush;
insert into root.sg1.d1(time, s1) values (17, 17);
insert into root.sg1.d1(time, s1) values (20, 20);
flush;

select first_value(s1), last_value(s1) from root.sg1.d1;

select first_value(s1), last_value(s1) from root.sg1.d1 order by desc;

 

*actual:*

0.0, 12.0

12.0 20.0

 

*expected:*

0.0, 20.0

0.0, 20.0



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

Reply via email to