This is an automated email from the ASF dual-hosted git repository. hui pushed a commit to branch lmh/fixLimitOffsetPushdown in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 83db4c30d4fc73907defca6e24070c518ab716ec Author: Minghui Liu <[email protected]> AuthorDate: Sun Jun 9 23:48:33 2024 +0800 add more IT --- .../db/it/aligned/IoTDBPredicatePushDownIT.java | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) diff --git a/integration-test/src/test/java/org/apache/iotdb/db/it/aligned/IoTDBPredicatePushDownIT.java b/integration-test/src/test/java/org/apache/iotdb/db/it/aligned/IoTDBPredicatePushDownIT.java index 4d3ff5120df..1a65682fc5b 100644 --- a/integration-test/src/test/java/org/apache/iotdb/db/it/aligned/IoTDBPredicatePushDownIT.java +++ b/integration-test/src/test/java/org/apache/iotdb/db/it/aligned/IoTDBPredicatePushDownIT.java @@ -91,6 +91,13 @@ public class IoTDBPredicatePushDownIT { }; resultSetEqualTest( "select s2 from root.sg1.d1 where s2 - 1 >= 9 and s2 < 30", expectedHeader3, retArray3); + + String expectedHeader4 = "Time,root.sg1.d1.s2,"; + String[] retArray4 = new String[] {"14,14,", "15,15,"}; + resultSetEqualTest( + "select s2 from root.sg1.d1 where s2 - 1 >= 9 and s2 < 30 offset 3 limit 2", + expectedHeader4, + retArray4); } @Test @@ -164,6 +171,11 @@ public class IoTDBPredicatePushDownIT { "30,30,", }; resultSetEqualTest("select s3 from root.sg1.d1 where s3 + 1 > 16", expectedHeader3, retArray3); + + String expectedHeader4 = "Time,root.sg1.d1.s3,"; + String[] retArray4 = new String[] {"3,30000,", "13,130000,", "16,16,"}; + resultSetEqualTest( + "select s3 from root.sg1.d1 where s3 + 1 > 16 limit 3", expectedHeader4, retArray4); } @Test @@ -203,6 +215,13 @@ public class IoTDBPredicatePushDownIT { }; resultSetEqualTest( "select s2 from root.sg1.d2 where s2 - 1 >= 9 and s2 < 30", expectedHeader3, retArray3); + + String expectedHeader4 = "Time,root.sg1.d2.s2,"; + String[] retArray4 = new String[] {"12,12,", "13,13,", "14,14,"}; + resultSetEqualTest( + "select s2 from root.sg1.d2 where s2 - 1 >= 9 and s2 < 30 limit 3 offset 2", + expectedHeader4, + retArray4); } @Test @@ -257,6 +276,14 @@ public class IoTDBPredicatePushDownIT { "25,25,", "26,26,", "27,27,", "28,28,", "29,29,", "30,30,", }; resultSetEqualTest("select s3 from root.sg1.d2 where s3 + 1 > 16", expectedHeader3, retArray3); + + String expectedHeader4 = "Time,root.sg1.d2.s3,"; + String[] retArray4 = + new String[] { + "26,26,", "27,27,", "28,28,", "29,29,", "30,30,", + }; + resultSetEqualTest( + "select s3 from root.sg1.d2 where s3 + 1 > 16 offset 10", expectedHeader4, retArray4); } @Test
