FA-158 / Storage and queries / Member archive

String-encoded composite keys merge unrelated groups · case 03

Distinct two-column groups collapse together because their concatenated or delimiter-separated key strings coincide.

Member previewVariant 3 · 3 implementations · 7 checks per implementation

Case contract

Rows contain [first_string,second_string,integer_amount]. Group by exact ordered pairs and return sorted [first,second,total] rows. Components may be empty or contain delimiter characters; input occurrences are all counted.

Why this case matters

Models compound keys in aggregation caches and client-side query engines. The fixtures expose both simple concatenation collisions and delimiter collisions without relying on hash collisions or randomized behavior.

One recorded failure

Sample boundary fixture

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

Boundary fixture	Actual	Expected	Outcome
unseparated component boundaries collide	`[["ab", "c", 7]]`	`[["a", "bc", 4], ["ab", "c", 3]]`	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.