v.25.8Bug Fix (user-visible misbehavior in an official stable release)

Fix write with append

Fix write with append (in MergeTree used for experimental transactions) with plain_rewritable/plain metadata types, previously they were simply ignored. #83695 (Tuan Pham Anh).