<!-- #请认真填写以下信息，否则可能由于无法定位，导致issue无法解决而被取消 -->

【标题描述】:tpcds建表，查询Q14执行计划，数据库coredump

【测试类型：SQL功能】【测试版本：7.0.0】tpcds建表，查询Q14执行计划，数据库coredump

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

openEuler release 20.03 (LTS)

Linux kwepds00014 4.19.90-2003.4.0.0036.oe1.x86_64 #1 SMP Mon Mar 23 19:10:41 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

【测试环境】(单机/1主x备x级联备):单机

【被测功能】:sql功能

【测试类型】:功能

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

gaussdb (openGauss 6.0.0 build bead0152) compiled at 2024-09-11 09:09:44 commit 0 last mr

【预置条件】:无

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

1. gsql -f tpcds.sql 建表

2. explain 查询Q14执行计划

【预期输出】:查询成功

【实际输出】:数据库core

【原因分析】:

1. 这个问题的根因

2. 问题推断过程

3. 还有哪些原因可能造成类似现象

4. 该问题是否有临时规避措施

5. 问题解决方案

6. 预计修复问题时间

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

```

#0 BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404

#1 0x000055803813d021 in bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:116

#2 bbox_handler (sig=<optimized out>, si=<optimized out>, uc=<optimized out>) at gs_bbox.cpp:103

#3 <signal handler called>

#4 0x0000558037a755d1 in list_nth_int (list=0x7faaa0435e18, n=n@entry=2) at list.cpp:627

#5 0x000055803818731f in create_ctescan_plan (scan_clauses=0x0, tlist=0x7faa9927e1b0, best_path=<optimized out>, root=0x7faaa07e9f08) at createplan.cpp:3548

#6 create_scan_plan (root=0x7faaa07e9f08, best_path=<optimized out>) at createplan.cpp:731

#7 0x00005580381831b3 in create_plan_recurse (root=0x7faaa07e9f08, best_path=0x7faaa07c0270) at createplan.cpp:398

#8 0x0000558038183a08 in create_unique_plan (best_path=0x7faaa07edde8, root=0x7faaa07e9f08) at createplan.cpp:1713

#9 create_plan_recurse (root=0x7faaa07e9f08, best_path=0x7faaa07edde8) at createplan.cpp:408

#10 0x000055803818323e in create_join_plan (best_path=0x7faaa0806360, root=0x7faaa07e9f08) at createplan.cpp:1184

#11 create_plan_recurse (root=0x7faaa07e9f08, best_path=0x7faaa0806360) at createplan.cpp:377

#12 0x000055803818323e in create_join_plan (best_path=0x7faaa080f4e0, root=0x7faaa07e9f08) at createplan.cpp:1184

#13 create_plan_recurse (root=0x7faaa07e9f08, best_path=0x7faaa080f4e0) at createplan.cpp:377

#14 0x000055803818323e in create_join_plan (best_path=0x7faaa1ea1ba0, root=0x7faaa07e9f08) at createplan.cpp:1184

#15 create_plan_recurse (root=0x7faaa07e9f08, best_path=0x7faaa1ea1ba0) at createplan.cpp:377

#16 0x0000558038185e15 in create_plan (root=root@entry=0x7faaa07e9f08, best_path=best_path@entry=0x7faaa1ea1ba0) at createplan.cpp:322

#17 0x00005580381a1120 in internal_grouping_planner (root=<optimized out>, tuple_fraction=<optimized out>) at planner.cpp:3447

#18 0x00005580381aa5a3 in internal_grouping_planner (tuple_fraction=0, root=0x7faaa07e9f08) at planner.cpp:1977

#19 subquery_planner (glob=<optimized out>, parse=parse@entry=0x7faaa07e2b00, parent_root=parent_root@entry=0x7faaa046c448, hasRecursion=hasRecursion@entry=false,

tuple_fraction=<optimized out>, subroot=subroot@entry=0x7faaabd437d8, options=<optimized out>, diskeys=<optimized out>, subqueryRestrictInfo=<optimized out>)

at planner.cpp:1937

#20 0x0000558038141a01 in set_subquery_path (root=root@entry=0x7faaa046c448, rel=rel@entry=0x7faaa0490360, subquery=subquery@entry=0x7faaa07e2b00, options=options@entry=1,

rti=3) at allpaths.cpp:2880

#21 0x0000558038141fdc in set_subquery_pathlist (root=root@entry=0x7faaa046c448, rel=rel@entry=0x7faaa0490360, rti=rti@entry=3, rte=rte@entry=0x7faaa0341518)

at allpaths.cpp:2813

#22 0x00005580381454ea in set_rel_size (root=root@entry=0x7faaa046c448, rel=rel@entry=0x7faaa0490360, rti=rti@entry=3, rte=rte@entry=0x7faaa0341518) at allpaths.cpp:720

#23 0x0000558038144f86 in set_append_rel_size (rte=<optimized out>, rti=1, rel=0x7faa9925fbc8, root=0x7faaa046c448) at allpaths.cpp:1531

#24 set_rel_size (root=root@entry=0x7faaa046c448, rel=rel@entry=0x7faa9925fbc8, rti=rti@entry=1, rte=<optimized out>) at allpaths.cpp:702

#25 0x000055803814636f in set_base_rel_sizes (root=root@entry=0x7faaa046c448, onlyRelatinalTable=onlyRelatinalTable@entry=false) at allpaths.cpp:333

#26 0x0000558038146b03 in make_one_rel (root=root@entry=0x7faaa046c448, joinlist=joinlist@entry=0x7faaa0490a50, non_keypreserved=0x0) at allpaths.cpp:267

#27 0x000055803818f31d in query_planner (root=root@entry=0x7faaa046c448, tlist=tlist@entry=0x7faa9925f648, qp_callback=<optimized out>,

qp_extra=qp_extra@entry=0x7faaabd43e80) at planmain.cpp:280

#28 0x000055803819f862 in internal_grouping_planner (root=<optimized out>, tuple_fraction=<optimized out>) at planner.cpp:3242

#29 0x00005580381aa5a3 in internal_grouping_planner (tuple_fraction=100, root=0x7faaa046c448) at planner.cpp:1977

#30 subquery_planner (glob=<optimized out>, parse=parse@entry=0x7faa9925ab48, parent_root=parent_root@entry=0x7faaa038e050, hasRecursion=hasRecursion@entry=false,

tuple_fraction=<optimized out>, subroot=subroot@entry=0x7faaabd44798, options=<optimized out>, diskeys=<optimized out>, subqueryRestrictInfo=<optimized out>)

at planner.cpp:1937

#31 0x0000558038141a01 in set_subquery_path (root=root@entry=0x7faaa038e050, rel=rel@entry=0x7faa9925a148, subquery=subquery@entry=0x7faa9925ab48, options=options@entry=1,

rti=1) at allpaths.cpp:2880

#32 0x0000558038141fdc in set_subquery_pathlist (root=root@entry=0x7faaa038e050, rel=rel@entry=0x7faa9925a148, rti=rti@entry=1, rte=rte@entry=0x7faaa235ce78)

at allpaths.cpp:2813

#33 0x00005580381454ea in set_rel_size (root=root@entry=0x7faaa038e050, rel=rel@entry=0x7faa9925a148, rti=rti@entry=1, rte=0x7faaa235ce78) at allpaths.cpp:720

#34 0x000055803814636f in set_base_rel_sizes (root=root@entry=0x7faaa038e050, onlyRelatinalTable=onlyRelatinalTable@entry=false) at allpaths.cpp:333

#35 0x0000558038146b03 in make_one_rel (root=root@entry=0x7faaa038e050, joinlist=joinlist@entry=0x7faa9925a528, non_keypreserved=0x0) at allpaths.cpp:267

#36 0x000055803818f31d in query_planner (root=root@entry=0x7faaa038e050, tlist=tlist@entry=0x7faaa30031c8, qp_callback=<optimized out>,

qp_extra=qp_extra@entry=0x7faaabd44d80) at planmain.cpp:280

--Type <RET> for more, q to quit, c to continue without paging--

#37 0x000055803819f862 in internal_grouping_planner (root=<optimized out>, tuple_fraction=<optimized out>) at planner.cpp:3242

#38 0x00005580381aa5a3 in internal_grouping_planner (tuple_fraction=0, root=0x7faaa038e050) at planner.cpp:1977

#39 subquery_planner (glob=<optimized out>, parse=<optimized out>, parent_root=<optimized out>, hasRecursion=<optimized out>, tuple_fraction=<optimized out>,

subroot=<optimized out>, options=<optimized out>, diskeys=<optimized out>, subqueryRestrictInfo=<optimized out>) at planner.cpp:1937

#40 0x00005580381adb87 in standard_planner (parse=parse@entry=0x7faaa2be5050, cursorOptions=0, cursorOptions@entry=512, boundParams=boundParams@entry=0x0) at planner.cpp:692

#41 0x00005580381c3299 in pgxc_planner (query=<optimized out>, cursorOptions=<optimized out>, boundParams=<optimized out>) at pgxcplan_single.cpp:278

#42 0x00005580381aee4d in planner (parse=0x7faaa07b8270, cursorOptions=512, boundParams=0x0) at planner.cpp:409

#43 0x00005580384f89c5 in pg_plan_query (querytree=querytree@entry=0x7faaa07b8270, cursorOptions=cursorOptions@entry=512, boundParams=boundParams@entry=0x0,

underExplain=underExplain@entry=true) at postgres.cpp:1401

#44 0x00005580382d0ace in ExplainOneQuery (query=query@entry=0x7faaa07b8270, into=into@entry=0x0, es=es@entry=0x7faaabd45ba0,

queryString=queryString@entry=0x7faaa304a890 "explain with cross_items as\n (select i_item_sk ss_item_sk\n from item,\n (select iss.i_brand_id brand_id\n ,iss.i_clas s_id class_id\n ,iss.i_category_id category_id\n from store_sales\n ,item i"..., dest=<optimized out>, params=params@entry=0x0) at explain.cpp:725

#45 0x00005580382d1aad in ExplainQuery (stmt=stmt@entry=0x7faaa2baeef0,

queryString=queryString@entry=0x7faaa304a890 "explain with cross_items as\n (select i_item_sk ss_item_sk\n from item,\n (select iss.i_brand_id brand_id\n ,iss.i_clas s_id class_id\n ,iss.i_category_id category_id\n from store_sales\n ,item i"..., params=params@entry=0x0, dest=dest@entry=0x7faaa2eaa998,

completionTag=completionTag@entry=0x7faaabd47c50 "") at explain.cpp:500

#46 0x000055803851b2a0 in standard_ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7faaabd47be0, dest=dest@entry=0x7faaa2eaa998,

sent_to_remote=<optimized out>, completion_tag=completion_tag@entry=0x7faaabd47c50 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL, isCTAS=<optimized out>)

at utility.cpp:3812

#47 0x00007fabc64912d1 in gsaudit_ProcessUtility_hook (processutility_cxt=0x7faaabd47be0, dest=0x7faaa2eaa998, sentToRemote=<optimized out>,

completionTag=0x7faaabd47c50 "", context=PROCESS_UTILITY_TOPLEVEL, isCTAS=<optimized out>) at gs_policy_plugin.cpp:819

#48 0x000055803852102f in pgaudit_ProcessUtility (processutility_cxt=0x7faaabd47be0, dest=<optimized out>, sentToRemote=<optimized out>, completionTag=<optimized out>,

context=<optimized out>, isCTAS=<optimized out>) at auditfuncs.cpp:1419

#49 0x000055803851d19b in ProcessUtility (processutility_cxt=processutility_cxt@entry=0x7faaabd47be0, dest=dest@entry=0x7faaa2eaa998,

sent_to_remote=sent_to_remote@entry=false, completion_tag=completion_tag@entry=0x7faaabd47c50 "", context=context@entry=PROCESS_UTILITY_TOPLEVEL,

isCTAS=isCTAS@entry=false) at utility.cpp:1587

#50 0x000055803850c145 in PortalRunUtility (portal=portal@entry=0x7faaa1f22050, utilityStmt=0x7faaa2baeef0, isTopLevel=isTopLevel@entry=true,

dest=dest@entry=0x7faaa2eaa998, completionTag=completionTag@entry=0x7faaabd47c50 "") at pquery.cpp:1734

#51 0x000055803850fe6e in FillPortalStore (portal=0x7faaa1f22050, isTopLevel=<optimized out>) at ../../../../src/include/nodes/pg_list.h:96

#52 0x0000558038510fd6 in PortalRun (portal=portal@entry=0x7faaa1f22050, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true,

dest=dest@entry=0x7faaa2baefc0, altdest=altdest@entry=0x7faaa2baefc0, completionTag=completionTag@entry=0x7faaabd47fc0 "") at pquery.cpp:1144

#53 0x00005580384fe34c in exec_simple_query (query_string=<optimized out>, messageType=<optimized out>, msg=<optimized out>) at postgres.cpp:3044

#54 0x00005580385035c7 in PostgresMain (argc=<optimized out>, argv=argv@entry=0x7faabb005d10, dbname=<optimized out>, username=<optimized out>) at postgres.cpp:9266

#55 0x0000558038452395 in BackendRun (port=port@entry=0x7faaabd49a40) at postmaster.cpp:9612

#56 0x00005580384826d8 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7faaf43d8fb0) at postmaster.cpp:12021

#57 0x0000558038452425 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14841

#58 0x00007fabc66edfed in ?? () from /lib64/libpthread.so.0

#59 0x00007fabc662118f in clone () from /lib64/libc.so.6

```

【测试代码】:见附件