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

Wrong query result while using some value filter + limit

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Core/Query

    Description

      To replay, using the following sqls:

      ```
      insert into root.db.d1(time, s1, s2) aligned values(now(), 1, 1);
      insert into root.db.d1(time, s1, s2) aligned values(now(), 2, 2);
      insert into root.db.d1(time, s1, s2) aligned values(now(), 3, 3);
      insert into root.db.d1(time, s1, s2) aligned values(now(), 4, 40);
      insert into root.db.d1(time, s1, s2) aligned values(now(), 5, 50);
      insert into root.db.d1(time, s1, s2) aligned values(now(), 6, 60);
      select s1, s2 from root.db.d1 where s1 != s2 limit 1;
      ```

       

      we expect to get the line `4, 40`, but in current version, we got empty result set which is wrong.

       

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: