FA-45226 / Data systems / Open access
A non-record intermediate is returned as a successful nested path · case 01
A non-record intermediate is returned as a successful nested path.
ROOT CAUSE
nested-field-path: A non-record intermediate is returned as a successful nested path.
VERIFIED REPAIR
Preserve the stated physical representation and operation order: Resolve an explicit sequence of field path segments against each row dictionary. Dots inside a segment are literal characters; empty path returns the whole row. A missing segment, non-dictionary intermediate, or null intermediate yields None; falsy leaf values remain present.
Unsuccessful approach: Zero is not the absent nested-path result.
Case contract
Resolve an explicit sequence of field path segments against each row dictionary. Dots inside a segment are literal characters; empty path returns the whole row. A missing segment, non-dictionary intermediate, or null intermediate yields None; falsy leaf values remain present.
Why this case matters
A bounded deterministic data engine model makes representation and changelog faults reproducible.
1 / The failure
Exit 1"""Failure Map reference implementation. Python standard library only."""
import json
N = 1
observations = []
def solve(d):
try:
rows,path=d
out=[]
for row in rows:
value=row
for segment in path:
if not isinstance(value,dict): break
if segment not in value: value=None; break
value=value[segment]
out.append(value)
return out
except (IndexError, KeyError, ValueError, StopIteration) as exc:
return {"representation_error": type(exc).__name__}
def check(label, actual, expected):
observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
if N == 1:
check('literal dotted field', solve([[{'a.b': 1, 'a': {'b': 2}}], ['a.b']]), [1])
check('nested homonym', solve([[{'a': {'b': 1}, 'b': 2}], ['a', 'b']]), [1])
check('missing segment', solve([[{'a': {'b': 1}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 1}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 1}], []]), [{'a': 1}])
check('multiple rows', solve([[{'a': 1}, {'a': 2}], ['a']]), [1, 2])
elif N == 2:
check('literal dotted field', solve([[{'a.b': 2, 'a': {'b': 3}}], ['a.b']]), [2])
check('nested homonym', solve([[{'a': {'b': 2}, 'b': 3}], ['a', 'b']]), [2])
check('missing segment', solve([[{'a': {'b': 2}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 2}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 2}], []]), [{'a': 2}])
check('multiple rows', solve([[{'a': 2}, {'a': 3}], ['a']]), [2, 3])
elif N == 3:
check('literal dotted field', solve([[{'a.b': 3, 'a': {'b': 4}}], ['a.b']]), [3])
check('nested homonym', solve([[{'a': {'b': 3}, 'b': 4}], ['a', 'b']]), [3])
check('missing segment', solve([[{'a': {'b': 3}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 3}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 3}], []]), [{'a': 3}])
check('multiple rows', solve([[{'a': 3}, {'a': 4}], ['a']]), [3, 4])
elif N == 4:
check('literal dotted field', solve([[{'a.b': 4, 'a': {'b': 5}}], ['a.b']]), [4])
check('nested homonym', solve([[{'a': {'b': 4}, 'b': 5}], ['a', 'b']]), [4])
check('missing segment', solve([[{'a': {'b': 4}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 4}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 4}], []]), [{'a': 4}])
check('multiple rows', solve([[{'a': 4}, {'a': 5}], ['a']]), [4, 5])
elif N == 5:
check('literal dotted field', solve([[{'a.b': 5, 'a': {'b': 6}}], ['a.b']]), [5])
check('nested homonym', solve([[{'a': {'b': 5}, 'b': 6}], ['a', 'b']]), [5])
check('missing segment', solve([[{'a': {'b': 5}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 5}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 5}], []]), [{'a': 5}])
check('multiple rows', solve([[{'a': 5}, {'a': 6}], ['a']]), [5, 6])
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 fixture | Actual | Expected | Outcome |
|---|---|---|---|
| literal dotted field | [1] | [1] | Passed |
| nested homonym | [1] | [1] | Passed |
| missing segment | [None] | [None] | Passed |
| scalar intermediate | [1] | [None] | Failed |
| zero leaf | [0] | [0] | Passed |
| empty path | [{'a': 1}] | [{'a': 1}] | Passed |
| multiple rows | [1, 2] | [1, 2] | Passed |
SHA-256 / f48f52d3d0a6f7d40edd85c8d3f24bac5ecdb7dadf9e364dd2ce28427f778089
2 / The unsuccessful fix
Exit 1"""Failure Map reference implementation. Python standard library only."""
import json
N = 1
observations = []
def solve(d):
try:
rows,path=d
out=[]
for row in rows:
value=row
for segment in path:
if not isinstance(value,dict): value=0; break
if segment not in value: value=None; break
value=value[segment]
out.append(value)
return out
except (IndexError, KeyError, ValueError, StopIteration) as exc:
return {"representation_error": type(exc).__name__}
def check(label, actual, expected):
observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
if N == 1:
check('literal dotted field', solve([[{'a.b': 1, 'a': {'b': 2}}], ['a.b']]), [1])
check('nested homonym', solve([[{'a': {'b': 1}, 'b': 2}], ['a', 'b']]), [1])
check('missing segment', solve([[{'a': {'b': 1}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 1}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 1}], []]), [{'a': 1}])
check('multiple rows', solve([[{'a': 1}, {'a': 2}], ['a']]), [1, 2])
elif N == 2:
check('literal dotted field', solve([[{'a.b': 2, 'a': {'b': 3}}], ['a.b']]), [2])
check('nested homonym', solve([[{'a': {'b': 2}, 'b': 3}], ['a', 'b']]), [2])
check('missing segment', solve([[{'a': {'b': 2}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 2}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 2}], []]), [{'a': 2}])
check('multiple rows', solve([[{'a': 2}, {'a': 3}], ['a']]), [2, 3])
elif N == 3:
check('literal dotted field', solve([[{'a.b': 3, 'a': {'b': 4}}], ['a.b']]), [3])
check('nested homonym', solve([[{'a': {'b': 3}, 'b': 4}], ['a', 'b']]), [3])
check('missing segment', solve([[{'a': {'b': 3}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 3}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 3}], []]), [{'a': 3}])
check('multiple rows', solve([[{'a': 3}, {'a': 4}], ['a']]), [3, 4])
elif N == 4:
check('literal dotted field', solve([[{'a.b': 4, 'a': {'b': 5}}], ['a.b']]), [4])
check('nested homonym', solve([[{'a': {'b': 4}, 'b': 5}], ['a', 'b']]), [4])
check('missing segment', solve([[{'a': {'b': 4}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 4}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 4}], []]), [{'a': 4}])
check('multiple rows', solve([[{'a': 4}, {'a': 5}], ['a']]), [4, 5])
elif N == 5:
check('literal dotted field', solve([[{'a.b': 5, 'a': {'b': 6}}], ['a.b']]), [5])
check('nested homonym', solve([[{'a': {'b': 5}, 'b': 6}], ['a', 'b']]), [5])
check('missing segment', solve([[{'a': {'b': 5}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 5}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 5}], []]), [{'a': 5}])
check('multiple rows', solve([[{'a': 5}, {'a': 6}], ['a']]), [5, 6])
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 fixture | Actual | Expected | Outcome |
|---|---|---|---|
| literal dotted field | [1] | [1] | Passed |
| nested homonym | [1] | [1] | Passed |
| missing segment | [None] | [None] | Passed |
| scalar intermediate | [0] | [None] | Failed |
| zero leaf | [0] | [0] | Passed |
| empty path | [{'a': 1}] | [{'a': 1}] | Passed |
| multiple rows | [1, 2] | [1, 2] | Passed |
SHA-256 / 917da8a3e10ce15205bf94e6ebd0b622a1aade5105b6fa2b1c13010e18882859
3 / The verified repair
Exit 0"""Failure Map reference implementation. Python standard library only."""
import json
N = 1
observations = []
def solve(d):
try:
rows,path=d
out=[]
for row in rows:
value=row
for segment in path:
if not isinstance(value,dict): value=None; break
if segment not in value: value=None; break
value=value[segment]
out.append(value)
return out
except (IndexError, KeyError, ValueError, StopIteration) as exc:
return {"representation_error": type(exc).__name__}
def check(label, actual, expected):
observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
if N == 1:
check('literal dotted field', solve([[{'a.b': 1, 'a': {'b': 2}}], ['a.b']]), [1])
check('nested homonym', solve([[{'a': {'b': 1}, 'b': 2}], ['a', 'b']]), [1])
check('missing segment', solve([[{'a': {'b': 1}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 1}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 1}], []]), [{'a': 1}])
check('multiple rows', solve([[{'a': 1}, {'a': 2}], ['a']]), [1, 2])
elif N == 2:
check('literal dotted field', solve([[{'a.b': 2, 'a': {'b': 3}}], ['a.b']]), [2])
check('nested homonym', solve([[{'a': {'b': 2}, 'b': 3}], ['a', 'b']]), [2])
check('missing segment', solve([[{'a': {'b': 2}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 2}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 2}], []]), [{'a': 2}])
check('multiple rows', solve([[{'a': 2}, {'a': 3}], ['a']]), [2, 3])
elif N == 3:
check('literal dotted field', solve([[{'a.b': 3, 'a': {'b': 4}}], ['a.b']]), [3])
check('nested homonym', solve([[{'a': {'b': 3}, 'b': 4}], ['a', 'b']]), [3])
check('missing segment', solve([[{'a': {'b': 3}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 3}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 3}], []]), [{'a': 3}])
check('multiple rows', solve([[{'a': 3}, {'a': 4}], ['a']]), [3, 4])
elif N == 4:
check('literal dotted field', solve([[{'a.b': 4, 'a': {'b': 5}}], ['a.b']]), [4])
check('nested homonym', solve([[{'a': {'b': 4}, 'b': 5}], ['a', 'b']]), [4])
check('missing segment', solve([[{'a': {'b': 4}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 4}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 4}], []]), [{'a': 4}])
check('multiple rows', solve([[{'a': 4}, {'a': 5}], ['a']]), [4, 5])
elif N == 5:
check('literal dotted field', solve([[{'a.b': 5, 'a': {'b': 6}}], ['a.b']]), [5])
check('nested homonym', solve([[{'a': {'b': 5}, 'b': 6}], ['a', 'b']]), [5])
check('missing segment', solve([[{'a': {'b': 5}}], ['a', 'z']]), [None])
check('scalar intermediate', solve([[{'a': 5}], ['a', 'b']]), [None])
check('zero leaf', solve([[{'a': 0}], ['a']]), [0])
check('empty path', solve([[{'a': 5}], []]), [{'a': 5}])
check('multiple rows', solve([[{'a': 5}, {'a': 6}], ['a']]), [5, 6])
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 fixture | Actual | Expected | Outcome |
|---|---|---|---|
| literal dotted field | [1] | [1] | Passed |
| nested homonym | [1] | [1] | Passed |
| missing segment | [None] | [None] | Passed |
| scalar intermediate | [None] | [None] | Passed |
| zero leaf | [0] | [0] | Passed |
| empty path | [{'a': 1}] | [{'a': 1}] | Passed |
| multiple rows | [1, 2] | [1, 2] | Passed |
SHA-256 / 93f4416078dd2398fc2349473a16b48a5e0137916852d1ca2931260d0a31e0c6
Verification & scope
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.
Observations recorded using Python 3.12.14 at 2026-09-29T14:44:20.077794+00:00.
Case digest / 8315a13505932948f5eace8b9500537597774952359a96b14449112391a5d750