测试类型

SQL功能

测试版本

7.0.0LTS

问题描述

set不存在的schema信息，B库desc table_name出现core

操作系统和硬件信息

不限

测试环境

企业版单机

被测功能

desc功能

预置条件

无

操作步骤

创建B库，执行下面的sql

set current_schema to 'test_ansi_quotes';  --不存在的一个schema
CREATE TABLE test_quotes (a text); --建表报错，schema不存在
desc test_quotes --发生core，指定不存在的表

create table test(id int);
set current_schema to 'test_ansi_quotes';
desc test;  --这里指定存在的表信息，也core

预期输出

合理报错

实际输出

core堆栈

(gdb) 
#0  strlen () at ../sysdeps/aarch64/strlen.S:94
#1  0x000000000118ad30 in namehashfast (datum=0) at catcache.cpp:153
#2  0x000000000118b610 in CatalogCacheComputeHashValue (cc_hashfunc=0xfffc1d42a138, nkeys=1, 
    arguments=0xfffc2c9d1c60) at catcache.cpp:356
#3  0x000000000121fb98 in LocalSysTupCache::SearchTupleInternal (this=0xfffc1d42a0b8, nkeys=1, v1=0, v2=0, v3=0, 
    v4=0, level=13) at knl_localsystupcache.cpp:483
#4  0x00000000011d3678 in LocalSysTupCache::SearchLocalCatCTuple (this=0xfffc1d42a0b8, nkeys=1, v1=0, v2=0, v3=0, 
    v4=0, level=13) at ../../../../../src/include/utils/knl_localsystupcache.h:133
#5  0x00000000011d3b40 in LocalSysTabCache::SearchTupleN (this=0xfffc20352090, cache_id=54, nkeys=1, v1=0, v2=0, 
    v3=0, v4=0, level=13) at ../../../../../src/include/utils/knl_localsystabcache.h:271
#6  0x00000000011d38a8 in LocalSysTabCache::SearchTuple (this=0xfffc20352090, cache_id=54, v1=0, v2=0, v3=0, v4=0, 
    level=13) at ../../../../../src/include/utils/knl_localsystabcache.h:216
#7  0x00000000011d0a28 in SearchSysCache (cacheId=54, key1=0, key2=0, key3=0, key4=0, level=13) at syscache.cpp:977
#8  0x00000000011d1764 in GetSysCacheOid (cacheId=54, key1=0, key2=0, key3=0, key4=0) at syscache.cpp:1128
#9  0x0000000000a57ca4 in get_namespace_oid (nspname=0x0, missing_ok=true) at namespace.cpp:3759
#10 0x0000fffd29f74088 in checkTableExistence (classrel=0xfffc14515568) at parse_describe.cpp:692
#11 0x0000fffd29e82468 in base_yyparse (yyscanner=0xfffc145150b0) at gram.y:30119
#12 0x0000fffd29ed3594 in raw_parser (str=0xfffc14514060 "desc test_quotes_2;", 
    query_string_locationlist=0xfffc2c9de768) at parser.cpp:128
#13 0x0000000001beee58 in pg_parse_query (query_string=0xfffc14514060 "desc test_quotes_2;", 
    query_string_locationlist=0xfffc2c9de768, parser_hook=0xfffd29ed3534 <raw_parser(char const*, List**)>)
    at postgres.cpp:1309
#14 0x0000000001bf293c in exec_simple_query (query_string=0xfffc14514060 "desc test_quotes_2;", 
    messageType=QUERY_MESSAGE, msg=0xfffc2c9de9f8) at postgres.cpp:2833
#15 0x0000000001c05514 in ProcessCommandUpperQ (input_message=0xfffc2c9de9f8, 
    send_ready_for_query=@0xfffc2c9de968: false, query_started=@0xfffc2c9de969: true) at postgres.cpp:10108
#16 0x0000000001c04af8 in PostgresMain (argc=1, argv=0xfffc203578b8, dbname=0x0, username=0x0) at postgres.cpp:9870
#17 0x0000000001b117b4 in BackendRun (port=0xfffc2c9def18) at postmaster.cpp:10283
#18 0x0000000001b27828 in GaussDbThreadMain<(knl_thread_role)2> (arg=0xfffd2d4c6478) at postmaster.cpp:15143
#19 0x0000000001b21658 in InternalThreadFunc (args=0xfffd2d4c6478) at postmaster.cpp:15863
#20 0x00000000029ce674 in ThreadStarterFunc (arg=0xfffd2d4c6468) at gs_thread.cpp:383
#21 0x0000fffd3de2878c in start_thread (arg=0xfffd3da3ff40) at pthread_create.c:486
#22 0x0000fffd3dd751bc in thread_start () at ../sysdeps/unix/sysv/linux/aarch64/clone.S:80
(gdb) 

日志信息

详见实际输出

提单组织

内部开发

测试代码