v.23.4Improvement

Add Columns and Modify Column Type in system.storage_policies Table

Add columns perform_ttl_move_on_insert, load_balancing for table system.storage_policies, modify column volume_type type to Enum8. #48167 (lizhuoyu5).
Added new columns perform_ttl_move_on_insert and load_balancing to the system.storage_policies table, and changed the volume_type column type to Enum8.

Why it matters

This update enhances the system.storage_policies table by providing additional details about storage policy behavior, such as whether TTL moves are performed on insert and how data load is balanced across volumes. Changing volume_type to Enum8 improves type safety and clarity for volume type representation.

How to use it

Users can query the updated system.storage_policies table to access the newly added perform_ttl_move_on_insert and load_balancing columns directly. The volume_type column now uses the Enum8 type automatically, requiring no manual changes when querying.