[ https://issues.apache.org/jira/browse/IOTDB-6299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17819549#comment-17819549 ]
Minghui Liu commented on IOTDB-6299: ------------------------------------ 修复 PR:https://github.com/apache/iotdb/pull/12068 > 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 > Priority: Major > Fix For: 1.3.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)