This is an automated email from the ASF dual-hosted git repository. hui pushed a commit to branch lmh/udfSemanticCheck in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 3c209543be271b8dc851161686b3542f2dfd3f42 Author: Minghui Liu <[email protected]> AuthorDate: Mon Jun 27 23:29:47 2022 +0800 add more test --- .../iotdb/db/it/udf/IoTDBUDTFHybridQueryIT.java | 34 ++++++++++++++++++++++ 1 file changed, 34 insertions(+) diff --git a/integration-test/src/test/java/org/apache/iotdb/db/it/udf/IoTDBUDTFHybridQueryIT.java b/integration-test/src/test/java/org/apache/iotdb/db/it/udf/IoTDBUDTFHybridQueryIT.java index 488ccd2ed3..05d7360768 100644 --- a/integration-test/src/test/java/org/apache/iotdb/db/it/udf/IoTDBUDTFHybridQueryIT.java +++ b/integration-test/src/test/java/org/apache/iotdb/db/it/udf/IoTDBUDTFHybridQueryIT.java @@ -124,6 +124,40 @@ public class IoTDBUDTFHybridQueryIT { } } + @Test + public void testUserDefinedBuiltInHybridAggregationQuery2() { + String[] retArray = new String[] {"0,2.0,0.9092974268256817,3.0,-10.0,12.0"}; + + try (Connection connection = EnvFactory.getEnv().getConnection(); + Statement statement = connection.createStatement()) { + try (ResultSet resultSet = + statement.executeQuery( + "select avg(s1), sin(avg(s2)), avg(s1) + 1, -sum(s2), avg(s1) + sum(s2) from root.vehicle.d1")) { + int cnt = 0; + while (resultSet.next()) { + String ans = + resultSet.getString(TIMESTAMP_STR) + + "," + + resultSet.getString("avg(root.vehicle.d1.s1)") + + "," + + resultSet.getString("sin(avg(root.vehicle.d1.s2))") + + "," + + resultSet.getString("avg(root.vehicle.d1.s1) + 1") + + "," + + resultSet.getString("-sum(root.vehicle.d1.s2)") + + "," + + resultSet.getString("avg(root.vehicle.d1.s1) + sum(root.vehicle.d1.s2)"); + assertEquals(retArray[cnt], ans); + cnt++; + } + assertEquals(retArray.length, cnt); + } + } catch (SQLException throwable) { + throwable.printStackTrace(); + fail(throwable.getMessage()); + } + } + @Test @Ignore // TODO fill function incompatible public void testUserDefinedFunctionFillFunctionHybridQuery() {
