【MYSQL8.0 Core问题质量加固】【测试版本：6.0.0】执行select second(truncate('5',180))产生core

【标题描述】: 【MYSQL8.0 Core问题质量加固】【测试版本：6.0.0】执行select second(truncate('5',180))产生core
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本：x.x.x】 问题描述
 兼容性B库执行select second(truncate('5',180))产生core
【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

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

【被测功能】:

【测试类型】:

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

【预置条件】:
 创建带有dolphin插件的B库
【操作步骤】(请填写详细的操作步骤):
1. select second(truncate('5',180));

【预期输出】: 和MYSQL 8.0一致，返回查询结果
 ![输入图片说明](https://foruda.gitee.com/images/1723457951437232777/61c76ae9_8409131.png "屏幕截图")
【实际输出】:
 core

```
#0  0x000000000105dfe0 in LSCCloseCheck::~LSCCloseCheck (this=0x7fedd61d4759, __in_chrg=<optimized out>) at knl_localsysdbcache.cpp:46
#1  0x00007fef177f085f in __call_tls_dtors () from /lib64/libc.so.6
#2  0x00007fef177f0187 in ?? () from /lib64/libc.so.6
#3  0x00007fef177f01aa in exit () from /lib64/libc.so.6
#4  0x00007fedd2904b8b in fillZeroBeforeNumericTimestamp (str=0x7fedd1dfa748 "5.", '0' <repeats 180 times>, buf=0x7fedd61ca590 "00000") at timestamp.cpp:736
#5  0x00007fedd2904ea3 in numeric_b_format_timestamp (fcinfo=0x7fedd1df8cd0) at timestamp.cpp:790
#6  0x00007fedd2a9d902 in ExecMakeFunctionResultNoSets<false, false> (fcache=0x7fedd1df8b88, econtext=0x7fedd1df8188, isNull=0x7fedd1df8980, isDone=0x0) at execQual.cpp:2916
#7  0x00007fedd2a84688 in ExecEvalFunc (fcache=0x7fedd1df8b88, econtext=0x7fedd1df8188, isNull=0x7fedd1df8980, isDone=0x0) at execQual.cpp:3655
#8  0x00007fedd2a9cf3d in ExecMakeFunctionResultNoSets<false, false> (fcache=0x7fedd1df8760, econtext=0x7fedd1df8188, isNull=0x7fedd1df99a0, isDone=0x7fedd1df9c50) at execQual.cpp:2826
#9  0x00007fedd2a84688 in ExecEvalFunc (fcache=0x7fedd1df8760, econtext=0x7fedd1df8188, isNull=0x7fedd1df99a0, isDone=0x7fedd1df9c50) at execQual.cpp:3655
#10 0x000000000195c1b4 in ExecTargetList (targetlist=0x7fedd1df9be8, econtext=0x7fedd1df8188, values=0x7fedd1df9958, isnull=0x7fedd1df99a0, itemIsDone=0x7fedd1df9c50, isDone=0x7fedd61cb024) at execQual.cpp:6775
#11 0x000000000195cee5 in ExecProject (projInfo=0x7fedd1df9a30, isDone=0x7fedd61cb024) at execQual.cpp:7020
#12 0x00000000019d911a in ExecResult (state=0x7fedd1df8060) at nodeResult.cpp:197
#13 0x00000000019487e8 in ExecProcNodeFirst (node=0x7fedd1df8060) at execProcnode.cpp:697
#14 0x000000000193d019 in ExecProcNode (node=0x7fedd1df8060) at ../../../../src/include/executor/executor.h:284
#15 0x0000000001941cc1 in ExecutePlan (estate=0x7fedd1df6060, planstate=0x7fedd1df8060, operation=CMD_SELECT, sendTuples=true, numberTuples=0, direction=ForwardScanDirection, dest=0x7fedd780be38) at execMain.cpp:2244
#16 0x000000000193e485 in standard_ExecutorRun (queryDesc=0x7fedd6bab460, direction=ForwardScanDirection, count=0) at execMain.cpp:645
#17 0x000000000172fc03 in explain_ExecutorRun (queryDesc=0x7fedd6bab460, direction=ForwardScanDirection, count=0) at auto_explain.cpp:122
#18 0x000000000193defb in ExecutorRun (queryDesc=0x7fedd6bab460, direction=ForwardScanDirection, count=0) at execMain.cpp:492
#19 0x000000000188dbb5 in PortalRunSelect (portal=0x7fedd7b9a060, forward=true, count=0, dest=0x7fedd780be38) at pquery.cpp:1413
#20 0x000000000188cd4d in PortalRun (portal=0x7fedd7b9a060, count=9223372036854775807, isTopLevel=true, dest=0x7fedd780be38, altdest=0x7fedd780be38, completionTag=0x7fedd61cb670 "") at pquery.cpp:1149
#21 0x0000000001874378 in exec_simple_query (query_string=0x7fedd780a060 "select second(truncate('5',180));", messageType=QUERY_MESSAGE, msg=0x7fedd61cb880) at postgres.cpp:2970
#22 0x00000000018818fa in PostgresMain (argc=1, argv=0x7fedd63eb1c0, dbname=0x7fedd63ea1f8 "testb", username=0x7fedd63ea1b0 "rensiyuan") at postgres.cpp:9074
#23 0x00000000017c2552 in BackendRun (port=0x7fedd61cbd70) at postmaster.cpp:9249
#24 0x00000000017d3451 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7fee33547010) at postmaster.cpp:13686
#25 0x00000000017ced1f in InternalThreadFunc (args=0x7fee33547010) at postmaster.cpp:14307
#26 0x00000000022a4ff4 in ThreadStarterFunc (arg=0x7fee33547000) at gs_thread.cpp:382
#27 0x00007fef1797ffed in ?? () from /lib64/libpthread.so.0
#28 0x00007fef178b118f in clone () from /lib64/libc.so.6

```

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

【测试代码】:

openGauss/Plugin

内容风险标识

评论 (5)

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

内容风险标识