siriume opened a new issue, #12689: URL: https://github.com/apache/doris/issues/12689
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version master-fd0cf78 ### What's Wrong? Similar issue #12606 Create table sql like this ```sql set enable_vectorized_engine=true; CREATE TABLE `tb_td_user` ( `id` bigint(20) NOT NULL, `plat_id` int(11) NOT NULL, `company_id` varchar(180) NOT NULL, `user_name` varchar(150) NOT NULL COMMENT '名称', `user_email` varchar(150) NOT NULL COMMENT '邮箱', `group_id` int(11) NULL COMMENT '组id', `is_delete` int(11) NOT NULL, `ctime` int(11) NOT NULL DEFAULT "0", `mtime` int(11) NOT NULL DEFAULT "0", `op_type` varchar(6) NOT NULL DEFAULT "insert" ) ENGINE=OLAP UNIQUE KEY(`id`, `plat_id`, `company_id`, `user_name`, `user_email`) COMMENT '账户关系表' DISTRIBUTED BY HASH(`id`, `plat_id`, `company_id`, `user_name`, `user_email`) BUCKETS 4 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "bloom_filter_columns" = "plat_id", "compression" = "ZSTD" ); ``` Query like this ```sql select xs.plat_id,xs.company_id, xs_email, xs_group_id, kf_email, kf_group_id from (select plat_id, company_id, concat_ws(",", array_sort(collect_set(`user_email`))) xs_email, concat_ws(",", array_sort(collect_set(`group_id`))) xs_group_id from tb_td_user where plat_id = 1 and is_delete = 0 group by plat_id, company_id) xs left join (select plat_id, company_id, concat_ws(",", array_sort(collect_set(`user_email`))) kf_email, concat_ws(",", array_sort(collect_set(`group_id`))) kf_group_id from tb_td_user where plat_id = 1 and is_delete = 0 group by plat_id, company_id) kf on xs.plat_id = kf.plat_id and xs.company_id = kf.company_id; ``` error like this ``` [HY000][1105] errCode = 2, detailMessage = Unexpected exception: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = No matching function with signature: if(boolean, unknown type: NULL_TYPE, array<char(-1)>). ``` ### What You Expected? Query succeed ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
