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)