Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-6299

Bug in merging overlapped data process caused by filter & offset push down

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • 1.3.1
    • 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

        Issue Links

          Activity

            People

              liuminghui Minghui Liu
              liuminghui Minghui Liu
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: