Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
[复现流程]
- 配置:
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
错误结果:结果集出现乱序
Attachments
Attachments
Issue Links
- links to