Adding a new column with a default value does not stream changes

[pablomolnar]

Not sure if this is a current known limitation or a bug but here we go:

create table test (id serial primary key, value text);
insert into test (value) values('hello world!');
ALTER TABLE test ADD COLUMN my_new_column text NOT NULL DEFAULT 'foo';

Expected behavior: Since row state changed an new event in Kafka is expected Current behavior: No new event

[badboyd]

Logical decoding cannot replicate DDL changes, so it's a current known limitation. You can read this