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

Bug in limit clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.9.0
    • None

    Description

      The test function `testQuery` in `IoTDBQueryResultSetTest.java`  construct data as following

      Object[][] input = {
          {2L, 2.22F, 40000L, null,},
          {3L, 3.33F, null, null,},
          {4L, 4.44F, null, null,},
          {50L, null, 50000L, null,},
          {100L, null, 199L, null,},
          {101L, null, 199L, null,},
          {103L, null, 199L, null,},
          {105L, 11.11F, 199L, 33333,},
          {1000L, 1000.11F, 55555L, 22222,}};
      

      and query sql is

      String testSql = "select *,s1,s0,s2 from root.vehicle.d0 where s1 > 190 or s2 < 10.0 "
          + "limit 20 offset 1 slimit 4 soffset 2";
      

      with the offset 1, we should skip the `{2L, 2.22F, 40000L, null,}`, but the expected answer doesn't do that:

      String standard =
          "Time,root.vehicle.d0.s2,root.vehicle.d0.s1,root.vehicle.d0.s0,root.vehicle.d0.s2,\n"
              + "2,2.22,40000,null,2.22,\n"
              + "3,3.33,null,null,3.33,\n"
              + "4,4.44,null,null,4.44,\n"
              + "50,null,50000,null,null,\n"
              + "100,null,199,null,null,\n"
              + "101,null,199,null,null,\n"
              + "103,null,199,null,null,\n"
              + "105,11.11,199,33333,11.11,\n"
              + "1000,1000.11,55555,22222,1000.11,\n";
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jackietien Yuan Tian
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m