Minghui Liu created IOTDB-6299:
----------------------------------

             Summary: Bug in merging overlapped data process caused by filter & 
offset push down
                 Key: IOTDB-6299
                 URL: https://issues.apache.org/jira/browse/IOTDB-6299
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: Minghui Liu
            Assignee: Minghui Liu
             Fix For: 0.13.1
         Attachments: image-2024-02-22-17-37-01-126.png

*[复现流程]*
 * *配置:*
maxNumberOfPointsInPage = 2
maxTsBlockLineNumber = 3

 * *写入数据:*
CREATE DATABASE root.sg1;
create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32 
encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);insert into 
root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9, 9.0, 9, 9, FALSE, 
'aligned_test9');insert into root.sg1.d1(time, s2, s3, s4, s5) aligned 
values(10, 10, 10, TRUE, 'aligned_test10');
flush;insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 
11);insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 
12);insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 
13);insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 
14);insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 
15);insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 
16);insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 
17);insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 
18);insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 
19);insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
flush;insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13, 
130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
flush;
 
 * *执行查询:*
select * from root.sg1.d1 where time >= 9 and time <= 33 offset 5 limit 5
 错误结果:结果集出现乱序 !image-2024-02-22-17-37-01-126.png|width=474,height=120!



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

Reply via email to