{"abstract":"A structured table violates the declared record or column contract.","category":"Delimited text","checks":10,"contract":"Read already lexed cells represented as [text, was_quoted]. Only unquoted NULL is null. An unquoted empty cell is absent, encoded as {missing:True}; quoted empties are empty strings. Unquoted !DEFAULT expands to supplied default. Ordinary whitespace is significant.","evaluation_group":"s3-delimited-text-null-aware-cells","failed_approach":"Changing case rather than spaces still corrupts ordinary cell text.","family":"s3-delimited-text-null-aware-cells-ordinary-text","id":"FA-47461","implementations":{"attempt":{"sha256":"64cb1f1570151cc06c145a1ecd68d7b3f37f7224fbb046d4d0aa1daad5892fd3","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\ndef _vary(value):\n    if value == '@END': return 3 + 4*N\n    if isinstance(value, str): return value.replace('@', 'cell' * N)\n    if isinstance(value, list): return [_vary(x) for x in value]\n    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}\n    return value\nN = 1\nobservations = []\ndef solve(data):\n    out = []\n    for text, quoted in data['cells']:\n        if not quoted and text == 'NULL': out.append(None)\n        elif not quoted and text == '': out.append({'missing': True})\n        elif not quoted and text == '!DEFAULT': out.append(data['default'])\n        else: out.append(text.lower())\n    return out\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('null origin', solve(_vary({'cells': [['NULL', False], ['NULL', True]], 'default': '@'})), _vary([None, 'NULL']))\ncheck('empty origin', solve(_vary({'cells': [['', False], ['', True]], 'default': '@'})), _vary([{'missing': True}, '']))\ncheck('default origin', solve(_vary({'cells': [['!DEFAULT', False], ['!DEFAULT', True]], 'default': '@'})), _vary(['@', '!DEFAULT']))\ncheck('spaces', solve(_vary({'cells': [[' NULL ', False], [' ', True]], 'default': '@'})), _vary([' NULL ', ' ']))\ncheck('case', solve(_vary({'cells': [['null', False]], 'default': '@'})), _vary(['null']))\ncheck('normal', solve(_vary({'cells': [['@', False]], 'default': 'z'})), _vary(['@']))\ncheck('no columns', solve(_vary({'cells': [], 'default': '@'})), _vary([]))\ncheck('bare space', solve(_vary({'cells': [[' ', False]], 'default': '@'})), _vary([' ']))\ncheck('unknown directive', solve(_vary({'cells': [['!hello', False]], 'default': '@'})), _vary(['!hello']))\ncheck('typed default', solve(_vary({'cells': [['!DEFAULT', False]], 'default': 7})), _vary([7]))\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":"175e4ab2a9d0131e07b8f4a20438bf1a0a4d08b84f78c9e027d05a1270643973","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\ndef _vary(value):\n    if value == '@END': return 3 + 4*N\n    if isinstance(value, str): return value.replace('@', 'cell' * N)\n    if isinstance(value, list): return [_vary(x) for x in value]\n    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}\n    return value\nN = 1\nobservations = []\ndef solve(data):\n    out = []\n    for text, quoted in data['cells']:\n        if not quoted and text == 'NULL': out.append(None)\n        elif not quoted and text == '': out.append({'missing': True})\n        elif not quoted and text == '!DEFAULT': out.append(data['default'])\n        else: out.append(text.strip())\n    return out\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('null origin', solve(_vary({'cells': [['NULL', False], ['NULL', True]], 'default': '@'})), _vary([None, 'NULL']))\ncheck('empty origin', solve(_vary({'cells': [['', False], ['', True]], 'default': '@'})), _vary([{'missing': True}, '']))\ncheck('default origin', solve(_vary({'cells': [['!DEFAULT', False], ['!DEFAULT', True]], 'default': '@'})), _vary(['@', '!DEFAULT']))\ncheck('spaces', solve(_vary({'cells': [[' NULL ', False], [' ', True]], 'default': '@'})), _vary([' NULL ', ' ']))\ncheck('case', solve(_vary({'cells': [['null', False]], 'default': '@'})), _vary(['null']))\ncheck('normal', solve(_vary({'cells': [['@', False]], 'default': 'z'})), _vary(['@']))\ncheck('no columns', solve(_vary({'cells': [], 'default': '@'})), _vary([]))\ncheck('bare space', solve(_vary({'cells': [[' ', False]], 'default': '@'})), _vary([' ']))\ncheck('unknown directive', solve(_vary({'cells': [['!hello', False]], 'default': '@'})), _vary(['!hello']))\ncheck('typed default', solve(_vary({'cells': [['!DEFAULT', False]], 'default': 7})), _vary([7]))\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"},"fixed":{"sha256":"b98970a593fb05d078fcc9fdc54c8292a657af691f44a73438939e286aaba864","source":"\"\"\"Failure Map reference implementation. Python standard library only.\"\"\"\nimport json\ndef _vary(value):\n    if value == '@END': return 3 + 4*N\n    if isinstance(value, str): return value.replace('@', 'cell' * N)\n    if isinstance(value, list): return [_vary(x) for x in value]\n    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}\n    return value\nN = 1\nobservations = []\ndef solve(data):\n    out = []\n    for text, quoted in data['cells']:\n        if not quoted and text == 'NULL': out.append(None)\n        elif not quoted and text == '': out.append({'missing': True})\n        elif not quoted and text == '!DEFAULT': out.append(data['default'])\n        else: out.append(text)\n    return out\ndef check(label, actual, expected):\n    observations.append({\"check\": label, \"actual\": actual, \"expected\": expected, \"passed\": actual == expected})\ncheck('null origin', solve(_vary({'cells': [['NULL', False], ['NULL', True]], 'default': '@'})), _vary([None, 'NULL']))\ncheck('empty origin', solve(_vary({'cells': [['', False], ['', True]], 'default': '@'})), _vary([{'missing': True}, '']))\ncheck('default origin', solve(_vary({'cells': [['!DEFAULT', False], ['!DEFAULT', True]], 'default': '@'})), _vary(['@', '!DEFAULT']))\ncheck('spaces', solve(_vary({'cells': [[' NULL ', False], [' ', True]], 'default': '@'})), _vary([' NULL ', ' ']))\ncheck('case', solve(_vary({'cells': [['null', False]], 'default': '@'})), _vary(['null']))\ncheck('normal', solve(_vary({'cells': [['@', False]], 'default': 'z'})), _vary(['@']))\ncheck('no columns', solve(_vary({'cells': [], 'default': '@'})), _vary([]))\ncheck('bare space', solve(_vary({'cells': [[' ', False]], 'default': '@'})), _vary([' ']))\ncheck('unknown directive', solve(_vary({'cells': [['!hello', False]], 'default': '@'})), _vary(['!hello']))\ncheck('typed default', solve(_vary({'cells': [['!DEFAULT', False]], 'default': 7})), _vary([7]))\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":"Deterministic bounded in-memory model. No claim of complete CSV or external format conformance. 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-delimited-text-null-aware-cells-ordinary-text","generated_at":"2026-09-29T14:44:41.755352+00:00","license":"CC0-1.0","python":"3.12.14","seed":1,"split":"open-access"},"relevance":"Delimited interchange needs explicit framing, schema and field semantics at ingestion and emission boundaries.","repair":"Preserve the named invariant at the faulty decision: else: out.append(text)","root_cause":"Normalization changes values after marker recognition.","sha256":"4b2c398855c70ee976f5d53f22f6b6bbbb3ccb71bde3f5a61d50239504a5e374","title":"Ordinary null-aware cells are normalized destructively · case 01","variant":1,"variant_policy":"Five numbered records share a model and may reuse boundary fixtures.","verification":{"attempt":{"elapsed_ms":41.832,"exit_code":1,"observations":[{"actual":[null,"null"],"check":"null origin","expected":[null,"NULL"],"passed":false},{"actual":[{"missing":true},""],"check":"empty origin","expected":[{"missing":true},""],"passed":true},{"actual":["cell","!default"],"check":"default origin","expected":["cell","!DEFAULT"],"passed":false},{"actual":[" null "," "],"check":"spaces","expected":[" NULL "," "],"passed":false},{"actual":["null"],"check":"case","expected":["null"],"passed":true},{"actual":["cell"],"check":"normal","expected":["cell"],"passed":true},{"actual":[],"check":"no columns","expected":[],"passed":true},{"actual":[" "],"check":"bare space","expected":[" "],"passed":true},{"actual":["!hello"],"check":"unknown directive","expected":["!hello"],"passed":true},{"actual":[7],"check":"typed default","expected":[7],"passed":true}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"null origin\", \"actual\": [null, \"null\"], \"expected\": [null, \"NULL\"], \"passed\": false}, {\"check\": \"empty origin\", \"actual\": [{\"missing\": true}, \"\"], \"expected\": [{\"missing\": true}, \"\"], \"passed\": true}, {\"check\": \"default origin\", \"actual\": [\"cell\", \"!default\"], \"expected\": [\"cell\", \"!DEFAULT\"], \"passed\": false}, {\"check\": \"spaces\", \"actual\": [\" null \", \" \"], \"expected\": [\" NULL \", \" \"], \"passed\": false}, {\"check\": \"case\", \"actual\": [\"null\"], \"expected\": [\"null\"], \"passed\": true}, {\"check\": \"normal\", \"actual\": [\"cell\"], \"expected\": [\"cell\"], \"passed\": true}, {\"check\": \"no columns\", \"actual\": [], \"expected\": [], \"passed\": true}, {\"check\": \"bare space\", \"actual\": [\" \"], \"expected\": [\" \"], \"passed\": true}, {\"check\": \"unknown directive\", \"actual\": [\"!hello\"], \"expected\": [\"!hello\"], \"passed\": true}, {\"check\": \"typed default\", \"actual\": [7], \"expected\": [7], \"passed\": true}], \"passed\": false}\n"},"broken":{"elapsed_ms":42.926,"exit_code":1,"observations":[{"actual":[null,"NULL"],"check":"null origin","expected":[null,"NULL"],"passed":true},{"actual":[{"missing":true},""],"check":"empty origin","expected":[{"missing":true},""],"passed":true},{"actual":["cell","!DEFAULT"],"check":"default origin","expected":["cell","!DEFAULT"],"passed":true},{"actual":["NULL",""],"check":"spaces","expected":[" NULL "," "],"passed":false},{"actual":["null"],"check":"case","expected":["null"],"passed":true},{"actual":["cell"],"check":"normal","expected":["cell"],"passed":true},{"actual":[],"check":"no columns","expected":[],"passed":true},{"actual":[""],"check":"bare space","expected":[" "],"passed":false},{"actual":["!hello"],"check":"unknown directive","expected":["!hello"],"passed":true},{"actual":[7],"check":"typed default","expected":[7],"passed":true}],"passed":false,"stderr":"","stdout":"{\"observations\": [{\"check\": \"null origin\", \"actual\": [null, \"NULL\"], \"expected\": [null, \"NULL\"], \"passed\": true}, {\"check\": \"empty origin\", \"actual\": [{\"missing\": true}, \"\"], \"expected\": [{\"missing\": true}, \"\"], \"passed\": true}, {\"check\": \"default origin\", \"actual\": [\"cell\", \"!DEFAULT\"], \"expected\": [\"cell\", \"!DEFAULT\"], \"passed\": true}, {\"check\": \"spaces\", \"actual\": [\"NULL\", \"\"], \"expected\": [\" NULL \", \" \"], \"passed\": false}, {\"check\": \"case\", \"actual\": [\"null\"], \"expected\": [\"null\"], \"passed\": true}, {\"check\": \"normal\", \"actual\": [\"cell\"], \"expected\": [\"cell\"], \"passed\": true}, {\"check\": \"no columns\", \"actual\": [], \"expected\": [], \"passed\": true}, {\"check\": \"bare space\", \"actual\": [\"\"], \"expected\": [\" \"], \"passed\": false}, {\"check\": \"unknown directive\", \"actual\": [\"!hello\"], \"expected\": [\"!hello\"], \"passed\": true}, {\"check\": \"typed default\", \"actual\": [7], \"expected\": [7], \"passed\": true}], \"passed\": false}\n"},"fixed":{"elapsed_ms":44.934,"exit_code":0,"observations":[{"actual":[null,"NULL"],"check":"null origin","expected":[null,"NULL"],"passed":true},{"actual":[{"missing":true},""],"check":"empty origin","expected":[{"missing":true},""],"passed":true},{"actual":["cell","!DEFAULT"],"check":"default origin","expected":["cell","!DEFAULT"],"passed":true},{"actual":[" NULL "," "],"check":"spaces","expected":[" NULL "," "],"passed":true},{"actual":["null"],"check":"case","expected":["null"],"passed":true},{"actual":["cell"],"check":"normal","expected":["cell"],"passed":true},{"actual":[],"check":"no columns","expected":[],"passed":true},{"actual":[" "],"check":"bare space","expected":[" "],"passed":true},{"actual":["!hello"],"check":"unknown directive","expected":["!hello"],"passed":true},{"actual":[7],"check":"typed default","expected":[7],"passed":true}],"passed":true,"stderr":"","stdout":"{\"observations\": [{\"check\": \"null origin\", \"actual\": [null, \"NULL\"], \"expected\": [null, \"NULL\"], \"passed\": true}, {\"check\": \"empty origin\", \"actual\": [{\"missing\": true}, \"\"], \"expected\": [{\"missing\": true}, \"\"], \"passed\": true}, {\"check\": \"default origin\", \"actual\": [\"cell\", \"!DEFAULT\"], \"expected\": [\"cell\", \"!DEFAULT\"], \"passed\": true}, {\"check\": \"spaces\", \"actual\": [\" NULL \", \" \"], \"expected\": [\" NULL \", \" \"], \"passed\": true}, {\"check\": \"case\", \"actual\": [\"null\"], \"expected\": [\"null\"], \"passed\": true}, {\"check\": \"normal\", \"actual\": [\"cell\"], \"expected\": [\"cell\"], \"passed\": true}, {\"check\": \"no columns\", \"actual\": [], \"expected\": [], \"passed\": true}, {\"check\": \"bare space\", \"actual\": [\" \"], \"expected\": [\" \"], \"passed\": true}, {\"check\": \"unknown directive\", \"actual\": [\"!hello\"], \"expected\": [\"!hello\"], \"passed\": true}, {\"check\": \"typed default\", \"actual\": [7], \"expected\": [7], \"passed\": true}], \"passed\": true}\n"}},"verified":true,"visibility":"public"}