Field is_obsolete in system.merge_tree_settings table now indicates obsolete settings

Why it matters

Previously, obsolete MergeTree settings were only indicated in their descriptions, which could be unclear or overlooked. Adding the is_obsolete field provides a clear and programmatically accessible way to identify obsolete settings, improving clarity and maintainability for users managing MergeTree configurations.

How to use it

Users can query the system.merge_tree_settings table and check the is_obsolete field. If it is set to 1, the corresponding setting is obsolete and should be avoided or replaced in configuration.

Example query:

SELECT name, is_obsolete FROM system.merge_tree_settings WHERE is_obsolete = 1