[Bug]: yat用例next_day函数报core-oGRAC-AtomGit

已关闭

[Bug]: yat用例next_day函数报core #349

hcs创建于 9 天前关闭于 2 天前

hcs成员

9 天前创建

测试类型

SQL功能

测试版本

7.0.0LTS

问题描述

schedule_BusCon_1_CI2.schd

操作系统和硬件信息

任意

测试环境

oGRAC单节点

被测功能

预置条件

操作步骤

schedule_BusCon_1_CI2.schd

select next_day('9999-12-31 23:59:59',1) from sys_dummy;

select next_day('9999-12-31 24:59:59',1) from sys_dummy;

预期输出

实际输出

日志信息

(gdb) bt
#0 0x0000ffff625b6570 in raise () from /lib64/libc.so.6
#1 0x0000ffff625b791c in abort () from /lib64/libc.so.6
#2 0x0000aaabf882a72c in proc_sign_func (sig_num=11, siginfo=0xfffa7b1e7bd0, context=0xfffa7b1e7c50) at /data/ograc/oGRAC/pkg/src/server/srv_blackbox.c:740
#3
#4 0x0000ffff628563a0 in cm_assert (condition=0) at /data/ograc/oGRAC/pkg/src/common/cm_debug.h:61
#5 0x0000ffff6285771c in cm_encode_date (detail=0xfffa7b1e8eb0) at /data/ograc/oGRAC/pkg/src/common/cm_date.c:691
#6 0x0000ffff6285d9bc in cm_text2date (text=0xfffa7b1e8fa8, fmt=0xfffa7b1e8f08, date=0xfffa7b1e8fa8) at /data/ograc/oGRAC/pkg/src/common/cm_date.c:2475
#7 0x0000ffff62834bbc in var_as_date (nls=0xfffa70864fe0, var=0xfffa7b1e8fa8) at /data/ograc/oGRAC/pkg/src/common/variant/var_cast.c:382
#8 0x0000aaabf89feb8c in sql_func_next_day (stmt=0xaaac3c80bc00, func=0xfffcc4c234c8, res=0xfffa7b1e9130) at /data/ograc/oGRAC/pkg/src/ogsql/function/func_date.c:811
#9 0x0000aaabf899c2b8 in sql_invoke_func (stmt=0xaaac3c80bc00, node=0xfffcc4c234c8, result=0xfffa7b1e9130) at /data/ograc/oGRAC/pkg/src/ogsql/node/ogsql_func.c:744
#10 0x0000aaabf89972fc in sql_exec_func_node (stmt=0xaaac3c80bc00, node=0xfffcc4c234c8, result=0xfffa7b1e9130) at /data/ograc/oGRAC/pkg/src/ogsql/node/ogsql_expr.c:3623
#11 0x0000aaabf898faf8 in sql_exec_expr_node (stmt=0xaaac3c80bc00, node=0xfffcc4c234c8, result=0xfffa7b1e9130) at /data/ograc/oGRAC/pkg/src/ogsql/node/ogsql_expr.c:1620
#12 0x0000aaabf8990688 in sql_try_optimize_const_expr (stmt=0xaaac3c80bc00, node=0xfffcc4c234c8) at /data/ograc/oGRAC/pkg/src/ogsql/node/ogsql_expr.c:1902
#13 0x0000aaabf8b1ed80 in sql_verify_expr_node_core (verif=0xfffa7b1e9418, node=0xfffcc4c234c8) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_expr_verifier.c:1696
#14 0x0000aaabf8b1ee08 in sql_verify_expr_node (verif=0xfffa7b1e9418, node=0xfffcc4c234c8) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_expr_verifier.c:1706
#15 0x0000aaabf8b1ee78 in sql_verify_current_expr (verif=0xfffa7b1e9418, verf_expr=0xfffcc4c23470) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_expr_verifier.c:1713
#16 0x0000aaabf8b1efe8 in sql_verify_expr (verif=0xfffa7b1e9418, expr=0xfffcc4c23470) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_expr_verifier.c:1731
#17 0x0000aaabf8ddd338 in sql_verify_query_column (verif=0xfffa7b1e9418, column=0xfffcc4c232e8) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_column_verifier.c:1497
#18 0x0000aaabf8ddd888 in sql_verify_qry_col_inside (verif=0xfffa7b1e9418, query=0xfffcc4c228d0, aggrs_expr_count=0xfffa7b1e92ec, has_single_column=0xfffa7b1e92f0)
at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_column_verifier.c:1579
#19 0x0000aaabf8dddb50 in sql_verify_query_columns (verif=0xfffa7b1e9418, query=0xfffcc4c228d0) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_column_verifier.c:1629
#20 0x0000aaabf8b2ea78 in sql_verify_query (verif=0xfffa7b1e9418, query=0xfffcc4c228d0) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_select_verifier.c:1060
#21 0x0000aaabf8b2ef7c in sql_verify_select_node (verif=0xfffa7b1e9418, node=0xfffcc4c228a0) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_select_verifier.c:1103
#22 0x0000aaabf8b2fd50 in sql_verify_select_context (verif=0xfffa7b1e9418, select_ctx=0xfffcc4c22730) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_select_verifier.c:1339
#23 0x0000aaabf8b2ffb8 in sql_verify_select (stmt=0xaaac3c80bc00, select_ctx=0xfffcc4c22730) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_select_verifier.c:1385
#24 0x0000aaabf8b3af24 in sql_verify (stmt=0xaaac3c80bc00) at /data/ograc/oGRAC/pkg/src/ogsql/verifier/ogsql_verifier.c:951
#25 0x0000aaabf8a5f3c4 in sql_create_dml (stmt=0xaaac3c80bc00, sql=0xaaac441ecd04, key_wid=KEY_WORD_SELECT) at /data/ograc/oGRAC/pkg/src/ogsql/parser/dml_parser.c:1249
#26 0x0000aaabf8a5f4e8 in sql_create_dml_currently (stmt=0xaaac3c80bc00, sql_text=0xaaac441ecd04, key_wid=KEY_WORD_SELECT)
at /data/ograc/oGRAC/pkg/src/ogsql/parser/dml_parser.c:1262
#27 0x0000aaabf8a817c4 in og_find_then_parse_dml (statement=0xaaac3c80bc00, key_wid=KEY_WORD_SELECT, sql_text=0xaaac441ecd04, special_word=0)
at /data/ograc/oGRAC/pkg/src/ogsql/parser/ogsql_cache.c:254
#28 0x0000aaabf8a61074 in sql_parse_dml (stmt=0xaaac3c80bc00, leader_word=0xfffa7b1e9aa0) at /data/ograc/oGRAC/pkg/src/ogsql/parser/dml_parser.c:1702
#29 0x0000aaabf8a8ca48 in sql_parse_by_lang_type (stmt=0xaaac3c80bc00, sql_text=0xfffa7b1e9a70, leader_word=0xfffa7b1e9aa0)
at /data/ograc/oGRAC/pkg/src/ogsql/parser/ogsql_parser.c:767
#30 0x0000aaabf8a8ce48 in sql_parse_core (stmt=0xaaac3c80bc00, sql=0xfffa7b1e9cd8, loc=0xfffa7b1e9cc0) at /data/ograc/oGRAC/pkg/src/ogsql/parser/ogsql_parser.c:823
#31 0x0000aaabf8a8d0dc in sql_parse (stmt=0xaaac3c80bc00, sql=0xfffa7b1e9cd8, loc=0xfffa7b1e9cc0) at /data/ograc/oGRAC/pkg/src/ogsql/parser/ogsql_parser.c:860
#32 0x0000aaabf8880f78 in sql_prepare (stmt=0xaaac3c80bc00) at /data/ograc/oGRAC/pkg/src/ogsql/ogsql_stmt.c:721
#33 0x0000aaabf8867fac in sql_process_prepare (session=0xfffa70860000) at /data/ograc/oGRAC/pkg/src/ogsql/ogsql_service.c:383
#34 0x0000aaabf87b4874 in srv_process_command_core (session=0xfffa70860000, cmd=3 '\003') at /data/ograc/oGRAC/pkg/src/server/srv_session.c:934
--Type for more, q to quit, c to continue without paging--
#35 0x0000aaabf87b4dfc in srv_process_command (session=0xfffa70860000) at /data/ograc/oGRAC/pkg/src/server/srv_session.c:1043
#36 0x0000aaabf8824e40 in srv_process_single_session (session=0xfffa70860000) at /data/ograc/oGRAC/pkg/src/server/srv_agent.c:234
#37 0x0000aaabf88253fc in srv_try_process_multi_sessions (agent=0xfffba09e0998) at /data/ograc/oGRAC/pkg/src/server/srv_agent.c:387
#38 0x0000aaabf8825808 in srv_agent_entry (thread=0xfffba09e09a8) at /data/ograc/oGRAC/pkg/src/server/srv_agent.c:484
#39 0x0000ffff628df32c in cm_thread_run (arg=0xfffba09e09a8) at /data/ograc/oGRAC/pkg/src/common/cm_thread.c:241
#40 0x0000ffff630a878c in ?? () from /lib64/libpthread.so.0
#41 0x0000ffff626551bc in ?? () from /lib64/libc.so.6
(gdb)

提单组织

内部开发

测试代码

hcs成员

9 天前添加了label：bug

opengauss_bot成员

9 天前添加了label：sig/StorageEngine

opengauss_bot成员

9 天前评论：

Welcome To openGauss Community

Hey @Nerifish , thanks for your contribution to the community.

Bot Usage Manual

I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands. You can self-configure the PR merge rules for this repository. For more details, please refer to Here.

Contact Guide

If you have any questions, please contact the SIG: StorageEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @libiao2024, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @CityYard, @libiao2024, @lijieac, @theothersideofsea, @wang_bowen, @weithu, @xiong_xjun, @yuanyazhi, @zhangzq131 .

hcs成员

9 天前修改了issue 的描述

hcs成员

9 天前修改了issue 的描述

hcs成员

9 天前修改了issue 的描述

hcs成员

9 天前修改了issue 的描述

hcs成员

9 天前关联了pull request：修复yat用例next_day异常报core

hcs成员

9 天前关联了pull request：fix Dockerfile_ARM64

hcs成员

9 天前删除了关联的pull request：fix Dockerfile_ARM64

liuzhen001成员

7 天前关联了看板：openGauss 7.0.0-LTS

hcs成员

7 天前评论：

hcs成员

7 天前 issue状态由待办的改变为待回归

wuchenlong成员

2 天前评论：

回归版本：7.0.0-LTS / archive B023（oGRAC Release 7.0.0-RC3 f72e371 build 2026-09-12 12:12:04）
回归环境：oGRAC 双节点（20.20.20.104 / 20.20.20.106），db=ONLINE，节点 20.20.20.104 执行
结论：通过（两条 next_day 边界 SQL 不再 core，改为受控报错，集群保持 ONLINE）

说明：按 issue 操作步骤中的两条 SQL 验证；原问题为 next_day 处理日期边界时 assert/core，现已返回明确错误码。

完整回归 SQL

select next_day('9999-12-31 23:59:59',1) from sys_dummy;
select next_day('9999-12-31 24:59:59',1) from sys_dummy;

实际输出

SQL> select next_day('9999-12-31 23:59:59',1) from sys_dummy;
OG-00694, [1:8]DATETIME out of range, it must be between 0001-01-01 00:00:00 and 9999-12-31 23:59:59

SQL> select next_day('9999-12-31 24:59:59',1) from sys_dummy;
OG-00146, [1:17]HOUR should be from 0 to 23

执行后 cms stat -res db 双节点仍为 ONLINE，未再出现 core。

wuchenlong成员

2 天前 issue状态由待回归改变为已验收

wuchenlong成员

2 天前关闭了 issue