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

Fix logical error

Fix logical error in cross join reordering when query_plan_optimize_join_order_limit > 1, Close #89409. #88286 (Vladimir Cherkasov).