FA-147 / Storage and queries / Member archive

A row filter removes contributions before a group threshold is evaluated · case 02

A group made of individually small contributions disappears even though its total meets the reporting threshold.

Member previewVariant 2 · 3 implementations · 7 checks per implementation

Case contract

Rows are [group_string,signed_integer_amount]. Return a map of existing groups to their full sum, keeping groups whose sum is >= threshold. Never invent groups for empty input; negative contributions must participate before filtering.

Why this case matters

A deterministic model of WHERE versus HAVING placement and inclusive reporting thresholds. It exercises query rewriting correctness when filters do not commute with aggregation, including signed adjustments.

One recorded failure

Sample boundary fixture

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

Boundary fixture	Actual	Expected	Outcome
small contributions jointly qualify	`{}`	`{"a": 4}`	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.