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

Incorrect result when querying with offset push-down and time filter

    XMLWordPrintableJSON

Details

    Description

      CREATE DATABASE root.db;
      CREATE TIMESERIES root.db.d1.s1 INT32;
      insert into root.db.d1(timestamp,s1) values(0, 0);
      insert into root.db.d1(timestamp,s1) values(1, 1);
      insert into root.db.d1(timestamp,s1) values(2, 2);
      insert into root.db.d1(timestamp,s1) values(3, 3);
      insert into root.db.d1(timestamp,s1) values(4, 4);
      flush;
      insert into root.db.d1(timestamp,s1) values(5, 5);
      insert into root.db.d1(timestamp,s1) values(6, 6);
      insert into root.db.d1(timestamp,s1) values(7, 7);
      insert into root.db.d1(timestamp,s1) values(8, 8);
      insert into root.db.d1(timestamp,s1) values(9, 9);
      flush;
      insert into root.db.d1(timestamp,s1) values(10, 10);
      insert into root.db.d1(timestamp,s1) values(11, 11);
      insert into root.db.d1(timestamp,s1) values(12, 12);
      insert into root.db.d1(timestamp,s1) values(13, 13);
      insert into root.db.d1(timestamp,s1) values(14, 14);
      select s1 from root.db.d1 where time > 1 offset 5 limit 1;

      Expected:

      Actual:

       

      Attachments

        1. image-2023-04-18-09-49-11-102.png
          30 kB
          Minghui Liu
        2. image-2023-04-18-09-49-46-597.png
          31 kB
          Minghui Liu

        Activity

          People

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

            Dates

              Created:
              Updated: