v.25.12Bug Fix (user-visible misbehavior in an official stable release)
Now ClickHouse will not use read-in-order optimization
Official CH changelog text
Now ClickHouse will not use read-in-order optimization for iceberg if sort order is not specified manifest files (or not the same) with default_sort_order in table. Fixes #89178. #90304 (alesapin).