A retried append records its file under a concurrently added partition spec #4188

import tempfile
import pyarrow as pa
from pyiceberg.catalog.sql import SqlCatalog

cat = SqlCatalog("c", uri="sqlite:///:memory:", warehouse=f"file://{tempfile.mkdtemp()}")
cat.create_namespace("ns")
row = lambda x, p, q: pa.table({"x": [x], "p": [p], "q": [q]})
t = cat.create_table("ns.t", schema=row(1, 5, 50).schema)
with t.update_spec() as u:
    u.add_identity("p")

b = cat.load_table("ns.t")
with b.update_spec() as u:
    u.remove_field("p")
    u.add_identity("q")
b.append(row(2, 6, 60))

t.append(row(3, 7, 70))
print(cat.load_table("ns.t").scan(row_filter="q == 70").to_arrow()["x"].to_pylist())
# [], should be [3]
# t's commit retried after b's append, and its file was recorded under b's spec as q=7