测试类型

SQL功能

测试版本

7.0.0-RC3

问题描述

master分支跑ci用例产生core

操作系统和硬件信息

cat /etc/os-release
NAME="openEuler"
VERSION="20.03 (LTS)"
ID="openEuler"
VERSION_ID="20.03"
PRETTY_NAME="openEuler 20.03 (LTS)"
ANSI_COLOR="0;31"

uname -a
Linux openGauss173 4.19.90-2003.4.0.0036.oe1.aarch64 #1 SMP Mon Mar 23 19:06:43 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux

测试环境

oGRAC单节点

被测功能

预置条件

操作步骤

跑bus2_1_9_success.schd这个用例

ogracd -v
oGRAC Release 7.0.0-RC3 6110bf7 build 2026-08-05 10:16:45

bison为默认值，true

手动将bison关掉后同环境跑同流水线没生成core文件
show parameter use_bison_parser;
alter system set use_bison_parser = false;

drop table if exists EMP;
CREATE TABLE EMP
(
	EMPNO number(4) not null,
	enmae varchar2(10),
	job varchar2(9),
	mgr number(4),
	hiredate date,
	sal number(7,2),
	comm number(7,2),
	deptno number(2)
);


set define on;
set serveroutput on;
DECLARE
	v_empno emp.empno%TYPE;
	no_result EXCEPTION;
BEGIN
	UPDATE emp SET sal = sal+100 WHERE v_empno=1234;
	IF SQL%NOTFOUND THEN
		RAISE no_result;
	END IF;
EXCEPTION
	WHEN no_result THEN
		DBE_OUTPUT.PRINT_LINE('error');
	WHEN OTHERS THEN
		DBE_OUTPUT.PRINT_LINE(SQL_ERR_CODE||'---'||SQL_ERR_MSG);
END;
/

预期输出

无core生成跑完用例

实际输出

有core生成

日志信息

Core was generated by `ogracd -D /home/ograc/data'.
Program terminated with signal SIGABRT, Aborted.
#0 0x0000ffffb0b06570 in raise () from /lib64/libc.so.6
[Current thread is 1 (LWP 1343369)]
(gdb) bt
#0 0x0000ffffb0b06570 in raise () from /lib64/libc.so.6
#1 0x0000ffffb0b0791c in abort () from /lib64/libc.so.6
#2 0x0000aaae61168294 in ?? ()
#3
#4 0x0000ffffb0ddb874 in lex_try_fetch_comment () from /home/ograc/install/lib/libogcommon.so
#5 0x0000ffffb0ddbc10 in lex_skip_comments () from /home/ograc/install/lib/libogcommon.so
#6 0x0000ffffb0ddcb94 in lex_try_fetch_bracket () from /home/ograc/install/lib/libogcommon.so
#7 0x0000aaae61493ca8 in plc_prepare_method_extra ()
#8 0x0000aaae61493dfc in plc_try_obj_access_bracket ()
#9 0x0000aaae6149421c in plc_try_obj_access_node ()
#10 0x0000aaae6130a628 in sql_build_func_node ()
#11 0x0000aaae614da858 in plc_word2var ()
#12 0x0000aaae613069d8 in sql_create_columnref_expr ()
#13 0x0000aaae6140e974 in a_base_yyparse ()
#14 0x0000aaae612f66d8 in ?? ()
#15 0x0000aaae612f88a4 in raw_parser ()
#16 0x0000aaae61563db4 in ?? ()
#17 0x0000aaae61564154 in ?? ()
#18 0x0000aaae6156a1ac in plsql_yyparse ()
#19 0x0000aaae614f1768 in pl_parser ()
#20 0x0000aaae614eb164 in plc_bison_compile_anonymous ()
#21 0x0000aaae612f96e0 in sql_parse_bison_anonymous_directly ()
#22 0x0000aaae6140d248 in a_base_yyparse ()
#23 0x0000aaae612f66d8 in ?? ()
#24 0x0000aaae612f88a4 in raw_parser ()
#25 0x0000aaae61313f90 in ?? ()
#26 0x0000aaae61315ee4 in ?? ()
#27 0x0000aaae61315480 in sql_parse ()
#28 0x0000aaae61199b10 in sql_prepare ()
#29 0x0000aaae6118c284 in sql_process_prepare ()
#30 0x0000aaae6110a898 in srv_process_command_core ()
#31 0x0000aaae6110ac2c in srv_process_command ()
#32 0x0000aaae611657c8 in srv_process_single_session ()
#33 0x0000aaae61167448 in ?? ()
#34 0x0000ffffb0df8a00 in ?? () from /home/ograc/install/lib/libogcommon.so
#35 0x0000ffffb15c878c in ?? () from /lib64/libpthread.so.0
#36 0x0000ffffb0ba51bc in ?? () from /lib64/libc.so.6

提单组织

内部开发

测试代码