FAILURE MAP
← Case archive

FA-44977 / Data systems / Member archive

Merge join matches only the first row of a repeated right key · case 02

Merge join matches only the first row of a repeated right key.

Member previewVariant 2 · 3 implementations · 7 checks per implementation

Case contract

Join two key-sorted non-null relations [key,id] by matching equal-key runs. Emit the full left-major Cartesian product for each matching run. Advance the lower unmatched run and preserve physical order within equal-key runs.

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 fixtureActualExpectedOutcome
duplicate runs[[10, 20], [11, 20]][[10, 20], [10, 21], [11, 20], [11, 21]]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.

Sign in to the archive ↗