This is an automated email from the ASF dual-hosted git repository. jackietien pushed a commit to branch ty/fixLimitPushDown in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit cb6d9c66a8b959d9a49ea8471da46c781c9f6c82 Merge: 269e4a4c6a5 2488001e808 Author: JackieTien97 <[email protected]> AuthorDate: Tue Nov 4 11:50:12 2025 +0800 resolve conflicts .../test/java/org/apache/iotdb/db/it/IoTDBFilterIT.java | 14 ++++++++++++++ .../it/query/recent/IoTDBTableAggregationIT.java | 11 +++++++++++ .../execution/operator/source/SeriesScanUtil.java | 5 +++++ .../db/storageengine/dataregion/read/QueryDataSource.java | 5 +++++ 4 files changed, 35 insertions(+) diff --cc integration-test/src/test/java/org/apache/iotdb/relational/it/query/recent/IoTDBTableAggregationIT.java index 605c8973192,0143bdb6e3b..88367283eb7 --- a/integration-test/src/test/java/org/apache/iotdb/relational/it/query/recent/IoTDBTableAggregationIT.java +++ b/integration-test/src/test/java/org/apache/iotdb/relational/it/query/recent/IoTDBTableAggregationIT.java @@@ -5481,16 -5481,14 +5481,27 @@@ public class IoTDBTableAggregationIT DATABASE_NAME); } + @Test + public void emptyTimeRangeQueryTest() { + String[] expectedHeader = new String[] {"_col0"}; + String[] retArray = new String[] {"0,"}; + tableResultSetEqualTest( + "select count(*) from table1 where time >= 0 and time < -1", + expectedHeader, + retArray, + DATABASE_NAME); + } ++ + @Test + public void orderByLimitTest() { + String[] expectedHeader = + new String[] {"province", "city", "region", "device_id", "_col4", "_col5"}; + String[] retArray = new String[] {"beijing,beijing,chaoyang,d09,2024-09-24T06:00:00.000Z,2,"}; + + tableResultSetEqualTest( + "select province, city, region, device_id, date_bin(1h, time), count(s1) from table1 where s1 >= 40 group by 1,2,3,4,5 order by province, city, region, device_id, date_bin(1h, time) limit 1", + expectedHeader, + retArray, + DATABASE_NAME); + } }
