Company or project name

ClickHouse

Use case

It is a blocker before enabling minmax indices by default (#70605).

Describe the solution you'd like

Add a setting secondary_indices_on_columns_alter with values throw, drop, rebuild, ignore.
The setting will be only applicable to ALTER (modify column and update), not to lightweight updates.

The value throw will prevent doing ALTERs of columns covered by secondary indices, as it works today.
The value drop will drop the dependent secondary indices.
The value rebuild acts like dropping and then doing MATERIALIZE INDEX.
The value ignore is intended for professional usage. It will leave the indices in an inconsistent state, allowing incorrect query results.

Describe alternatives you've considered

No response

Additional context

No response