{"abstract":"MERGE writes payloads as target identities.","category":"Data systems","checks":7,"contract":"Merge source [key,value] into a target unique-key table. Any repeated source key is CARDINALITY and leaves target unchanged; otherwise matched keys replace payloads and unmatched keys insert. Return status and sorted final rows. Source null keys are ordinary distinct keys in this stipulated integer-key model only (inputs here are integer keys).","contract_signature":"d","evaluation_group":"s3-data-systems-merge-statement-preflight","failed_approach":"Correcting only the stored payload still writes to the wrong key.","family":"s3-data-systems-merge-statement-preflight-key-value-swap","id":"FA-45416","implementations":{"attempt":{"sha256":"4996b2a965c5a1fb24d0c4da2ae9ebcbd7b617be8a6c21e7bdc9a62891232437","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\n\nN = 1\nobservations = []\ndef solve(d):\n    try:\n        target,source=d\n        state=dict(target)\n        keys=[k for k,v in source]\n        if len(set(keys))!=len(keys): return ['CARDINALITY',sorted(target)]\n        for key,value in source:\n            state[value]=value\n        return ['OK',sorted([[k,v] for k,v in state.items()])]\n    except (IndexError, KeyError, ValueError, StopIteration) as exc:\n        return {\"representation_error\": type(exc).__name__}\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\nif N == 1:\n    check('matched update', solve([[[10, 1]], [[10, 2]]]), ['OK', [[10, 2]]])\n    check('unmatched insert', solve([[[10, 1]], [[11, 2]]]), ['OK', [[10, 1], [11, 2]]])\n    check('new duplicate keys', solve([[], [[10, 1], [10, 2]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 1]], [[10, 2], [10, 3]]]), ['CARDINALITY', [[10, 1]]])\n    check('duplicate payload not key', solve([[], [[10, 1], [11, 1]]]), ['OK', [[10, 1], [11, 1]]])\n    check('empty source', solve([[[10, 1]], []]), ['OK', [[10, 1]]])\n    check('empty target', solve([[], [[10, 1]]]), ['OK', [[10, 1]]])\nelif N == 2:\n    check('matched update', solve([[[10, 2]], [[10, 3]]]), ['OK', [[10, 3]]])\n    check('unmatched insert', solve([[[10, 2]], [[11, 3]]]), ['OK', [[10, 2], [11, 3]]])\n    check('new duplicate keys', solve([[], [[10, 2], [10, 3]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 2]], [[10, 3], [10, 4]]]), ['CARDINALITY', [[10, 2]]])\n    check('duplicate payload not key', solve([[], [[10, 2], [11, 2]]]), ['OK', [[10, 2], [11, 2]]])\n    check('empty source', solve([[[10, 2]], []]), ['OK', [[10, 2]]])\n    check('empty target', solve([[], [[10, 2]]]), ['OK', [[10, 2]]])\nelif N == 3:\n    check('matched update', solve([[[10, 3]], [[10, 4]]]), ['OK', [[10, 4]]])\n    check('unmatched insert', solve([[[10, 3]], [[11, 4]]]), ['OK', [[10, 3], [11, 4]]])\n    check('new duplicate keys', solve([[], [[10, 3], [10, 4]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 3]], [[10, 4], [10, 5]]]), ['CARDINALITY', [[10, 3]]])\n    check('duplicate payload not key', solve([[], [[10, 3], [11, 3]]]), ['OK', [[10, 3], [11, 3]]])\n    check('empty source', solve([[[10, 3]], []]), ['OK', [[10, 3]]])\n    check('empty target', solve([[], [[10, 3]]]), ['OK', [[10, 3]]])\nelif N == 4:\n    check('matched update', solve([[[10, 4]], [[10, 5]]]), ['OK', [[10, 5]]])\n    check('unmatched insert', solve([[[10, 4]], [[11, 5]]]), ['OK', [[10, 4], [11, 5]]])\n    check('new duplicate keys', solve([[], [[10, 4], [10, 5]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 4]], [[10, 5], [10, 6]]]), ['CARDINALITY', [[10, 4]]])\n    check('duplicate payload not key', solve([[], [[10, 4], [11, 4]]]), ['OK', [[10, 4], [11, 4]]])\n    check('empty source', solve([[[10, 4]], []]), ['OK', [[10, 4]]])\n    check('empty target', solve([[], [[10, 4]]]), ['OK', [[10, 4]]])\nelif N == 5:\n    check('matched update', solve([[[10, 5]], [[10, 6]]]), ['OK', [[10, 6]]])\n    check('unmatched insert', solve([[[10, 5]], [[11, 6]]]), ['OK', [[10, 5], [11, 6]]])\n    check('new duplicate keys', solve([[], [[10, 5], [10, 6]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 5]], [[10, 6], [10, 7]]]), ['CARDINALITY', [[10, 5]]])\n    check('duplicate payload not key', solve([[], [[10, 5], [11, 5]]]), ['OK', [[10, 5], [11, 5]]])\n    check('empty source', solve([[[10, 5]], []]), ['OK', [[10, 5]]])\n    check('empty target', solve([[], [[10, 5]]]), ['OK', [[10, 5]]])\nprint(json.dumps({\"observations\": observations, \"passed\": all(x[\"passed\"] for x in observations)}, ensure_ascii=False))\nraise SystemExit(0 if all(x[\"passed\"] for x in observations) else 1)\n"},"broken":{"sha256":"54bbd6e066adda63023c4a6772bf179558537862c9a312c511f2d1e39772166c","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\n\nN = 1\nobservations = []\ndef solve(d):\n    try:\n        target,source=d\n        state=dict(target)\n        keys=[k for k,v in source]\n        if len(set(keys))!=len(keys): return ['CARDINALITY',sorted(target)]\n        for key,value in source:\n            state[value]=key\n        return ['OK',sorted([[k,v] for k,v in state.items()])]\n    except (IndexError, KeyError, ValueError, StopIteration) as exc:\n        return {\"representation_error\": type(exc).__name__}\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\nif N == 1:\n    check('matched update', solve([[[10, 1]], [[10, 2]]]), ['OK', [[10, 2]]])\n    check('unmatched insert', solve([[[10, 1]], [[11, 2]]]), ['OK', [[10, 1], [11, 2]]])\n    check('new duplicate keys', solve([[], [[10, 1], [10, 2]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 1]], [[10, 2], [10, 3]]]), ['CARDINALITY', [[10, 1]]])\n    check('duplicate payload not key', solve([[], [[10, 1], [11, 1]]]), ['OK', [[10, 1], [11, 1]]])\n    check('empty source', solve([[[10, 1]], []]), ['OK', [[10, 1]]])\n    check('empty target', solve([[], [[10, 1]]]), ['OK', [[10, 1]]])\nelif N == 2:\n    check('matched update', solve([[[10, 2]], [[10, 3]]]), ['OK', [[10, 3]]])\n    check('unmatched insert', solve([[[10, 2]], [[11, 3]]]), ['OK', [[10, 2], [11, 3]]])\n    check('new duplicate keys', solve([[], [[10, 2], [10, 3]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 2]], [[10, 3], [10, 4]]]), ['CARDINALITY', [[10, 2]]])\n    check('duplicate payload not key', solve([[], [[10, 2], [11, 2]]]), ['OK', [[10, 2], [11, 2]]])\n    check('empty source', solve([[[10, 2]], []]), ['OK', [[10, 2]]])\n    check('empty target', solve([[], [[10, 2]]]), ['OK', [[10, 2]]])\nelif N == 3:\n    check('matched update', solve([[[10, 3]], [[10, 4]]]), ['OK', [[10, 4]]])\n    check('unmatched insert', solve([[[10, 3]], [[11, 4]]]), ['OK', [[10, 3], [11, 4]]])\n    check('new duplicate keys', solve([[], [[10, 3], [10, 4]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 3]], [[10, 4], [10, 5]]]), ['CARDINALITY', [[10, 3]]])\n    check('duplicate payload not key', solve([[], [[10, 3], [11, 3]]]), ['OK', [[10, 3], [11, 3]]])\n    check('empty source', solve([[[10, 3]], []]), ['OK', [[10, 3]]])\n    check('empty target', solve([[], [[10, 3]]]), ['OK', [[10, 3]]])\nelif N == 4:\n    check('matched update', solve([[[10, 4]], [[10, 5]]]), ['OK', [[10, 5]]])\n    check('unmatched insert', solve([[[10, 4]], [[11, 5]]]), ['OK', [[10, 4], [11, 5]]])\n    check('new duplicate keys', solve([[], [[10, 4], [10, 5]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 4]], [[10, 5], [10, 6]]]), ['CARDINALITY', [[10, 4]]])\n    check('duplicate payload not key', solve([[], [[10, 4], [11, 4]]]), ['OK', [[10, 4], [11, 4]]])\n    check('empty source', solve([[[10, 4]], []]), ['OK', [[10, 4]]])\n    check('empty target', solve([[], [[10, 4]]]), ['OK', [[10, 4]]])\nelif N == 5:\n    check('matched update', solve([[[10, 5]], [[10, 6]]]), ['OK', [[10, 6]]])\n    check('unmatched insert', solve([[[10, 5]], [[11, 6]]]), ['OK', [[10, 5], [11, 6]]])\n    check('new duplicate keys', solve([[], [[10, 5], [10, 6]]]), ['CARDINALITY', []])\n    check('existing duplicate keys', solve([[[10, 5]], [[10, 6], [10, 7]]]), ['CARDINALITY', [[10, 5]]])\n    check('duplicate payload not key', solve([[], [[10, 5], [11, 5]]]), ['OK', [[10, 5], [11, 5]]])\n    check('empty source', solve([[[10, 5]], []]), ['OK', [[10, 5]]])\n    check('empty target', solve([[], [[10, 5]]]), ['OK', [[10, 5]]])\nprint(json.dumps({\"observations\": observations, \"passed\": all(x[\"passed\"] for x in observations)}, ensure_ascii=False))\nraise SystemExit(0 if all(x[\"passed\"] for x in observations) else 1)\n"}},"limitations":"Offline stipulated semantics over valid small inputs; no performance, concurrency, or production-engine conformance claim. This reproducer isolates one failure mechanism. Results cover the supplied fixtures. Variants within a family share a test contract and should remain grouped when constructing evaluation splits. Related mechanisms with a shared evaluation_group must also remain together; these controlled models are not independent production incidents.","method":"Deterministic executable model with adversarial boundary fixtures.","provenance":{"created_by":"Failure Map","dependencies":"Python standard library","family":"s3-data-systems-merge-statement-preflight-key-value-swap","generated_at":"2026-09-29T14:44:21.988749+00:00","license":"CC0-1.0","python":"3.12.14","seed":1,"split":"open-access"},"relevance":"A bounded deterministic data engine model makes representation and changelog faults reproducible.","root_cause":"merge-statement-preflight: MERGE writes payloads as target identities.","sha256":"7f7adabf7a01aae7157e3794745e247e2a870a66142fe93f625e69437ffe9364","title":"MERGE writes payloads as target identities · case 01","variant":1,"variant_policy":"Five numbered records share a model and may reuse boundary fixtures.","verified":true,"visibility":"public","verification":{"attempt":{"elapsed_ms":46.019,"exit_code":1,"observations":[{"actual":["OK",[[2,2],[10,1]]],"check":"matched update","expected":["OK",[[10,2]]],"passed":false},{"actual":["OK",[[2,2],[10,1]]],"check":"unmatched insert","expected":["OK",[[10,1],[11,2]]],"passed":false},{"actual":["CARDINALITY",[]],"check":"new duplicate keys","expected":["CARDINALITY",[]],"passed":true},{"actual":["CARDINALITY",[[10,1]]],"check":"existing duplicate keys","expected":["CARDINALITY",[[10,1]]],"passed":true},{"actual":["OK",[[1,1]]],"check":"duplicate payload not key","expected":["OK",[[10,1],[11,1]]],"passed":false},{"actual":["OK",[[10,1]]],"check":"empty source","expected":["OK",[[10,1]]],"passed":true},{"actual":["OK",[[1,1]]],"check":"empty target","expected":["OK",[[10,1]]],"passed":false}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"matched update\", \"actual\": [\"OK\", [[2, 2], [10, 1]]], \"expected\": [\"OK\", [[10, 2]]], \"passed\": false}, {\"check\": \"unmatched insert\", \"actual\": [\"OK\", [[2, 2], [10, 1]]], \"expected\": [\"OK\", [[10, 1], [11, 2]]], \"passed\": false}, {\"check\": \"new duplicate keys\", \"actual\": [\"CARDINALITY\", []], \"expected\": [\"CARDINALITY\", []], \"passed\": true}, {\"check\": \"existing duplicate keys\", \"actual\": [\"CARDINALITY\", [[10, 1]]], \"expected\": [\"CARDINALITY\", [[10, 1]]], \"passed\": true}, {\"check\": \"duplicate payload not key\", \"actual\": [\"OK\", [[1, 1]]], \"expected\": [\"OK\", [[10, 1], [11, 1]]], \"passed\": false}, {\"check\": \"empty source\", \"actual\": [\"OK\", [[10, 1]]], \"expected\": [\"OK\", [[10, 1]]], \"passed\": true}, {\"check\": \"empty target\", \"actual\": [\"OK\", [[1, 1]]], \"expected\": [\"OK\", [[10, 1]]], \"passed\": false}], \"passed\": false}\n"},"broken":{"elapsed_ms":46.547,"exit_code":1,"observations":[{"actual":["OK",[[2,10],[10,1]]],"check":"matched update","expected":["OK",[[10,2]]],"passed":false},{"actual":["OK",[[2,11],[10,1]]],"check":"unmatched insert","expected":["OK",[[10,1],[11,2]]],"passed":false},{"actual":["CARDINALITY",[]],"check":"new duplicate keys","expected":["CARDINALITY",[]],"passed":true},{"actual":["CARDINALITY",[[10,1]]],"check":"existing duplicate keys","expected":["CARDINALITY",[[10,1]]],"passed":true},{"actual":["OK",[[1,11]]],"check":"duplicate payload not key","expected":["OK",[[10,1],[11,1]]],"passed":false},{"actual":["OK",[[10,1]]],"check":"empty source","expected":["OK",[[10,1]]],"passed":true},{"actual":["OK",[[1,10]]],"check":"empty target","expected":["OK",[[10,1]]],"passed":false}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"matched update\", \"actual\": [\"OK\", [[2, 10], [10, 1]]], \"expected\": [\"OK\", [[10, 2]]], \"passed\": false}, {\"check\": \"unmatched insert\", \"actual\": [\"OK\", [[2, 11], [10, 1]]], \"expected\": [\"OK\", [[10, 1], [11, 2]]], \"passed\": false}, {\"check\": \"new duplicate keys\", \"actual\": [\"CARDINALITY\", []], \"expected\": [\"CARDINALITY\", []], \"passed\": true}, {\"check\": \"existing duplicate keys\", \"actual\": [\"CARDINALITY\", [[10, 1]]], \"expected\": [\"CARDINALITY\", [[10, 1]]], \"passed\": true}, {\"check\": \"duplicate payload not key\", \"actual\": [\"OK\", [[1, 11]]], \"expected\": [\"OK\", [[10, 1], [11, 1]]], \"passed\": false}, {\"check\": \"empty source\", \"actual\": [\"OK\", [[10, 1]]], \"expected\": [\"OK\", [[10, 1]]], \"passed\": true}, {\"check\": \"empty target\", \"actual\": [\"OK\", [[1, 10]]], \"expected\": [\"OK\", [[10, 1]]], \"passed\": false}], \"passed\": false}\n"}},"member_only":{"stages":["fixed"],"fields":["implementations.fixed","verification.fixed","harness","repair"],"note":"The verified repair, its recorded checks, the repair description, and the scoring harness are available to members."}}