Q32, run 2026-11-04-1738-sonnet
Who is Halden Leasing's ultimate parent?
Tests: Groups: the chain of parents, two levels up.
Expected: parent = E09
csv run 1
E09. E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
csv run 2
E09. E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
csv run 3
E09. E11 sits under E10, which sits under E09.
JSON: {"parent": "E09"}
csv run 4
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
csv run 5
E09. E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
csv+markdown run 1
E09. E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
csv+markdown run 2
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
csv+markdown run 3
E09 (E11 → E10 → E09).
JSON: {"parent": "E09"}
csv+markdown run 4
E09. E11's parent is E10, and E10's parent is E09.
JSON: {"parent": "E09"}
csv+markdown run 5
E09. E11's parent is E10 and E10's parent is E09.
JSON: {"parent": "E09"}
executed run 1
E09. E11's parent is E10, whose parent is E09 (the ultimate_parent_id).
JSON: {"parent": "E09"}
executed run 2
E09 (ultimate_parent_id for E11).
JSON: {"parent": "E09"}
executed run 3
E09.
JSON: {"parent": "E09"}
executed run 4
E09. Both E11's ultimate_parent_id and E10's parent_id point to it.
JSON: {"parent": "E09"}
executed run 5
E09 (E11 → E10 → E09).
JSON: {"parent": "E09"}