UNKNOWN_TABLE in chained FULL OUTER JOINs with object_storage_cluster_join_mode = 'local'

[alsugiliazova]

Describe the bug

SELECT
    h.string_col,
    h.long_col AS hybrid_long,
    m.long_col AS mt_long,
    i.long_col AS iceberg_long
FROM database_39afd42b_d5d6_11f0_b919_e0c26496f172.`namespace_39afe1b3_d5d6_11f0_9b00_e0c26496f172.table_39afe20a_d5d6_11f0_8208_e0c26496f172` AS h
FULL OUTER JOIN merge_tree_table_3ef2c546_d5d6_11f0_b816_e0c26496f172 AS m ON h.string_col = m.string_col
FULL OUTER JOIN database_39afd42b_d5d6_11f0_b919_e0c26496f172.`namespace_39afe1b3_d5d6_11f0_9b00_e0c26496f172.table_39afe20a_d5d6_11f0_8208_e0c26496f172` AS i ON h.string_col = i.string_col
LIMIT 10
SETTINGS object_storage_cluster_join_mode = 'local', object_storage_cluster = 'replicated_cluster'

Query id: 256b0c6d-0d77-4cc7-8cdd-6081eef42257


Elapsed: 0.053 sec. 

Received exception from server (version 25.8.9):
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Received from clickhouse2:9000. DB::Exception: Unknown table expression identifier 'default.merge_tree_table_3ef2c546_d5d6_11f0_b816_e0c26496f172' in scope SELECT __table1.string_col AS string_col, __table1.long_col AS long_col FROM icebergS3Cluster('replicated_cluster', 'http://minio:9000/warehouse/data_hybrid/', 'admin', '[HIDDEN]', 'Parquet', '`boolean_col` Nullable(Bool), `long_col` Nullable(Int64), `double_col` Nullable(Float64), `string_col` String, `timestamp_col` Nullable(DateTime64(6)), `date_col` Nullable(Date), `time_col` Nullable(Int64), `timestamptz_col` Nullable(DateTime64(6, \'UTC\')), `integer_col` Nullable(Int32), `float_col` Nullable(Float32), `decimal_col` Nullable(Decimal(10, 2))', SETTINGS iceberg_metadata_file_path = 'metadata/00001-b73e151a-4ee0-41cb-ac48-d9aee7bb914a.metadata.json') AS __table1 ALL FULL OUTER JOIN default.merge_tree_table_3ef2c546_d5d6_11f0_b816_e0c26496f172 AS __table2 ON __table1.string_col = __table2.string_col LIMIT _CAST(10, 'UInt64') SETTINGS object_storage_cluster_join_mode = 'local'. (UNKNOWN_TABLE)