Star15
54
代码
代码
Issues61
Pull Requests38
项目讨论
Wiki
分析
Star15
54
已关闭
[Bug]: use_bison_parser=true，深嵌套用例core #312
hcs创建于  8月5日关闭于  8月15日
hcs
hcs成员
8月5日 创建

测试类型

SQL功能

测试版本

7.0.0LTS

问题描述

深嵌套用例core

操作系统和硬件信息

任意

测试环境

oGRAC单节点

被测功能

预置条件

alter system set use_bison_parser=true

操作步骤

create or replace function bison_pl_depth_if_guard(num int) return clob
 	 is
 	     v_lang clob := 'abc';
 	 BEGIN
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     FOR I IN 1 .. num
 	     LOOP
 	     if num > -1 then
 	     if num > 0 then
 	         v_lang := v_lang || 'e';
 	     end if;
 	     end if;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     end loop;
 	     return v_lang;
 	 end;
 	 /

预期输出

Succeed.
Warning:
PL/SQL(SYS.BISON_PL_DEPTH_IF_GUARD) terminated with compiling errors
[260:7] PLC-00943 PL/SQL: block too complex, depth exceed the limitation 128
[392:3] PLC-00954 OTHERS expected but END found
[393:3] PLC-00954 more text expected but EOF found

实际输出

OG-00304, uds connection is closed

日志信息

image.png

提单组织

内部开发

测试代码

likedislike
hcshcs成员
8月5日 添加了label：bug
opengauss_botopengauss_bot成员
8月5日 添加了label：sig/StorageEngine
opengauss_bot
opengauss_bot成员
8月5日 评论：

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.

Contact Guide

If you have any questions, please contact the SIG: StorageEngine ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @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 .

likedislike
hcshcs成员
8月5日 关联了pull request：refactor shared bison grammar glue
hcshcs成员
8月5日 关联了pull request：Fix bounded decoding of protocol strings
sungang14sungang14成员
8月6日 issue优先级由 无优先级 改变为 次要
sungang14sungang14成员
8月6日 issue优先级由 次要 改变为 主要
sungang14sungang14成员
8月6日 关联了看板：openGauss 7.0.0-LTS
hcs
hcs成员
8月12日 评论：

image.png

likedislike
hcshcs成员
8月12日 issue状态由 待办的 改变为 待回归
hcshcs成员
8月14日 关联了pull request：Refactor bison ALTER SYSTEM parameter verification
hcshcs成员
8月14日 删除了关联的pull request：Refactor bison ALTER SYSTEM parameter verification
czywj
czywj成员
8月15日 评论：

回归版本：7.0.0LTS B018
结论：通过
image.png

likedislike
czywjczywj成员
8月15日 issue状态由 待回归 改变为 已验收
czywjczywj成员
8月15日 关闭了 issue