v.25.7Improvement

Allow RENAME COLUMN or DROP COLUMN involving

Do not allow RENAME COLUMN or DROP COLUMN involving explicitly listed columns to sum in SummingMergeTree. Closes #81836. #82821 (Alexey Milovidov).
Prevent renaming or dropping of columns explicitly used in the aggregation key of SummingMergeTree tables.

Why it matters

This feature ensures data integrity and consistency by disallowing RENAME COLUMN or DROP COLUMN operations on columns that are explicitly listed in the aggregation key of SummingMergeTree tables. It protects users from accidental schema changes that could corrupt aggregated data.

How to use it

When managing SummingMergeTree tables, the system will automatically block attempts to RENAME COLUMN or DROP COLUMN if the target column is part of the aggregation key. No additional user action is required besides avoiding unsupported schema modifications.