You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2022/06/04 05:31:54 UTC

[incubator-doris] branch master updated: [test]Add regression test method for agg function (#9929)

This is an automated email from the ASF dual-hosted git repository.

yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 26ea51da00 [test]Add regression test method for agg function (#9929)
26ea51da00 is described below

commit 26ea51da00b40135ceec9948c1e1112812ae77c0
Author: FreeOnePlus <54...@users.noreply.github.com>
AuthorDate: Sat Jun 4 13:31:48 2022 +0800

    [test]Add regression test method for agg function (#9929)
    
    * Add regression test method for regression function
    
    * Add regression test method for regression function
    
    * Add regression test case for math function
    
    * delete math function
    
    Co-authored-by: manyi <fo...@freeoneplus.com>
---
 .../test_aggregate_all_functions.out               | 166 ++++++++
 .../test_aggregate_all_functions.groovy            | 463 +++++++++++++++++++++
 2 files changed, 629 insertions(+)

diff --git a/regression-test/data/query/sql_functions/aggregate_functions/test_aggregate_all_functions.out b/regression-test/data/query/sql_functions/aggregate_functions/test_aggregate_all_functions.out
new file mode 100644
index 0000000000..bb6a1de556
--- /dev/null
+++ b/regression-test/data/query/sql_functions/aggregate_functions/test_aggregate_all_functions.out
@@ -0,0 +1,166 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !select1 --
+1
+2
+-- !select2 --
+beijing	100
+xian	100
+-- !select3 --
+beijing	100
+xian	100
+-- !select4 --
+3
+-- !select5 --
+3
+-- !select6 --
+beijing	3
+xian	3
+-- !select7 --
+beijing	3
+xian	3
+-- !select8 --
+beijing	3
+xian	2
+-- !select9 --
+beijing, xian, beijing, chengdu, shanghai
+-- !select10 --
+beijing xian beijing chengdu shanghai
+-- !select11 --
+\\N
+-- !select12 --
+beijing, xian
+beijing, chengdu, shanghai
+-- !select13 --
+beijing xian
+beijing chengdu shanghai
+-- !select14 --
+\\N
+\\N
+-- !select15 --
+1	1
+2	1
+4	1
+5	1
+6	1
+-- !select16 --
+1	10
+2	441
+3	10
+5	29
+6	101
+-- !select17 --
+441
+-- !select18 --
+1	10
+2	8
+3	10
+5	29
+6	101
+-- !select19 --
+8
+-- !select20 --
+1	10
+2	224.5
+3	10
+5	29
+6	101
+-- !select21 --
+1	10
+2	246.15
+3	10
+5	29
+6	101
+-- !select22 --
+1	10
+2	356.565
+3	10
+5	29
+6	101
+-- !select23 --
+1	10
+2	224.5
+3	10
+5	29
+6	101
+-- !select24 --
+1	10
+2	267.80001831054688
+3	10
+5	29
+6	101
+-- !select25 --
+1	10
+2	441
+3	10
+5	29
+6	101
+-- !select26 --
+1	10
+2	224.5
+3	10
+5	29
+6	101
+-- !select27 --
+1	10
+2	267.80001831054688
+3	10
+5	29
+6	101
+-- !select28 --
+1	10
+2	441
+3	10
+5	29
+6	101
+-- !select29 --
+1	0
+2	216.5
+3	36
+-- !select30 --
+1	0
+2	216.5
+3	36
+-- !select31 --
+1	0
+2	306.17723625377511
+3	50.911688245431421
+-- !select32 --
+1	20
+2	449
+3	130
+-- !select33 --
+599
+-- !select34 --
+1	{"10":2,"13":1}
+2	{"18":2,"441":1}
+3	{"4":1,"29":1}
+-- !select35 --
+1	{"10":2,"13":1}
+2	{"18":2,"441":1}
+3	{"4":1,"29":1}
+-- !select36 --
+{"18":2,"10":2}
+-- !select37 --
+1	0
+2	93744.5
+3	2592
+-- !select38 --
+1	0
+2	93744.5
+3	2592
+-- !select39 --
+1	0
+2	46872.25
+3	1296
+-- !select40 --
+1	0
+2	46872.25
+3	1296
+-- !select41 --
+1	0
+2	46872.25
+3	1296
+-- !select42 --
+2
+-- !select43 --
+2
diff --git a/regression-test/suites/query/sql_functions/aggregate_functions/test_aggregate_all_functions.groovy b/regression-test/suites/query/sql_functions/aggregate_functions/test_aggregate_all_functions.groovy
new file mode 100644
index 0000000000..80b4d5777a
--- /dev/null
+++ b/regression-test/suites/query/sql_functions/aggregate_functions/test_aggregate_all_functions.groovy
@@ -0,0 +1,463 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("sql_action", "query") {
+
+    sql "set enable_vectorized_engine = true"
+    sql "set batch_size = 4096"
+    
+    // APPROX_COUNT_DISTINCT_ACTION
+    def tableName_01 = "approx_count_distince"
+    sql "DROP TABLE IF EXISTS ${tableName_01}"
+    sql """
+	    CREATE TABLE IF NOT EXISTS ${tableName_01} (
+	        id int,
+	        group_type VARCHAR(10)
+	    )
+	    DISTRIBUTED BY HASH(id) BUCKETS 1
+	    PROPERTIES (
+	      "replication_num" = "1"
+	    ) 
+           """
+    sql "INSERT INTO ${tableName_01} values(1,'beijing'), (2,'xian'), (3,'xian')"
+    qt_select1 "select approx_count_distinct(id) from regression_test.${tableName_01} group by group_type"
+    sql "DROP TABLE IF EXISTS ${tableName_01}"
+    
+    
+    // AVG
+    def tableName_02 = "avg"
+    sql "DROP TABLE IF EXISTS ${tableName_02}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_02} (
+            id int,
+	    level int,
+	    group_type VARCHAR(10)
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_02} values(1,100,'beijing'), (2,70,'xian'), (3,90,'xian') ,(4,100,'beijing') ,(5,140,'xian') ,(6,100,'beijing')"
+    qt_select2 "select group_type,AVG(level) from regression_test.${tableName_02} group by group_type order by group_type"
+    qt_select3 "select group_type,AVG(distinct level) from regression_test.${tableName_02} group by group_type order by group_type"
+    sql "DROP TABLE IF EXISTS ${tableName_02}"
+
+
+    
+    // BITMAP_UNION
+    def tableName_03 = "pv_bitmap"
+    def tableName_04 = "bitmap_base"
+    sql "DROP TABLE IF EXISTS ${tableName_03}"
+
+    sql """
+	CREATE TABLE ${tableName_03} (
+	 `dt` int(11) NULL COMMENT "",
+	 `page` varchar(10) NULL COMMENT "",
+	 `user_id` bitmap BITMAP_UNION NULL COMMENT ""
+	) ENGINE=OLAP
+	AGGREGATE KEY(`dt`, `page`)
+	COMMENT "OLAP"
+	DISTRIBUTED BY HASH(`dt`) BUCKETS 2
+	PROPERTIES (
+          "replication_num" = "1"
+        )
+    """
+
+    sql "DROP TABLE IF EXISTS ${tableName_04}"
+
+    sql """
+	CREATE TABLE ${tableName_04} (
+	 `dt` int(11) NULL COMMENT "",
+	 `page` varchar(10) NULL COMMENT "",
+	 `user_id_bitmap` bitmap BITMAP_UNION NULL COMMENT "",
+	 `user_id_int` int(11) REPLACE NULL COMMENT "",
+	 `user_id_str` string REPLACE NULL COMMENT ""
+	) ENGINE=OLAP
+	AGGREGATE KEY(`dt`, `page`)
+	COMMENT "OLAP"
+	DISTRIBUTED BY HASH(`dt`) BUCKETS 2
+	PROPERTIES (
+	  "replication_num" = "1"
+	)
+        """
+
+    sql "INSERT INTO ${tableName_04} values(20220201,'meituan',to_bitmap(10000),10000,'zhangsan'), (20220201,'meituan',to_bitmap(10001),10001,'lisi'), (20220202,'eleme',to_bitmap(10001),10001,'lisi') ,(20220201,'eleme',to_bitmap(10001),10001,'lisi') ,(20220203,'meituan',to_bitmap(10000),10000,'zhangsan') ,(20220203,'meituan',to_bitmap(10001),10001,'lisi')"
+
+    sql "insert into ${tableName_03} select dt,page,user_id_bitmap user_id from ${tableName_04}"
+    sql "insert into ${tableName_03} select dt,page,bitmap_union(user_id_bitmap) user_id from ${tableName_04} group by dt,page"
+    sql "insert into ${tableName_03} select dt,page,to_bitmap(user_id_int) user_id from ${tableName_04}"
+    sql "insert into ${tableName_03} select dt,page,bitmap_hash(user_id_str) user_id from ${tableName_04}"
+
+    qt_select4 "select bitmap_union_count(user_id) from  ${tableName_03}"
+    qt_select5 "select bitmap_count(bitmap_union(user_id)) FROM ${tableName_03}"
+
+    sql "DROP TABLE IF EXISTS ${tableName_03}"
+    sql "DROP TABLE IF EXISTS ${tableName_04}"
+
+    
+    // COUNT
+    def tableName_05 = "count"
+
+    sql "DROP TABLE IF EXISTS ${tableName_05}"
+ 
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_05} (
+            id int,
+	    group_type VARCHAR(10)
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_05} values(1,'beijing'), (2,'xian'), (2,'xian') ,(4,'beijing') ,(5,'xian') ,(6,'beijing')"
+    qt_select6 "select group_type,count(*) from regression_test.${tableName_05} group by group_type order by group_type"
+    qt_select7 "select group_type,count(id) from regression_test.${tableName_05} group by group_type order by group_type"
+    qt_select8 "select group_type,count(distinct id) from regression_test.${tableName_05} group by group_type order by group_type"
+    sql "DROP TABLE IF EXISTS ${tableName_05}"
+
+    
+    // group_concat
+    def tableName_06 = "group_concat"
+
+   
+    sql "DROP TABLE IF EXISTS ${tableName_06}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_06} (
+            id int,
+            name varchar(10)
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+    """
+    sql "INSERT INTO ${tableName_06} values(1,'beijing'),(2,'beijing'), (1,'xian'), (2,'chengdu') ,(2,'shanghai')"
+
+    qt_select9 "select GROUP_CONCAT(name) from ${tableName_06}"
+    qt_select10 "select GROUP_CONCAT(name,' ') from ${tableName_06}"    
+    qt_select11 "select GROUP_CONCAT(name,NULL) from ${tableName_06}"
+    qt_select12 "select GROUP_CONCAT(name) from ${tableName_06} group by id order by id"
+    qt_select13 "select GROUP_CONCAT(name,' ') from ${tableName_06} group by id order by id"
+    qt_select14 "select GROUP_CONCAT(name,NULL) from ${tableName_06} group by id order by id"
+    sql "DROP TABLE IF EXISTS ${tableName_06}"
+    
+    
+    // HLL_UNION_AGG
+    def tableName_07 = "hll_union_agg"
+    def tableName_08 = "hll_table"
+
+    sql "DROP TABLE IF EXISTS ${tableName_07}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_07} (
+            id int,
+	    group_type VARCHAR(10)
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+
+    sql "INSERT INTO ${tableName_07} values(1,'beijing'), (2,'xian'), (2,'xian') ,(4,'beijing') ,(5,'xian') ,(6,'beijing')"
+    sql "DROP TABLE IF EXISTS ${tableName_08}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_08} (
+            id int,
+	    group_type hll hll_union
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_08} select id,hll_hash(group_type) from ${tableName_07}"
+    
+    qt_select15 "select id,HLL_UNION_AGG(group_type) from regression_test.${tableName_08} group by id order by id"
+    
+    sql "DROP TABLE IF EXISTS ${tableName_07}"
+    sql "DROP TABLE IF EXISTS ${tableName_08}"
+    
+    
+    // MAX
+    def tableName_09 = "max"
+
+    sql "DROP TABLE IF EXISTS ${tableName_09}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_09} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_09} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+    
+    qt_select16 "select id,MAX(level) from regression_test.${tableName_09} group by id order by id"
+    qt_select17 "select MAX(level) from regression_test.${tableName_09}"
+    
+    sql "DROP TABLE IF EXISTS ${tableName_09}"
+    
+    // MIN
+    def tableName_11 = "min"
+
+    sql "DROP TABLE IF EXISTS ${tableName_11}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_11} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_11} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+
+    qt_select18 "select id,MIN(level) from regression_test.${tableName_11} group by id order by id"
+    qt_select19 "select MIN(level) from regression_test.${tableName_11}"
+
+    sql "DROP TABLE IF EXISTS ${tableName_11}"
+
+    
+    // PERCENTILE
+    def tableName_13 = "percentile"
+
+    sql "DROP TABLE IF EXISTS ${tableName_13}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_13} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_13} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+
+    qt_select20 "select id,percentile(level,0.5) from regression_test.${tableName_13} group by id order by id"
+    qt_select21 "select id,percentile(level,0.55) from regression_test.${tableName_13} group by id order by id"
+    qt_select22 "select id,percentile(level,0.805) from regression_test.${tableName_13} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_13}"
+
+    
+    // PERCENTILE_APPROX
+    def tableName_14 = "percentile_approx"
+
+    sql "DROP TABLE IF EXISTS ${tableName_14}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_14} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+       """
+
+    sql "INSERT INTO ${tableName_14} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+
+    qt_select23 "select id,PERCENTILE_APPROX(level,0.5) from regression_test.${tableName_14} group by id order by id"
+    qt_select24 "select id,PERCENTILE_APPROX(level,0.55) from regression_test.${tableName_14} group by id order by id"
+    qt_select25 "select id,PERCENTILE_APPROX(level,0.805) from regression_test.${tableName_14} group by id order by id"
+    qt_select26 "select id,PERCENTILE_APPROX(level,0.5,2048) from regression_test.${tableName_14} group by id order by id"
+    qt_select27 "select id,PERCENTILE_APPROX(level,0.55,2048) from regression_test.${tableName_14} group by id order by id"
+    qt_select28 "select id,PERCENTILE_APPROX(level,0.805,2048) from regression_test.${tableName_14} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_14}"
+    
+    
+    // STDDEV STDDEV_POP
+    def tableName_15 = "stddev"
+ 
+    sql "DROP TABLE IF EXISTS ${tableName_15}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_15} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+    """
+
+    sql "INSERT INTO ${tableName_15} values(1,10), (2,8), (2,441) ,(1,10) ,(3,29) ,(3,101)"
+
+    qt_select29 "select id,stddev(level) from regression_test.${tableName_15} group by id order by id"
+    qt_select30 "select id,stddev_pop(level) from regression_test.${tableName_15} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_15}"
+
+    
+    // STDDEV_SAMP
+    def tableName_16 = "stddev_samp"
+
+    sql "DROP TABLE IF EXISTS ${tableName_16}" 
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_16} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+
+    sql "INSERT INTO ${tableName_16} values(1,10), (2,8), (2,441) ,(1,10) ,(3,29) ,(3,101)"
+    qt_select31 "select id,stddev_samp(level) from regression_test.${tableName_16} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_16}"
+   
+    
+    // SUM
+    def tableName_17 = "sum"
+  
+    sql "DROP TABLE IF EXISTS ${tableName_17}" 
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_17} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_17} values(1,10), (2,8), (2,441) ,(1,10) ,(3,29) ,(3,101)"
+
+    qt_select32 "select id,sum(level) from regression_test.${tableName_17} group by id order by id"
+    qt_select33 "select sum(level) from regression_test.${tableName_17}"
+
+    sql "DROP TABLE IF EXISTS ${tableName_17}"
+    
+    
+    // TOPN
+    def tableName_18 = "topn"
+
+    sql "DROP TABLE IF EXISTS ${tableName_18}"	 
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_18} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_18} values(1,10), (2,18), (2,441) ,(1,10) ,(3,29) ,(3,101),(1,11), (2,18), (2,41) ,(1,13) ,(3,4) ,(3,12)"
+
+    qt_select34 "select id,topn(level,2) from regression_test.${tableName_18} group by id order by id"       
+    qt_select35 "select id,topn(level,2,100) from regression_test.${tableName_18} group by id order by id"        
+    qt_select36 "select topn(level,2,100) from regression_test.${tableName_18}"
+
+    sql "DROP TABLE IF EXISTS ${tableName_18}"
+    
+    
+    // VAR_SAMP VARIANCE_SAMP
+    def tableName_19 = "var_samp"
+
+    sql "DROP TABLE IF EXISTS ${tableName_19}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_19} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_19} values(1,10), (2,8), (2,441) ,(1,10) ,(3,29) ,(3,101)"
+
+    qt_select37 = sql "select id,var_samp(level) from regression_test.${tableName_19} group by id order by id"
+    qt_select38 = sql "select id,variance_samp(level) from regression_test.${tableName_19} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_19}"
+    
+    
+    // VARIANCE VAR_POP VARIANCE_POP
+    def tableName_20 = "variance"
+
+    sql "DROP TABLE IF EXISTS ${tableName_20}"	 
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_20} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_20} values(1,10), (2,8), (2,441) ,(1,10) ,(3,29) ,(3,101)"
+
+    qt_select39 "select id,VARIANCE(level) from regression_test.${tableName_20} group by id order by id"
+    qt_select40 "select id,VAR_POP(level) from regression_test.${tableName_20} group by id order by id"
+    qt_select41 "select id,VARIANCE_POP(level) from regression_test.${tableName_20} group by id order by id"
+
+    sql "DROP TABLE IF EXISTS ${tableName_20}"
+    
+    
+    // MAX_BY
+    def tableName_10 = "max_by"
+    
+    sql "DROP TABLE IF EXISTS ${tableName_10}" 
+    sql """
+	CREATE TABLE IF NOT EXISTS ${tableName_10} (
+	    id int,
+	    level int
+	)
+	DISTRIBUTED BY HASH(id) BUCKETS 1
+	PROPERTIES (
+	  "replication_num" = "1"
+	) 
+	"""
+    sql "INSERT INTO ${tableName_10} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+
+    qt_select42 "select MAX_BY(id,level) from regression_test.${tableName_10}"
+    
+    sql "DROP TABLE IF EXISTS ${tableName_10}"
+    
+    // MIN_BY
+    def tableName_12 = "min_by"
+
+    sql "DROP TABLE IF EXISTS ${tableName_12}"
+    sql """
+        CREATE TABLE IF NOT EXISTS ${tableName_12} (
+            id int,
+	    level int
+        )
+        DISTRIBUTED BY HASH(id) BUCKETS 1
+        PROPERTIES (
+          "replication_num" = "1"
+        ) 
+        """
+    sql "INSERT INTO ${tableName_12} values(1,10), (2,8), (2,441) ,(3,10) ,(5,29) ,(6,101)"
+
+    qt_select43 "select MIN_BY(id,level) from regression_test.${tableName_12}"
+       
+    sql "DROP TABLE IF EXISTS ${tableName_10}"
+}


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org