doris 2.1.8 select 字段子查询不支持where条件

下面这个查询，报错：Subquery is not supported in the select list。
select t1.*, (select t2.c1 from t2 where t1.c2 = t2.c2) from t1;