v.25.11Improvement

Support non_replicated_deduplication_window

Support non_replicated_deduplication_window for tables with a disk that does not implement writing with append. Resolves #87281. #89796 (Tuan Pham Anh).
Support for non_replicated_deduplication_window is extended to tables that use a disk implementation without append-only writing.

Why it matters

This feature addresses the limitation where tables stored on disks not supporting append-only writes could not use the non_replicated_deduplication_window setting. It enables deduplication for such tables, improving data consistency and correctness in non-replicated scenarios.

How to use it

To use this feature, define your table with the non_replicated_deduplication_window setting as usual, even if the table's storage disk does not implement append-only writes. ClickHouse will now support deduplication properly under these conditions.