oceanbase/sql-lifecycle-management

[Bug]: `GROUP_CONCAT` is not support

Ifffff opened this issue · 0 comments

Ifffff commented

Describe the bug
Synatx:

GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,col_name ...]]
             [SEPARATOR str_val])

test sql:

select 
            'obdpc' tenant_name,'database017' database_name,table_name,index_name,index_status,index_type,
            group_concat(column_name order by rank asc separator ';') column_list
            from
            (select a.table_name,'primary' index_name,'normal' index_status,
            (case when a.index_type=0 then '1.primary' when a.index_type=2 then '2.unique' else '3.normal' end) index_type,
            d.column_name,d.rowkey_position rank
            from __all_table a,__all_column d
            where a.tenant_id=d.tenant_id and a.table_type=3 and a.table_id=d.table_id and d.rowkey_position!=0
            and a.tenant_id = 1012 and a.database_id = 1112705767310411
            ) sub
            group by tenant_name,database_name,table_name,index_name,index_type
            order by tenant_name,database_name,table_name,index_type,index_name