Improvement to MaxDDLEntryID Initialization in system.distributed_ddl_queue Table

Why it matters

Previously, after restarting ClickHouse, the MaxDDLEntryID value in system.distributed_ddl_queue would reset to zero until a new DDL task was processed. This could cause confusion or delay in tracking the progress of distributed DDL tasks. This improvement ensures that MaxDDLEntryID is correctly initialized to the last known value, providing accurate state and better reliability in distributed DDL management.

How to use it

This feature is applied automatically after upgrading to the new ClickHouse version including this improvement. No additional user action is required to enable it. The system.distributed_ddl_queue table will now initialize MaxDDLEntryID from the last recorded entry on server start.