v.25.6Improvement

Support s3_plain_rewritable storage with projections

Implement support for s3_plain_rewritable storage with projections. In previous versions, metadata objects in S3 referencing projections would not get updated when moved. Closes #70258. #80393 (Sav).
Added support for s3_plain_rewritable storage to properly handle projections by updating metadata objects in S3 when they are moved.

Why it matters

Previously, metadata objects in S3 that referenced projections were not updated when moved, leading to inconsistencies. This feature ensures metadata coherence for projections stored using s3_plain_rewritable, improving reliability and correctness when working with projections in S3 storage.

How to use it

Use the s3_plain_rewritable storage configuration as usual for tables with projections stored in S3. The system will now automatically update related projection metadata objects upon moves without additional user action.