github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_aggr_group_concat.result (about)

     1  drop table if exists t1;
     2  create table t1(a int,b text,c text);
     3  insert into t1 values(1,"a","bc"),(2,"ab","c"),(3,"aa","bb"),(3,"aa","bb");
     4  select group_concat(distinct a,b,c separator '|') from t1;
     5  group_concat(distinct a, b, c, |)
     6  1abc|2abc|3aabb
     7  select group_concat(distinct b,c separator '|') from t1 group by a;
     8  group_concat(distinct b, c, |)
     9  abc
    10  abc
    11  aabb
    12  select group_concat(distinct b,c separator '|') from t1;
    13  group_concat(distinct b, c, |)
    14  abc|abc|aabb