v.24.3Improvement
Check Inner Table Structure When Modifying Materialized Views
While running the MODIFY COLUMN query for materialized views, check the inner table's structure to ensure every column exists. #47427 (sunny).Why it matters
This feature prevents errors and inconsistencies by verifying that every column involved in aMODIFY COLUMN operation on materialized views is present in the underlying inner table, enhancing schema reliability.How to use it
When performing aMODIFY COLUMN query on a materialized view, ClickHouse automatically checks the inner table's columns for existence, so no additional user action is required.