FAILURE MAP
← Case archive

FA-48091 / Delimited text / Open access

A present empty column is replaced by its default · case 01

A structured table violates the declared record or column contract.

Verified by executionVariant 1 · 7 checks per implementationDownload source bundle ↓JSON ↗

ROOT CAUSE

Empty-string content is conflated with a physically missing field.

VERIFIED REPAIR

Preserve the named invariant at the faulty decision: if i < len(values): out.append(values[i])

Unsuccessful approach: Whitespace folding expands the same missingness mistake.

Case contract

Bind a two-column comma row to [a,b] with per-column defaults. An absent cell uses its default only if its required flag is false; a present empty cell stays empty. Surplus cells reject. Return ordered values. Defaults may be null or lists and must remain typed.

Why this case matters

Delimited interchange needs explicit framing, schema and field semantics at ingestion and emission boundaries.

1 / The failure

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json
def _vary(value):
    if value == '@END': return 3 + 4*N
    if isinstance(value, str): return value.replace('@', 'cell' * N)
    if isinstance(value, list): return [_vary(x) for x in value]
    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}
    return value
N = 1
observations = []
def solve(data):
    values = data['row'].split(',')
    if len(values) > 2: return None
    out = []
    for i in range(2):
        if i < len(values): out.append(values[i] or data['defaults'][i])
        elif data['required'][i]: return None
        else: out.append(data['defaults'][i])
    return out
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
check('missing optional', solve(_vary({'row': '@', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', 'y']))
check('present empty', solve(_vary({'row': '@,', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', '']))
check('missing required', solve(_vary({'row': '@', 'required': [False, True], 'defaults': ['x', 'y']})), _vary(None))
check('typed default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, [1, 2]]})), _vary(['@', [1, 2]]))
check('null default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, None]})), _vary(['@', None]))
check('extra', solve(_vary({'row': 'a,b,c', 'required': [False, False], 'defaults': [0, 1]})), _vary(None))
check('both present', solve(_vary({'row': '@,z', 'required': [True, True], 'defaults': [0, 1]})), _vary(['@', 'z']))
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
missing optional['cell', 'y']['cell', 'y']Passed
present empty['cell', 'y']['cell', '']Failed
missing requiredNoneNonePassed
typed default['cell', [1, 2]]['cell', [1, 2]]Passed
null default['cell', None]['cell', None]Passed
extraNoneNonePassed
both present['cell', 'z']['cell', 'z']Passed

SHA-256 / 7ef086baa6d892b3f8ce4dd31f3db715e8b90a32191446db8f067a2992fd782a

2 / The unsuccessful fix

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json
def _vary(value):
    if value == '@END': return 3 + 4*N
    if isinstance(value, str): return value.replace('@', 'cell' * N)
    if isinstance(value, list): return [_vary(x) for x in value]
    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}
    return value
N = 1
observations = []
def solve(data):
    values = data['row'].split(',')
    if len(values) > 2: return None
    out = []
    for i in range(2):
        if i < len(values): out.append(values[i] if values[i].strip() else data['defaults'][i])
        elif data['required'][i]: return None
        else: out.append(data['defaults'][i])
    return out
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
check('missing optional', solve(_vary({'row': '@', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', 'y']))
check('present empty', solve(_vary({'row': '@,', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', '']))
check('missing required', solve(_vary({'row': '@', 'required': [False, True], 'defaults': ['x', 'y']})), _vary(None))
check('typed default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, [1, 2]]})), _vary(['@', [1, 2]]))
check('null default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, None]})), _vary(['@', None]))
check('extra', solve(_vary({'row': 'a,b,c', 'required': [False, False], 'defaults': [0, 1]})), _vary(None))
check('both present', solve(_vary({'row': '@,z', 'required': [True, True], 'defaults': [0, 1]})), _vary(['@', 'z']))
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
missing optional['cell', 'y']['cell', 'y']Passed
present empty['cell', 'y']['cell', '']Failed
missing requiredNoneNonePassed
typed default['cell', [1, 2]]['cell', [1, 2]]Passed
null default['cell', None]['cell', None]Passed
extraNoneNonePassed
both present['cell', 'z']['cell', 'z']Passed

SHA-256 / ed7462bdaa3f3c18c8f5a81690cd315e52c7f147c4412903d7c5bf1765f84a36

3 / The verified repair

Exit 0
"""Failure Map reference implementation. Python standard library only."""
import json
def _vary(value):
    if value == '@END': return 3 + 4*N
    if isinstance(value, str): return value.replace('@', 'cell' * N)
    if isinstance(value, list): return [_vary(x) for x in value]
    if isinstance(value, dict): return {_vary(k): _vary(v) for k,v in value.items()}
    return value
N = 1
observations = []
def solve(data):
    values = data['row'].split(',')
    if len(values) > 2: return None
    out = []
    for i in range(2):
        if i < len(values): out.append(values[i])
        elif data['required'][i]: return None
        else: out.append(data['defaults'][i])
    return out
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
check('missing optional', solve(_vary({'row': '@', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', 'y']))
check('present empty', solve(_vary({'row': '@,', 'required': [True, False], 'defaults': ['x', 'y']})), _vary(['@', '']))
check('missing required', solve(_vary({'row': '@', 'required': [False, True], 'defaults': ['x', 'y']})), _vary(None))
check('typed default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, [1, 2]]})), _vary(['@', [1, 2]]))
check('null default', solve(_vary({'row': '@', 'required': [False, False], 'defaults': [0, None]})), _vary(['@', None]))
check('extra', solve(_vary({'row': 'a,b,c', 'required': [False, False], 'defaults': [0, 1]})), _vary(None))
check('both present', solve(_vary({'row': '@,z', 'required': [True, True], 'defaults': [0, 1]})), _vary(['@', 'z']))
print(json.dumps({"observations": observations, "passed": all(x["passed"] for x in observations)}, ensure_ascii=False))
raise SystemExit(0 if all(x["passed"] for x in observations) else 1)
Boundary fixtureActualExpectedOutcome
missing optional['cell', 'y']['cell', 'y']Passed
present empty['cell', '']['cell', '']Passed
missing requiredNoneNonePassed
typed default['cell', [1, 2]]['cell', [1, 2]]Passed
null default['cell', None]['cell', None]Passed
extraNoneNonePassed
both present['cell', 'z']['cell', 'z']Passed

SHA-256 / f801dbaa204d403ef7cce6a57d5ee283120fddf28c218c32fcb182f32d2c5088

Verification & scope

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.

Observations recorded using Python 3.12.14 at 2026-09-29T14:44:47.655394+00:00.

Case digest / f858fe4b271563365f62e85de6f82c6c75fc71a8ffd5851d23fce2565090d6e9