【测试类型：SQL功能】【测试版本：5.1.1】 b库下创建视图后执行show create view，数据库状态异常

【标题描述】: b库下创建视图后执行show create view，数据库状态异常
【测试类型：SQL功能】【测试版本：5.1.1】 问题描述: b库下创建视图后执行show create view，数据库状态异常

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1908 (Core)
Linux kwemhisprc01300 3.10.0-1062.el7.x86_64 #1 SMP Wed Aug 7 18:08:02 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux

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

【被测功能】:sql功能

【测试类型】:功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 5.1.1 build 812682c6) compiled at 2023-11-01 00:10:12 commit 0 last mr

【预置条件】:数据库状态正常，创建兼容b库

【操作步骤】(请填写详细的操作步骤):
1. 设置参数b_compatibility_user_host_auth为on;
set b_compatibility_user_host_auth = on;

2. 创建用户
create user 'vtest'@'localhost'  identified by 'qwer*963.';
alter user vtest@localhost with sysadmin;

3.建表
drop table if exists chameleon_0012;
create table chameleon_0012(id int comment '字段1', name varchar(20) comment 'col_2');
insert into chameleon_0012 values(10,'tom'),(8,'lili');

4.建视图
create or replace  algorithm = merge DEFINER = 'vtest'@'localhost'  view v_chameleon_0012 as select id,name from chameleon_0012 where id <10 with cascaded check option;

5.查询视图创建语句
show create view v_chameleon_0012;

【预期输出】:
视图创建语句正确显示

【实际输出】:
视图创建语句无法显示
![输入图片说明](https://foruda.gitee.com/images/1698977276712304108/49ff1e03_11685235.png "屏幕截图")

数据库状态异常
![输入图片说明](https://foruda.gitee.com/images/1698977332089157096/5e30f92f_11685235.png "屏幕截图")

产生core文件

```
#0  BBOX_CreateCoredump (file_name=file_name@entry=0x0) at bbox_create.cpp:404
#1  0x000055b3d8d07722 in bbox_handler (sig=<optimized out>, si=0x7f5495e95630, uc=0x7f5495e95500) at gs_bbox.cpp:112
#2  bbox_handler (sig=<optimized out>, si=0x7f5495e95630, uc=0x7f5495e95500) at gs_bbox.cpp:102
#3  <signal handler called>
#4  0x00007f562174b162 in vsnprintf () from /lib64/libc.so.6
#5  0x000055b3d999668b in SecVsnprintfImpl ()
#6  0x000055b3d999484c in vsnprintf_s ()
#7  0x000055b3d862578c in appendStringInfoVA (args=0x7f5495e96388, fmt=0x7f549cbe8f41 " WITH CASCADED CHECK OPTION;", str=0x7f5495e964e8) at stringinfo.cpp:295
#8  appendStringInfo (str=str@entry=0x7f5495e964e8, fmt=fmt@entry=0x7f549cbe8f41 " WITH CASCADED CHECK OPTION;") at stringinfo.cpp:87
#9  0x00007f549c6aaca6 in get_viewdefinfo_oid (viewOid=viewOid@entry=24382, buf=buf@entry=0x7f5495e96500) at ruleutils.cpp:13096
#10 0x00007f549c6b68e6 in gs_get_viewdef_name (fcinfo=0x7f549a412418) at ruleutils.cpp:13124
#11 0x00007f549c7f0b1b in unsigned long ExecMakeFunctionResultNoSets<false, false>(FuncExprState*, ExprContext*, bool*, ExprDoneCond*) () at ../../..//src/include/knl/knl_session.h:3134
#12 0x00007f549c8411e4 in ExecEvalExprSwitchContext (isDone=0x0, isNull=0x7f5495e9689c, econtext=0x7f549a412820, state=0x7f549a412270) at ../../../../src/include/executor/executor.h:386
#13 evaluate_expr(Expr*, unsigned int, int, unsigned int, bool) () at clauses.cpp:4839
#14 0x00007f549c8437b6 in evaluate_function (context=0x7f5495e96c90, func_tuple=0x7f549bc33510, args=0x7f54e5bbc688, input_collid=100, result_collid=100, result_typmod=-1,
    result_type=25, funcid=22377) at clauses.cpp:4303
#15 simplify_function(unsigned int, unsigned int, int, unsigned int, unsigned int, List**, bool, bool, eval_const_expressions_context*) () at clauses.cpp:3753
#16 0x00007f549c8417ba in eval_const_expressions_mutator(Node*, eval_const_expressions_context*) () at clauses.cpp:2610
#17 0x000055b3d8651bb2 in expression_tree_mutator (node=node@entry=0x7f549b17ad30,
    mutator=mutator@entry=0x7f549c841340 <eval_const_expressions_mutator(Node*, eval_const_expressions_context*)>, context=context@entry=0x7f5495e96c90, isCopy=isCopy@entry=true)
    at nodeFuncs.cpp:2778
#18 0x00007f549c841407 in eval_const_expressions_mutator(Node*, eval_const_expressions_context*) () at clauses.cpp:3421
#19 0x000055b3d8652e89 in expression_tree_mutator (node=node@entry=0x7f549b17a5c0,
    mutator=mutator@entry=0x7f549c841340 <eval_const_expressions_mutator(Node*, eval_const_expressions_context*)>, context=context@entry=0x7f5495e96c90, isCopy=isCopy@entry=true)
    at nodeFuncs.cpp:2676
#20 0x00007f549c841407 in eval_const_expressions_mutator(Node*, eval_const_expressions_context*) () at clauses.cpp:3421
#21 0x00007f549c8433b2 in eval_const_expressions (root=<optimized out>, node=<optimized out>) at clauses.cpp:2380
#22 0x00007f549c8105a6 in preprocess_expression (root=0x7f549a9b2050, expr=<optimized out>, kind=1) at planner.cpp:2056
#23 0x00007f549c82305a in subquery_planner(PlannerGlobal*, Query*, PlannerInfo*, bool, double, PlannerInfo**, int, ItstDisKey*, List*) () at planner.cpp:1637
#24 0x00007f549c8279f6 in standard_planner (parse=<optimized out>, cursorOptions=0, boundParams=<optimized out>) at planner.cpp:679
#25 0x00007f549c808aea in pgxc_planner (query=0x7f549b17a270, cursorOptions=0, boundParams=0x0) at pgxcplan_single.cpp:174
#26 0x00007f549c828de5 in planner (parse=0x7f549b17a270, cursorOptions=0, boundParams=0x0) at planner.cpp:407
#27 0x000055b3d90a832c in pg_plan_query(Query*, int, ParamListInfoData*, bool) () at postgres.cpp:1391
#28 0x000055b3d90a8747 in pg_plan_queries(List*, int, ParamListInfoData*) () at postgres.cpp:1526
#29 0x000055b3d90ade76 in exec_simple_query(char const*, MessageType, StringInfoData*) () at postgres.cpp:2833
#30 0x000055b3d90b2c8e in PostgresMain(int, char**, char const*, char const*) () at postgres.cpp:9096
#31 0x000055b3d9003c51 in BackendRun (port=port@entry=0x7f5495e99160) at postmaster.cpp:9412
#32 0x000055b3d9032f98 in GaussDbThreadMain<(knl_thread_role)1> (arg=0x7f54f22c97b0) at postmaster.cpp:11761
#33 0x000055b3d9003cd5 in InternalThreadFunc (args=<optimized out>) at postmaster.cpp:14560
#34 0x00007f5621aa8ea5 in start_thread () from /lib64/libpthread.so.0
#35 0x00007f56217d1b0d in clone () from /lib64/libc.so.6

```

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

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

【测试代码】:

openGauss/Plugin

内容风险标识

评论 (4)

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

内容风险标识