openGauss 7.0.0-RC1 user_set变量引起的宕机

【标题描述】:执行set user define varibale的sql引起宕机

【测试类型：SQL功能】

【测试版本：master】 问题描述

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
 CentOS Linux release 7.6.1810 (Core)
【测试环境】单机

【被测功能】:vec hash join

【测试类型】:

【数据库版本】(查询命令: gaussdb -V):

```shell
gsql ((openGauss 7.0.0-RC1 build ) compiled at 2025-03-28 23:44:28 commit 0 last mr  debug)
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=# select version();
                                                                        version
--------------------------------------------------------------------------------------------------------------------------------------------------------
 (openGauss 7.0.0-RC1 build ) compiled at 2025-03-28 23:44:28 commit 0 last mr  debug on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.0, 64-bit
(1 row)
```

【预置条件】:

【操作步骤】(请填写详细的操作步骤):

1. gsql -d regression -f /og_master/src/test/regress/sql/set_user_defined_variables_test.sql

conf文件如下:

```shell
query_dop=1002
shared_buffers = 256MB
work_mem = 16MB
fsync = off
synchronous_commit = off
archive_mode = off
audit_user_violation = 1
audit_system_object = 511
audit_dml_state = 1
audit_function_exec = 1
audit_copy_exec = 1
full_page_writes = off
wal_keep_segments = 50
checkpoint_segments = 16
checkpoint_timeout = 30min
enable_bbox_dump = off
bbox_dump_count = 4
bbox_dump_path = '/tmp/invalidpath'
#comm_cn_dn_logic_conn = false
enable_absolute_tablespace = true
#enable_dynamic_workload = false
max_connections = 1000
query_mem='256MB'
auth_iteration_count=10000
enable_sonic_hashagg=on
enable_sonic_hashjoin=on
enable_cbm_tracking = on
enable_opfusion = on
uncontrolled_memory_context='HashCacheContext,TupleHashTable,TupleSort,AggContext,SRF multi-call context,CteScan*,FunctionScan*,RemoteQuery*,VecAgg*,HashContext,TopTransactionContext'
#enable_tsdb = on
enable_thread_pool = on
enable_default_cfunc_libpath = off
partition_iterator_elimination = on
enable_ustore = on
wal_level = logical
sql_beta_feature = 'a_style_coerce'
partition_page_estimation = on
enable_global_syscache = on
var_eq_const_selectivity = on
enable_seqscan_fusion = on
enable_functional_dependency = on
enable_indexscan_optimization = on
enable_cachedplan_mgr = on

pca_shared_buffers = 8MB
#enable_ai_stats=off
```

【预期输出】:
不宕机
【实际输出】:
宕机了,core文件如下:

【原因分析】:
hash处理的有问题

【日志信息】(请附上日志文件、截图、coredump信息):

![输入图片说明](https://foruda.gitee.com/images/1743153433469699854/febe9803_15641454.png "屏幕截图")

![输入图片说明](https://foruda.gitee.com/images/1743153413011844862/3a5ac34c_15641454.png "屏幕截图")

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (6)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

内容风险标识