测试类型

SQL功能

测试版本

7.0.0-RC2

问题描述

兼容D库INFORMATION_SCHEMA_TSQL.TABLES视图未统计sys下的表信息

操作系统和硬件信息

测试环境

企业版单机

被测功能

SQL功能

预置条件

创建D库及shark插件

操作步骤

openGauss=# create database sql_stest dbcompatibility = 'D';
CREATE DATABASE
openGauss=# \c sql_stest
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "sql_stest" as user "xq_0525".
sql_stest=# create extension shark;
CREATE EXTENSION
create schema sys_view_test_02;
set search_path to sys_view_test_02;
CREATE TABLE employees (
name VARCHAR(50) NOT NULL,
age INT,
salary DECIMAL(10, 2),
-- CHECK 约束：年龄必须 >= 18
CONSTRAINT chk_age CHECK (age >= 18)
);
select table_schema, table_name, table_type
from information_schema_tsql.tables t
inner join pg_namespace s on t.table_schema = s.nspname
where s.nspname = 'sys_view_test_02';
set search_path to sys;
SET
CREATE TABLE employees (
name VARCHAR(50) NOT NULL,
age INT,
salary DECIMAL(10, 2),
-- CHECK 约束：年龄必须 >= 18
CONSTRAINT chk_age CHECK (age >= 18)；
select table_schema, table_name, table_type
from information_schema_tsql.tables t
inner join pg_namespace s on t.table_schema = s.nspname
where s.nspname = 'sys_view_test_02';
select * from INFORMATION_SCHEMA_TSQL.TABLES;

预期输出

统计到sys下的表

实际输出

openGauss=# create database sql_stest dbcompatibility = 'D';
CREATE DATABASE
openGauss=# \c sql_stest
sql_stest=# create extension shark;
CREATE EXTENSION
sql_stest=# create schema sys_view_test_02;
CREATE SCHEMA
set search_path to sys_view_test_02;
SET
sql_stest=# CREATE TABLE employees (
sql_stest(# name VARCHAR(50) NOT NULL,
sql_stest(# age INT,
sql_stest(# salary DECIMAL(10, 2),
sql_stest(# -- CHECK 约束：年龄必须 >= 18
sql_stest(# CONSTRAINT chk_age CHECK (age >= 18)
sql_stest(# );
CREATE TABLE
sql_stest=# select table_schema, table_name, table_type
sql_stest-# from information_schema_tsql.tables t
sql_stest-# inner join pg_namespace s on t.table_schema = s.nspname
sql_stest-# where s.nspname = 'sys_view_test_02';
table_schema | table_name | table_type
------------------+------------+------------
sys_view_test_02 | employees | BASE TABLE
(1 row)

sql_stest=# select table_schema, table_name, table_type
sql_stest-# from information_schema_tsql.tables t
sql_stest-# inner join pg_namespace s on t.table_schema = s.nspname
sql_stest-# where s.nspname = 'sys_view_test_02';
table_schema | table_name | table_type
------------------+------------+------------
sys_view_test_02 | employees | BASE TABLE
(1 row)

sql_stest=# select * from INFORMATION_SCHEMA_TSQL.TABLES;
table_catalog | table_schema | table_name | table_type
---------------+------------------+------------+------------
sql_stest | sys_view_test_02 | employees | BASE TABLE
(1 row)

sql_stest=# set search_path to sys;
SET
sql_stest=# CREATE TABLE employees (
sql_stest(# name VARCHAR(50) NOT NULL,
sql_stest(# age INT,
sql_stest(# salary DECIMAL(10, 2),
sql_stest(# -- CHECK 约束：年龄必须 >= 18
sql_stest(# CONSTRAINT chk_age CHECK (age >= 18)
sql_stest(# );
CREATE TABLE
sql_stest=# select table_schema, table_name, table_type
sql_stest-# from information_schema_tsql.tables t
sql_stest-# inner join pg_namespace s on t.table_schema = s.nspname
sql_stest-# where s.nspname = 'sys_view_test_02';
table_schema | table_name | table_type
------------------+------------+------------
sys_view_test_02 | employees | BASE TABLE
(1 row)

sql_stest=# select * from INFORMATION_SCHEMA_TSQL.TABLES;
table_catalog | table_schema | table_name | table_type
---------------+------------------+------------+------------
sql_stest | sys_view_test_02 | employees | BASE TABLE

日志信息

提单组织

内部测试

测试代码