dutyu opened a new issue, #20086: URL: https://github.com/apache/doris/issues/20086
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.2.4 ### What's Wrong? SQL: ```sql with t1 as (SELECT `id` AS `id`, `user_no` AS `user_no`, `cust_no` AS `cust_no`, `device_no` AS `device_no`, `geo_no` AS `geo_no`, `user_name_encryptx` AS `user_name_encryptx`, `user_name_md5x` AS `user_name_md5x`, `user_pwd` AS `user_pwd`, `trans_pwd` AS `trans_pwd`, `trans_pwd_flag` AS `trans_pwd_flag`, `salt` AS `salt`, `mobile_no_encryptx` AS `mobile_no_encryptx`, `mobile_no_md5x` AS `mobile_no_md5x`, `division_code` AS `division_code`, `channel_id` AS `channel_id`, `sub_channel` AS `sub_channel`, `activity_info` AS `activity_info`, `register_source` AS `register_source`, `host_app` AS `host_app`, `invitation_code` AS `invitation_code`, `partner_id` AS `partner_id`, `register_time` AS `register_time`, `user_state` AS `user_state`, `expire_time` AS `expire_time`, `created_by` AS `created_by`, `date_created` AS `date_created`, `updated_by` AS `updated_by`, `date_updated` AS `date_updated`, `pday` AS `pday` FROM (select `cis_u_user`.`id`,`cis_u_user`.`user_no`,`cis_u_user`.`cust_ no`,`cis_u_user`.`device_no`,`cis_u_user`.`geo_no`,`cis_u_user`.`user_name_encryptx`,`cis_u_user`.`user_name_md5x`,`cis_u_user`.`user_pwd`,`cis_u_user`.`trans_pwd`,`cis_u_user`.`trans_pwd_flag`,`cis_u_user`.`salt`,`cis_u_user`.`mobile_no_encryptx`,`cis_u_user`.`mobile_no_md5x`,`cis_u_user`.`division_code`,`cis_u_user`.`channel_id`,`cis_u_user`.`sub_channel`,`cis_u_user`.`activity_info`,`cis_u_user`.`register_source`,`cis_u_user`.`host_app`,`cis_u_user`.`invitation_code`,`cis_u_user`.`partner_id`,`cis_u_user`.`register_time`,`cis_u_user`.`user_state`,`cis_u_user`.`expire_time`,`cis_u_user`.`created_by`,`cis_u_user`.`date_created`,`cis_u_user`.`updated_by`,`cis_u_user`.`date_updated`, replace(`cis_u_user`.`partitions`,'-','') `pday` from `ods_safe`.`cis_u_user`) `t2`) select count(*) from t1; ``` BE crash stack: ```c++ I0525 20:39:51.560732 51602 file_helper.cpp:93] success to open file. file_name=/hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/storage/.testfile, mode=384, fd=244 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/doris/be/src/common/signal_handler.h:420 1# 0x00007FAFAF8B1400 in /lib64/libc.so.6 2# gsignal in /lib64/libc.so.6 3# abort in /lib64/libc.so.6 4# 0x00005577D93D9C99 in /hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/lib/doris_be 5# 0x00005577D93CF2AD in /hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/lib/doris_be 6# google::LogMessage::SendToLog() in /hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/lib/doris_be 7# google::LogMessage::Flush() in /hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/lib/doris_be 8# google::LogMessageFatal::~LogMessageFatal() in /hdpData6/yarn/localcache/usercache/hive/appcache/application_1683779081963_749729/filecache/13/doris-be-1.2.4.tar.gz/apache-doris-be-1.2.4-bin-x86_64/lib/doris_be 9# doris::vectorized::ColumnVector<unsigned char>::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/doris/be/src/vec/columns/column_vector.cpp:359 10# doris::vectorized::ColumnNullable::insert_range_from(doris::vectorized::IColumn const&, unsigned long, unsigned long) at /root/doris/be/src/vec/columns/column_nullable.cpp:248 11# doris::ExecNode::do_projections(doris::vectorized::Block*, doris::vectorized::Block*) at /root/doris/be/src/exec/exec_node.cpp:836 12# doris::ExecNode::get_next_after_projects(doris::RuntimeState*, doris::vectorized::Block*, bool*) at /root/doris/be/src/exec/exec_node.cpp:851 13# doris::vectorized::AggregationNode::open(doris::RuntimeState*) at /root/doris/be/src/vec/exec/vaggregation_node.cpp:474 14# doris::PlanFragmentExecutor::open_vectorized_internal() at /root/doris/be/src/runtime/plan_fragment_executor.cpp:289 15# doris::PlanFragmentExecutor::open() at /root/doris/be/src/runtime/plan_fragment_executor.cpp:261 16# doris::FragmentExecState::execute() at /root/doris/be/src/runtime/fragment_mgr.cpp:261 17# doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>) at /root/doris/be/src/runtime/fragment_mgr.cpp:508 18# std::_Function_handler<void (), doris::FragmentMgr::exec_plan_fragment(doris::TExecPlanFragmentParams const&, std::function<void (doris::PlanFragmentExecutor*)>)::{lambda()#1}>::_M_invoke(std::_Any_data const&) at /var/local/ldb-toolchain/include/c++/11/bits/std_function.h:291 19# doris::ThreadPool::dispatch_thread() at /root/doris/be/src/util/threadpool.cpp:543 20# doris::Thread::supervise_thread(void*) at /root/doris/be/src/util/thread.cpp:455 21# start_thread in /lib64/libpthread.so.0 22# clone in /lib64/libc.so.6 ``` I have tried several times and find the key is the `replace(`cis_u_user`.`partitions`,'-','') pday`, if we submit a query like this ```sql with t1 as (SELECT `id` AS `id`, `user_no` AS `user_no`, `cust_no` AS `cust_no`, `device_no` AS `device_no`, `geo_no` AS `geo_no`, `user_name_encryptx` AS `user_name_encryptx`, `user_name_md5x` AS `user_name_md5x`, `user_pwd` AS `user_pwd`, `trans_pwd` AS `trans_pwd`, `trans_pwd_flag` AS `trans_pwd_flag`, `salt` AS `salt`, `mobile_no_encryptx` AS `mobile_no_encryptx`, `mobile_no_md5x` AS `mobile_no_md5x`, `division_code` AS `division_code`, `channel_id` AS `channel_id`, `sub_channel` AS `sub_channel`, `activity_info` AS `activity_info`, `register_source` AS `register_source`, `host_app` AS `host_app`, `invitation_code` AS `invitation_code`, `partner_id` AS `partner_id`, `register_time` AS `register_time`, `user_state` AS `user_state`, `expire_time` AS `expire_time`, `created_by` AS `created_by`, `date_created` AS `date_created`, `updated_by` AS `updated_by`, `date_updated` AS `date_updated`, `partitions` AS `partitions` FROM (select `cis_u_user`.`id`,`cis_u_user`.`user_no`,`cis_u_ user`.`cust_no`,`cis_u_user`.`device_no`,`cis_u_user`.`geo_no`,`cis_u_user`.`user_name_encryptx`,`cis_u_user`.`user_name_md5x`,`cis_u_user`.`user_pwd`,`cis_u_user`.`trans_pwd`,`cis_u_user`.`trans_pwd_flag`,`cis_u_user`.`salt`,`cis_u_user`.`mobile_no_encryptx`,`cis_u_user`.`mobile_no_md5x`,`cis_u_user`.`division_code`,`cis_u_user`.`channel_id`,`cis_u_user`.`sub_channel`,`cis_u_user`.`activity_info`,`cis_u_user`.`register_source`,`cis_u_user`.`host_app`,`cis_u_user`.`invitation_code`,`cis_u_user`.`partner_id`,`cis_u_user`.`register_time`,`cis_u_user`.`user_state`,`cis_u_user`.`expire_time`,`cis_u_user`.`created_by`,`cis_u_user`.`date_created`,`cis_u_user`.`updated_by`,`cis_u_user`.`date_updated`, `partitions` from `ods_safe`.`cis_u_user`) `t2`) select count(*) from t1; ``` it works fine. ### What You Expected? BE not crash ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
