Linux kwepwebenv08175 4.19.90-2003.4.0.0036.oe1.x86_64 #1 SMP Mon Mar 23 19:10:41 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
一主两备
【被测功能】:
升级
【测试类型】:
自动化
【数据库版本】(查询命令: gaussdb -V):
5.0.3 B001 gsql (openGauss 5.0.3 build 0fda4001) compiled at 2024-07-19 09:47:06 commit 0 last mr
7.0.0-RC1 1108日构建 gsql (openGauss 7.0.0-RC1 build 4be89534) compiled at 2024-11-07 17:33:38 commit 0 last mr
【预置条件】:
数据库状态正常
【操作步骤】(请填写详细的操作步骤):
1. CI部署5.0.3B001升级7.0.0-RC1,校验元数据一致性
【预期输出】:
元数据一致
【实际输出】:
元数据校验不一致,详细如下:
所有sql:
```
select pg_get_ruledef((select oid from pg_rewrite where ev_class = (select oid from pg_classwhere relname = 'statement_complex_history')));
select pg_get_ruledef((select oid from pg_rewrite where ev_class = (select oid from pg_class where relname = 'statement_complex_history_table')));
select pg_get_ruledef((select oidfrom pg_rewrite where ev_class = (select oid from pg_class where relname = 'global_statement_complex_history_table')));
select pg_get_functiondef((select oid from pg_proc where proname = 'get_global_statement_complex_history_table'));
select oid, *from pg_proc whereoid = 3119;
```
**左图为直装,右图为升级**
1. 视图规则存在差异
select pg_get_ruledef((select oid frompg_rewrite where ev_class = (select oid from pg_class where relname = 'statement_complex_history')));
select pg_get_ruledef((select oid from pg_rewrite where ev_class = (select oid from pg_class where relname = 'global_statement_complex_history_table')));