This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new a759b6535b [test](regression) Add cases to test cast function
substitution (#20481)
a759b6535b is described below
commit a759b6535b69805d89a9fab0d6f8512e704f8766
Author: LiBinfeng <[email protected]>
AuthorDate: Thu Jun 8 19:56:51 2023 +0800
[test](regression) Add cases to test cast function substitution (#20481)
This is a mirror to pr #20479, master do not have this problem, but test
cases also need to be added
---
.../aggregate/aggregate_grouping_function.groovy | 49 +++++++++++++++++++++-
1 file changed, 48 insertions(+), 1 deletion(-)
diff --git
a/regression-test/suites/query_p0/aggregate/aggregate_grouping_function.groovy
b/regression-test/suites/query_p0/aggregate/aggregate_grouping_function.groovy
index 65d71923f3..54c1f6a977 100644
---
a/regression-test/suites/query_p0/aggregate/aggregate_grouping_function.groovy
+++
b/regression-test/suites/query_p0/aggregate/aggregate_grouping_function.groovy
@@ -1,3 +1,4 @@
+
// 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
@@ -90,4 +91,50 @@ suite("aggregate_grouping_function") {
"""
sql "DROP TABLE test_aggregate_grouping_function"
-}
\ No newline at end of file
+
+ sql "DROP TABLE IF EXISTS test_aggregate_collect_set"
+
+ sql """
+ CREATE table test_aggregate_collect_set (
+ custr_nbr varchar(30),
+ bar_code varchar(36),
+ audit_id varchar(255),
+ case_id text,
+ into_time text,
+ audit_time text,
+ apply_type text,
+ node_code text,
+ audit_code1 text,
+ audit_code2 text,
+ audit_code3 text
+ ) UNIQUE KEY (custr_nbr,bar_code,audit_id )
+ distributed by hash (custr_nbr,bar_code,audit_id ) buckets 10
+ properties(
+ "replication_num" = "1"
+ );"""
+
+ sql """ INSERT into test_aggregate_collect_set values ('custr_nbr',
'barcode', 'audit_id', 'case_id', '2007-11-30 10:30:19', '2007-11-30 10:30:19',
'2', 'Decline', 'c1', 'c2', 'c3');"""
+
+ sql """
+ SELECT
+ tt.tag_value
+ FROM (
+ SELECT
+ d.custr_nbr,
+ concat_ws('|', collect_set(d.is_code1)) as tag_value
+ FROM (
+ SELECT
+ b.custr_nbr,
+ 1 as is_code1
+ FROM test_aggregate_collect_set b
+ ) d
+ GROUP BY d.custr_nbr
+ ) tt
+ GROUP BY tt.tag_value
+ ;
+ """
+
+ sql "DROP TABLE test_aggregate_collect_set"
+}
+
+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
