Q32, run 2026-11-04-1712-sonnet
Who is Halden Leasing's ultimate parent?
Tests: Groups: the chain of parents, two levels up.
Expected: parent = E09
✅ R1
csv run 1
E09, via E11 to E10 to E09.
JSON: {"parent": "E09"}
✅ R1
csv run 2
E09. E11's parent is E10, whose parent is E09.
JSON: {"parent": "E09"}
✅ R1
csv run 3
E09. E11 has parent E10, and E10 has parent E09.
JSON: {"parent": "E09"}
✅ R1
csv run 4
E09. E11 has parent E10, which has parent E09.
JSON: {"parent": "E09"}
✅ R1
csv run 5
E09 (E11 → E10 → E09).
JSON: {"parent": "E09"}
✅ R10
executed run 1
E09.
JSON: {"parent": "E09"}
✅ R10
executed run 2
E09, Halden Group plc.
JSON: {"parent": "E09"}
✅ R10
executed run 3
E09 (ultimate_parent_id for E11).
JSON: {"parent": "E09"}
✅ R10
executed run 4
E09 (E11's ultimate_parent_id).
JSON: {"parent": "E09"}
✅ R10
executed run 5
E09 (the entities table gives E09 as the ultimate parent of E11).
JSON: {"parent": "E09"}