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 269e4a4c6a5e7329f8cfde30d6da2ffa171bd10e Author: JackieTien97 <[email protected]> AuthorDate: Tue Nov 4 11:32:11 2025 +0800 Add IT --- .../relational/it/query/recent/IoTDBTableAggregationIT.java | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git 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 index c6e5fc138ce..605c8973192 100644 --- 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 @@ -5480,4 +5480,17 @@ public class IoTDBTableAggregationIT { 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); + } }
