v.19.5Improvement

Keep Ordinary, Default, MATERIALIZED and ALIAS Columns in a Single List

Keep ordinary, DEFAULT, MATERIALIZED and ALIAS columns in a single list (fixes issue #2867). #4707 (Alex Zatelepin)
ClickHouse now keeps ordinary, DEFAULT, MATERIALIZED, and ALIAS columns in a single list, improving metadata consistency.

Why it matters

This feature fixes an issue where columns with different default expressions were managed separately, causing inconsistencies. By unifying these columns into one list, it ensures better integrity and simplifies internal column handling.

How to use it

This improvement is automatic and requires no configuration changes. Users benefit from it transparently when defining tables with DEFAULT, MATERIALIZED, or ALIAS columns.