This issue requires an assignee. Since you haven't specified one, we've assigned TestManager as the default assignee for this issue.
Welcome To openGauss Community
Hey @ywzq1161327784 , thanks for your contribution to the community.
Bot Usage Manual
I'm the Bot here serving you. You can find the instructions on how to interact with me at Here . That means you can comment below every pull request or issue to trigger Bot Commands. You can self-configure the PR merge rules for this repository. For more details, please refer to Here.
Contact Guide
If you have any questions, please contact the SIG: Community ,
and any of the maintainers: @CarrotGo, @chendong76, @chenxiaobin19, @congzhou2603, @dodders, @hwworkholic, @jemappellehc, @muyulinzhong, @quemingjian, @shenzheng4, @shirley_zhengx, @superlchf, @totaj, @wlff234, @wofanzheng, @ywzq1161327784 ,
and any of the committers: @Igali, @bihua111, @cailei19, @h_ray, @levy53071, @libiao2024, @lihaixiao, @mrzack, @wangfeihuo, @wuyuechuan, @xiong_xjun, @zhangfengzhi123, @zhangxubo, @zhangzq131, @zjh_hw .
回归时间：2026.09.15
回归结论：通过
回归过程：
20261010转测包自验无误：
全部日志
openGauss=#
openGauss=# drop view if exists t1_view1;
NOTICE: view "t1_view1" does not exist, skipping
DROP VIEW
openGauss=# drop table if exists t1;
NOTICE: table "t1" does not exist, skipping
DROP TABLE
openGauss=# create table t1(f1 int, f2 text, f3 int, f4 bigint, f5 int generated always as (f1 + f3) stored)
openGauss-# with (storage_type=ustore);
CREATE TABLE
openGauss=# insert into t1 values(1, 'aaa', 3, 1);
INSERT 0 1
openGauss=# insert into t1 values(11, 'bbb', 33, 2);
INSERT 0 1
openGauss=# insert into t1 values(111, 'ccc', 333, 3);
INSERT 0 1
openGauss=# insert into t1 values(1111, 'ddd', 3333, 4);
INSERT 0 1
openGauss=# select * from t1;
f1 | f2 | f3 | f4 | f5
------+-----+------+----+------
1 | aaa | 3 | 1 | 4
11 | bbb | 33 | 2 | 44
111 | ccc | 333 | 3 | 444
1111 | ddd | 3333 | 4 | 4444
(4 rows)
openGauss=#
openGauss=#
openGauss=# create view t1_view1 as select * from t1;
CREATE VIEW
openGauss=# select * from t1_view1;
f1 | f2 | f3 | f4 | f5
------+-----+------+----+------
1 | aaa | 3 | 1 | 4
11 | bbb | 33 | 2 | 44
111 | ccc | 333 | 3 | 444
1111 | ddd | 3333 | 4 | 4444
(4 rows)
openGauss=# \d+ t1
Table "public.t1"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+----------------------------------------+----------+--------------+-------------
f1 | integer | | plain | |
f2 | text | | extended | |
f3 | integer | | plain | |
f4 | bigint | | plain | |
f5 | integer | generated always as ((f1 + f3)) stored | plain | |
Has OIDs: no
Options: orientation=row, storage_type=ustore, compression=no, toast.storage_type=ustore
openGauss=# \d+ t1_view1
View "public.t1_view1"
Column | Type | Modifiers | Storage | Description
--------+---------+-----------+----------+-------------
f1 | integer | | plain |
f2 | text | | extended |
f3 | integer | | plain |
f4 | bigint | | plain |
f5 | integer | | plain |
View definition:
SELECT *
FROM t1;
openGauss=# alter table t1 drop f4;
ALTER TABLE
openGauss=# \d+ t1
Table "public.t1"
Column | Type | Modifiers | Storage | Stats target | Description
--------+---------+----------------------------------------+----------+--------------+-------------
f1 | integer | | plain | |
f2 | text | | extended | |
f3 | integer | | plain | |
f5 | integer | generated always as ((f1 + f3)) stored | plain | |
Has OIDs: no
Options: orientation=row, storage_type=ustore, compression=no, toast.storage_type=ustore
openGauss=#
openGauss=# \d+ t1_view1
WARNING: View t1_view1 references invalid table(s), view(s) or column(s).
CONTEXT: referenced column: pg_get_viewdef
View "public.t1_view1"
Column | Type | Modifiers | Storage | Description
--------+---------+-----------+----------+-------------
f1 | integer | | plain |
f2 | text | | extended |
f3 | integer | | plain |
f4 | bigint | | plain |
f5 | integer | | plain |
View definition:
SELECT t1.f1, t1.f2, t1.f3, t1.f4, t1.f5
FROM t1;
openGauss=# alter table t1 add f8 int first, drop f2;
ALTER TABLE
openGauss=# drop view t1_view1;
DROP VIEW
openGauss=# drop table t1;
DROP TABLE
openGauss=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------------------------
(openGauss 7.0.0 build 6a41b1ba) compiled at 2026-10-10 13:02:41 commit 0 last mr 9772 on aarch64-unknown-linux-gnu, compiled by g++ (GCC) 10.3.1, 64-bit
(1 row)
openGauss=#
回归日期：2026.10.14
回归结论：通过
回归过程：
测试类型
SQL功能
测试版本
7.0.0LTS
问题描述
A库alter table执行失败
操作系统和硬件信息
不限
测试环境
企业版单机
被测功能
alter table功能
预置条件
无
操作步骤
预期输出
执行成功
实际输出
日志信息
见实际输出
提单组织
内部开发
测试代码
alter table t1 drop f4, add f7 int;
视图由valid执行上面sql变成invalid，应该展开视图的列名，不应显式*
select * from pg_get_viewdef('t1_view1');