为物化视图创建同义词，create、select成功，refresh失败，报错：releation dose not exist

【标题描述】:
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本：2.0.0】 问题描述

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

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

【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
![输入图片说明](https://foruda.gitee.com/images/1680233742512170727/856dec8f_11437232.png "屏幕截图")
【预置条件】:
--建表;
create table tab_1137478(id int unique,a1 varchar(20));
--创建视图;
create view v_1137478 as select * from tab_1137478;
create incremental materialized view imv_1137478 as select * from tab_1137478;
--为视图v创建视图v1;
create view v1_1137478 as select * from v_1137478;
--为视图v1创建物化视图mv;
create materialized view mv_1137478 as select * from v1_1137478;
--为物化视图mv、imv创建视图v2、v3;
create view v2_1137478 as select * from mv_1137478;
create view v3_1137478 as select * from imv_1137478;
--为物化视图mv、imv创建物化视图mv1、mv2;
create materialized view mv1_1137478 as select * from mv_1137478;
create materialized view mv2_1137478 as select * from imv_1137478;
【操作步骤】(请填写详细的操作步骤):
--为视图创建同义词;
create synonym s1 for v_1137478;
create synonym s2 for v1_1137478;
create synonym s3 for v2_1137478;
create synonym s4 for v3_1137478;
create synonym s5 for mv_1137478;
create synonym s6 for mv1_1137478;
create synonym s7 for mv2_1137478;
create synonym s8 for imv_1137478;
--insert;
insert into s2 values(1,'a');
--select;
select * from tab_1137478;
select * from s1;
select * from s2;
select * from s3;
select * from s4;
select * from s5;
select * from s6;
select * from s7;
select * from s8;
REFRESH MATERIALIZED VIEW s8;
REFRESH MATERIALIZED VIEW s5;
REFRESH MATERIALIZED VIEW s6;
REFRESH MATERIALIZED VIEW s7;
select * from v_1137478;
select * from v1_1137478;
select * from v2_1137478;
select * from v3_1137478;
select * from mv_1137478;
select * from mv1_1137478;
select * from mv2_1137478;
select * from imv_1137478;

【预期输出】:
--refresh成功
【实际输出】:
![输入图片说明](https://foruda.gitee.com/images/1680233793912609685/4865c69d_11437232.png "屏幕截图")
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (4)

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

内容风险标识