【测试类型：SQL功能】【测试版本：5.1.1】timescaleDB 插件不支持同时在两个库中创建

【标题描述】: timescaleDB 插件不支持同时在两个库中创建
【测试类型：工具功能】【测试版本：5.1.1】 问题描述：timescaleDB 插件不支持同时在两个库中创建

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
CentOS Linux release 7.6.1810 (Core)
Linux ctumhispra01218 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

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

【被测功能】:
timescaledb插件创建

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
![输入图片说明](https://foruda.gitee.com/images/1702006579675923543/2314e133_10825457.png "屏幕截图")

【预置条件】:
timescaledb插件安装成功

【操作步骤】(请填写详细的操作步骤):
1. 分别创建2个兼容pg库
create database test1 dbcompatibility 'pg';
create database test2 dbcompatibility 'pg';

2. 在test1、test2下分别创建timescaledb插件
create extension timescaledb;
![输入图片说明](https://foruda.gitee.com/images/1702006707992336672/56489b4d_10825457.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1702006731136102354/c0a7bc4e_10825457.png "屏幕截图")

【预期输出】:
1.test1、test2兼容pg库创建成功
2.在test1、test2库下插件timescaledb均创建成功

【实际输出】:
1.test1、test2兼容pg库创建成功
![输入图片说明](https://foruda.gitee.com/images/1702006761980302303/636021d8_10825457.png "屏幕截图")
2. test1创建timescaledb成功、test2创建timescaledb失败
![输入图片说明](https://foruda.gitee.com/images/1702006874175527531/009a4c2c_10825457.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1702006892046604282/5c7228bc_10825457.png "屏幕截图")
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

【测试代码】:

验收结论：通过
验收版本：
6.0.0B029
验收过程

```
openGauss=# create database test1 dbcompatibility 'pg';
CREATE DATABASE
openGauss=# create database test2 dbcompatibility 'pg';
CREATE DATABASE
openGauss=# \c test1
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "test1" as user "lhj".
test1=# create extension timescaledb;
WARNING:
WELCOME TO
 _____ _                               _     ____________
|_   _(_)                             | |    |  _  \ ___ \
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ /
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
               Running version 1.7.4
For more information on TimescaleDB, please visit the following links:

1. Getting started: https://docs.timescale.com/getting-started
 2. API reference documentation: https://docs.timescale.com/api
 3. How TimescaleDB is designed: https://docs.timescale.com/introduction/architecture

Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescaledb.com/using-timescaledb/telemetry.

CREATE EXTENSION
test1=# \c test2
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "test2" as user "lhj".
test2=#  create extension timescaledb;
WARNING:
WELCOME TO
 _____ _                               _     ____________
|_   _(_)                             | |    |  _  \ ___ \
  | |  _ _ __ ___   ___  ___  ___ __ _| | ___| | | | |_/ /
  | | | |  _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
  | | | | | | | | |  __/\__ \ (_| (_| | |  __/ |/ /| |_/ /
  |_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
               Running version 1.7.4
For more information on TimescaleDB, please visit the following links:

1. Getting started: https://docs.timescale.com/getting-started
 2. API reference documentation: https://docs.timescale.com/api
 3. How TimescaleDB is designed: https://docs.timescale.com/introduction/architecture

Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescaledb.com/using-timescaledb/telemetry.

CREATE EXTENSION

```

openGauss/Plugin
Paused

Content Risk Flag

Comments (5)

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

Content Risk Flag