FA-45700 / Data systems / Member archive

Top-k maintenance treats score updates as insert-if-absent · case 05

Top-k maintenance treats score updates as insert-if-absent.

Member previewVariant 5 · 3 implementations · 7 checks per implementation

Case contract

Maintain unique-ID scored rows with upsert/delete operations, then report changes to a top-k materialized view. Scores order descending with ascending ID ties. Retractions carry old scores; insertions carry new scores. Score updates within the top-k emit both. Return retractions sorted by ID, then insertions sorted by ID.

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
score changes in view	`[]`	`[[1, 8, -1], [1, 9, 1]]`	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.