FAILURE MAP
← Case archive

FA-37796 / Table interactions / Open access

Table export projection: unknown view row · case 01

The table unknown view row result violates the stipulated table export projection contract.

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

ROOT CAUSE

The unknown view row decision uses '[k for k in by if k in view_ids]' instead of '[k for k in view_ids if k in by]'.

THE FAILURE

The unknown view row decision uses '[k for k in by if k in view_ids]' instead of '[k for k in view_ids if k in by]'.

Unsuccessful approach: The attempted repair '[k for k in view_ids if k in by][:1]' still loses a required part of the table contract.

Case contract

Exports distinguish all source rows from current view rows and selected view rows; preserve view/schema order, omit forbidden columns, optionally include hidden columns, distinguish raw/display values with fallback, and disambiguate duplicate human labels in encounter order.

Why this case matters

An offline table UI model isolates table export projection, including adversarial row/column relationships.

1 / The failure

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json

N = 1
observations = []
def solve(rows, columns, view_ids, scope, hidden, include_hidden, selected, values):
    by={r['id']:r for r in rows}
    ids=[r['id'] for r in rows] if scope=='all' else [k for k in by if k in view_ids]
    if scope=='selected': ids=[k for k in ids if k in selected]
    cols=[c for c in columns if c.get('export',True) and (include_hidden or c['id'] not in hidden)]
    labels=[]; counts={}
    for c in cols:
        label=c['label']; counts[label]=counts.get(label,0)+1
        labels.append(label if counts[label]==1 else label+' ('+str(counts[label])+')')
    records=[]
    for key in ids:
        r=by[key]
        records.append([r.get('_formatted',{}).get(c['id'],r.get(c['id'])) if values=='display' else r.get(c['id']) for c in cols])
    return {'columns':[c['id'] for c in cols],'labels':labels,'records':records,'row_ids':ids,'scope':scope}
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
if N == 1:
    check('filtered view display', solve([{'id':'a','z':1,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 2:
    check('filtered view display', solve([{'id':'a','z':2,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 3:
    check('filtered view display', solve([{'id':'a','z':3,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 4:
    check('filtered view display', solve([{'id':'a','z':4,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 5:
    check('filtered view display', solve([{'id':'a','z':5,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

check('variant formatted export value', solve([{'id':'r','x':N,'_formatted':{'x':'value'+str(N)}}], [{'id':'x','label':'X'}], ['r'], 'view', [], False, [], 'display'), {'columns':['x'], 'labels':['X'], 'records':[['value'+str(N)]], 'row_ids':['r'], 'scope':'view'})
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
filtered view display{'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [['one', 2], [3, 4]], 'row_ids': ['a', 'b'], 'scope': 'view'}{'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'}Failed
selected on view{'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'}{'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'}Passed
all records{'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'}{'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'}Passed
hidden requested{'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'}{'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'}Passed
hidden omitted raw{'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'}{'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'}Passed
no rows{'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'}{'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'}Passed
variant formatted export value{'columns': ['x'], 'labels': ['X'], 'records': [['value1']], 'row_ids': ['r'], 'scope': 'view'}{'columns': ['x'], 'labels': ['X'], 'records': [['value1']], 'row_ids': ['r'], 'scope': 'view'}Passed

SHA-256 / eac5734699f018d64b185dd03c8c695bfdf2d594add58ef809becbd6da905d09

2 / The unsuccessful fix

Exit 1
"""Failure Map reference implementation. Python standard library only."""
import json

N = 1
observations = []
def solve(rows, columns, view_ids, scope, hidden, include_hidden, selected, values):
    by={r['id']:r for r in rows}
    ids=[r['id'] for r in rows] if scope=='all' else [k for k in view_ids if k in by][:1]
    if scope=='selected': ids=[k for k in ids if k in selected]
    cols=[c for c in columns if c.get('export',True) and (include_hidden or c['id'] not in hidden)]
    labels=[]; counts={}
    for c in cols:
        label=c['label']; counts[label]=counts.get(label,0)+1
        labels.append(label if counts[label]==1 else label+' ('+str(counts[label])+')')
    records=[]
    for key in ids:
        r=by[key]
        records.append([r.get('_formatted',{}).get(c['id'],r.get(c['id'])) if values=='display' else r.get(c['id']) for c in cols])
    return {'columns':[c['id'] for c in cols],'labels':labels,'records':records,'row_ids':ids,'scope':scope}
def check(label, actual, expected):
    observations.append({"check": label, "actual": actual, "expected": expected, "passed": actual == expected})
if N == 1:
    check('filtered view display', solve([{'id':'a','z':1,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 2:
    check('filtered view display', solve([{'id':'a','z':2,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 3:
    check('filtered view display', solve([{'id':'a','z':3,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 4:
    check('filtered view display', solve([{'id':'a','z':4,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

if N == 5:
    check('filtered view display', solve([{'id':'a','z':5,'b':2,'_formatted':{'z':'one'}},{'id':'b','z':3,'b':4},{'id':'c','z':5,'b':6}], [{'id':'z','label':'Value'},{'id':'b','label':'Value'}], ['b','a','gone'], 'view', [], False, [], 'display'), {'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'})
    check('selected on view', solve([{'id':'a','z':1},{'id':'b','z':2},{'id':'c','z':3}], [{'id':'z','label':'Z'}], ['b','a'], 'selected', [], False, ['a','c'], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'})
    check('all records', solve([{'id':'a','z':1},{'id':'b','z':2}], [{'id':'z','label':'Z'}], ['b'], 'all', [], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'})
    check('hidden requested', solve([{'id':'a','z':1,'b':2,'p':3}], [{'id':'z','label':'Z'},{'id':'b','label':'B'},{'id':'p','label':'Private','export':False}], ['a'], 'view', ['b'], True, [], 'raw'), {'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'})
    check('hidden omitted raw', solve([{'id':'a','z':0,'b':2,'_formatted':{'z':'zero'}}], [{'id':'z','label':'Z'},{'id':'b','label':'B'}], ['a'], 'view', ['b'], False, [], 'raw'), {'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'})
    check('no rows', solve([], [{'id':'z','label':'Z'}], [], 'view', [], False, [], 'display'), {'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'})

check('variant formatted export value', solve([{'id':'r','x':N,'_formatted':{'x':'value'+str(N)}}], [{'id':'x','label':'X'}], ['r'], 'view', [], False, [], 'display'), {'columns':['x'], 'labels':['X'], 'records':[['value'+str(N)]], 'row_ids':['r'], 'scope':'view'})
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
filtered view display{'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4]], 'row_ids': ['b'], 'scope': 'view'}{'columns': ['z', 'b'], 'labels': ['Value', 'Value (2)'], 'records': [[3, 4], ['one', 2]], 'row_ids': ['b', 'a'], 'scope': 'view'}Failed
selected on view{'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'selected'}{'columns': ['z'], 'labels': ['Z'], 'records': [[1]], 'row_ids': ['a'], 'scope': 'selected'}Failed
all records{'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'}{'columns': ['z'], 'labels': ['Z'], 'records': [[1], [2]], 'row_ids': ['a', 'b'], 'scope': 'all'}Passed
hidden requested{'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'}{'columns': ['z', 'b'], 'labels': ['Z', 'B'], 'records': [[1, 2]], 'row_ids': ['a'], 'scope': 'view'}Passed
hidden omitted raw{'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'}{'columns': ['z'], 'labels': ['Z'], 'records': [[0]], 'row_ids': ['a'], 'scope': 'view'}Passed
no rows{'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'}{'columns': ['z'], 'labels': ['Z'], 'records': [], 'row_ids': [], 'scope': 'view'}Passed
variant formatted export value{'columns': ['x'], 'labels': ['X'], 'records': [['value1']], 'row_ids': ['r'], 'scope': 'view'}{'columns': ['x'], 'labels': ['X'], 'records': [['value1']], 'row_ids': ['r'], 'scope': 'view'}Passed

SHA-256 / cea6f05e9f839e717b539d576e74572a08d227b3c6becd5d8f226184f9a3546d

HELD IN THE MEMBER ARCHIVE

The verified repair and its recorded checks are member-only.

This mechanism has 7 recorded checks per implementation. The open-access tier publishes the failure and the unsuccessful fix; the repaired source that passes every check, and the observations that prove it, are available to members.

Every case sharing this mechanism uses the same contract and the same repair, so this one record is held back for all of them.

Member access is invitation-based. Sign in with your invited account to inspect the repair.

Sign in to the archive ↗

Verification & scope

Source row and schema IDs are unique; this models export projection, not an actual CSV/XLSX writer. Deterministic offline table UI model; no browser, DOM, framework, or standards conformance is claimed. 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:43:05.130126+00:00.

Case digest / 29e1e39931a6586fdf772ea89b87e5a3cbac434e8aab823f75793cff32dde875