[
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)
