Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
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
- links to