Change Version Column Type in VersionedCollapsingMergeTree with ALTER Query

Why it matters

This feature solves the limitation of having a fixed version column type in VersionedCollapsingMergeTree tables, enabling users to modify the version column's data type as needed without recreating the table. It adds flexibility and simplifies schema evolution for versioned collapsing merge trees.

How to use it

Use an ALTER TABLE query to change the type of the version column. For example, you can run:

ALTER TABLE table_name MODIFY COLUMN version_column_name NewDataType