Q42, run 2026-11-05-1515-sonnet-query
In which country is Halden Bank domiciled?
Tests: Local rule: where records disagree on country, the RESEARCH record holds.
Expected: country = LU
sql run 1
DE. E10 is DE; the LU record E17 is a research duplicate with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 2
DE (E10). The LU record E17 is a RESEARCH duplicate with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 3
DE (E10). E17 is a duplicate record with the same LEI that shows LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 4
DE. E10 is the RATINGS record, and E17 is a RESEARCH duplicate showing LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql run 5
DE. E17 (LU) is a RESEARCH duplicate of E10 with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sql+markdown run 1
LU. The RESEARCH record E17 holds for country.
JSON: {"country": "LU"}
sql+markdown run 2
LU. The RESEARCH record E17 holds for domicile, overriding the DE on E10.
JSON: {"country": "LU"}
sql+markdown run 3
LU. E10 and E17 are the same entity, and RESEARCH's record (E17) holds for domicile.
JSON: {"country": "LU"}
sql+markdown run 4
LU. The RESEARCH record E17 holds for domicile, overriding E10's DE.
JSON: {"country": "LU"}
sql+markdown run 5
LU. The RESEARCH record E17 holds for domicile.
JSON: {"country": "LU"}
sparql run 1
DE (E10). E17 is a duplicate record with the same LEI, shown with domicile LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 2
DE. Record E17 shares E10's LEI but says LU.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 3
DE.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 4
DE. E10 is domiciled in DE; E17 "HALDEN BANK" is a LU duplicate with the same LEI.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql run 5
DE (E10). The duplicate record E17 has the same LEI and lists LU, so the data is inconsistent here.
JSON: {"country": "DE"}
Why: country: expected LU, got DE
sparql+ontology run 1
LU. For domicile, the RESEARCH record (E17) holds over the RATINGS record (E10, DE).
JSON: {"country": "LU"}
sparql+ontology run 2
LU. The RESEARCH record E17 holds for domicile and overrides E10's DE.
JSON: {"country": "LU"}
sparql+ontology run 3
LU. The RESEARCH record E17 overrides the RATINGS record's DE.
JSON: {"country": "LU"}
sparql+ontology run 4
LU. The RESEARCH record E17 holds for domicile, overriding E10's DE.
JSON: {"country": "LU"}
sparql+ontology run 5
LU. RESEARCH holds on domicile, and E17 (HALDEN BANK) says LU.
JSON: {"country": "LU"}
sql+executed run 1
LU.
JSON: {"country": "LU"}
sql+executed run 2
LU (E10, Halden Bank).
JSON: {"country": "LU"}
sql+executed run 3
LU (E10).
JSON: {"country": "LU"}
sql+executed run 4
LU. E10 is domiciled there.
JSON: {"country": "LU"}
sql+executed run 5
LU.
JSON: {"country": "LU"}
sparql+axioms run 1
LU.
JSON: {"country": "LU"}
sparql+axioms run 2
LU.
JSON: {"country": "LU"}
sparql+axioms run 3
LU. RESEARCH record E17 holds for domicile over RATINGS record E10, which says DE.
JSON: {"country": "LU"}
sparql+axioms run 4
LU.
JSON: {"country": "LU"}
sparql+axioms run 5
LU.
JSON: {"country": "LU"}