BE crash when using order by to query csv with hive catalog

[TomZhang2]

Steps to reproduce the behavior (Required)

1. CREATE TABLE ry_data_file_csv_173404fd070550f1f9ea435d36d98ec2 (
   time_stamp bigint(20) DEFAULT NULL,
   string_01 varchar(1048576) DEFAULT NULL,
   string_02 varchar(1048576) DEFAULT NULL,
   string_03 varchar(1048576) DEFAULT NULL,
   string_04 varchar(1048576) DEFAULT NULL,
   string_05 varchar(1048576) DEFAULT NULL,
   string_06 varchar(1048576) DEFAULT NULL,
   string_07 varchar(1048576) DEFAULT NULL,
   string_08 varchar(1048576) DEFAULT NULL,
   string_09 varchar(1048576) DEFAULT NULL,
   string_10 varchar(1048576) DEFAULT NULL,
   integer_01 int(11) DEFAULT NULL,
   integer_02 int(11) DEFAULT NULL,
   integer_03 int(11) DEFAULT NULL,
   integer_04 int(11) DEFAULT NULL,
   integer_05 int(11) DEFAULT NULL,
   integer_06 int(11) DEFAULT NULL,
   integer_07 int(11) DEFAULT NULL,
   integer_08 int(11) DEFAULT NULL,
   integer_09 int(11) DEFAULT NULL,
   integer_10 int(11) DEFAULT NULL,
   long_01 bigint(20) DEFAULT NULL,
   long_02 bigint(20) DEFAULT NULL,
   long_03 bigint(20) DEFAULT NULL,
   long_04 bigint(20) DEFAULT NULL,
   long_05 bigint(20) DEFAULT NULL,
   long_06 bigint(20) DEFAULT NULL,
   long_07 bigint(20) DEFAULT NULL,
   long_08 bigint(20) DEFAULT NULL,
   long_09 bigint(20) DEFAULT NULL,
   long_10 bigint(20) DEFAULT NULL,
   float_01 float DEFAULT NULL,
   float_02 float DEFAULT NULL,
   float_03 float DEFAULT NULL,
   float_04 float DEFAULT NULL,
   float_05 float DEFAULT NULL,
   float_06 float DEFAULT NULL,
   float_07 float DEFAULT NULL,
   float_08 float DEFAULT NULL,
   float_09 float DEFAULT NULL,
   float_10 float DEFAULT NULL,
   double_01 double DEFAULT NULL,
   double_02 double DEFAULT NULL,
   double_03 double DEFAULT NULL,
   double_04 double DEFAULT NULL,
   double_05 double DEFAULT NULL,
   double_06 double DEFAULT NULL,
   double_07 double DEFAULT NULL,
   double_08 double DEFAULT NULL,
   double_09 double DEFAULT NULL,
   double_10 double DEFAULT NULL,
   _partition_id datetime DEFAULT NULL
   )
   PARTITION BY ( _partition_id )
   PROPERTIES ("location" = "hdfs://hacluster/srv/bigdata/tmpPath");

2. INSERT INTO '....'

3. SELECT LOWER(UPPER(query_data_file_csv.string_01)) AS re FROM dte_hive_catalog._default.ry_data_file_csv_173404fd070550f1f9ea435d36d98ec2 AS query_data_file_csv ORDER BY query_data_file_csv.string_01

Expected behavior (Required)

Success

Real behavior (Required)

Be crash
3.2.0-xxx RELEASE (build 3eb2a68)
query_id:904de617-588a-11ef-b67b-286ed4899978, fragment_instance:904de617-588a-11ef-b67b-286ed489997c
tracker:process consumption: 1050132920
tracker:query_pool consumption: 177633888
tracker:load consumption: 0
tracker:metadata consumption: 48359931
tracker:tablet_metadata consumption: 1023064
tracker:rowset_metadata consumption: 38737689
tracker:segment_metadata consumption: 1740586
tracker:column_metadata consumption: 6858592
tracker:tablet_schema consumption: 417368
tracker:segment_zonemap consumption: 1297016
tracker:short_key_index consumption: 50260
tracker:column_zonemap_index consumption: 2344640
tracker:ordinal_index consumption: 1952448
tracker:bitmap_index consumption: 0
tracker:bloom_filter_index consumption: 0
tracker:compaction consumption: 0
tracker:schema_change consumption: 0
tracker:column_pool consumption: 0
tracker:page_cache consumption: 12065808
tracker:update consumption: 232625922
tracker:chunk_allocator consumption: 202485592
tracker:clone consumption: 0
tracker:consistency consumption: 0
*** Aborted at 1723453764 (unix time) try "date -d @1723453764" if you are using GNU date ***
PC: @ 0x7f36a2faa171 (unknown)
*** SIGSEGV (@0x0) received by PID 3122435 (TID 0x7f35ff48a700) from PID 0; stack trace: ***
@ 0x5b783d2 (unknown)
@ 0x7f36a3c781ff os::Linux::chained_handler()
@ 0x7f36a3c7feae JVM_handle_linux_signal
@ 0x7f36a3c6ed77 signalHandler()
@ 0x7f36a31bc5a0 (unknown)
@ 0x7f36a2faa171 (unknown)
@ 0x550eb61 (unknown)
@ 0x5544919 starrocks::UnpackConstColumnUnaryFunction<>::evaluate<>()
@ 0x55452d5 starrocks::DealNullableColumnUnaryFunction<>::evaluate<>()
@ 0x55321c9 starrocks::StringFunctions::upper()
@ 0x47c3394 starrocks::VectorizedFunctionCallExpr::evaluate_checked()
@ 0x3f54a13 starrocks::ExprContext::evaluate()
@ 0x47c2f24 starrocks::VectorizedFunctionCallExpr::evaluate_checked()
@ 0x3f54a13 starrocks::ExprContext::evaluate()
@ 0x3f54d5f starrocks::ExprContext::evaluate()
@ 0x3231434 starrocks::pipeline::ProjectOperator::push_chunk()
@ 0x32d6e38 starrocks::pipeline::PipelineDriver::process()
@ 0x32c7cfe starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x291faf2 starrocks::ThreadPool::dispatch_thread()
@ 0x291a6aa starrocks::Thread::supervise_thread()
@ 0x7f36a31b1f3b (unknown)
@ 0x7f36a2f46520 clone
@ 0x0 (unknown)
start time: Mon Aug 12 17:11:05 CST 2024
SLF4J: Class path contains multiple SLF4J bindings.

StarRocks version (Required)

• 3.2.0