FA-45024 / Data systems / Member archive

Full outer join emits already matched right rows again · case 04

Full outer join emits already matched right rows again.

Member previewVariant 4 · 3 implementations · 7 checks per implementation

Case contract

Execute a full outer join of [id,key,value] rows with equality on non-null keys and right.value>=left.value. Track right matches by physical position; failed residuals do not mark a row matched. Emit left-major pairs, then unmatched right rows.

Why this case matters

A bounded deterministic data engine model makes representation and changelog faults reproducible.

One recorded failure

Sample boundary fixture

This sample comes from the broken implementation of a controlled reproducer.

Boundary fixture	Actual	Expected	Outcome
matched then unmatched	`[[10, 20], [11, null], [null, 20]]`	`[[10, 20], [11, null]]`	Failed

MEMBER ARCHIVE

The complete case is available to members.

This record includes three runnable implementations, regression fixtures, execution results, and source hashes.

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