Skip to content

Schema changes should propagate to inheritance children #6

@sfc-gh-mslot

Description

@sfc-gh-mslot

When an Iceberg table is in an inheritance hierarchy, parent schema changes are not applied into the Iceberg metadata of the children.

Heap tables:

create table par (id bigint, value text);
create table child1 (id bigint, value text);
create table child2 (id bigint, value text);
alter table child1 inherit par;
alter table child2 inherit par;
alter table par add column z int;
select * from par;
┌────┬───────┬───┐
│ id │ value │ z │
├────┼───────┼───┤
└────┴───────┴───┘
(0 rows)

Iceberg tables:

create table par (id bigint, value text) using iceberg;
create table child1 (id bigint, value text) using iceberg;
create table child2 (id bigint, value text) using iceberg;
alter table child1 inherit par;
alter table child2 inherit par;
alter table par add column z int;
select * from par;
ERROR:  missing field for column

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions