FA-120 / Storage and queries / Member archive

A scalar aggregate confuses no observations with a measured zero · case 05

An empty or all-NULL aggregate is rendered as zero, while an attempted repair also erases genuine zero totals.

Member previewVariant 5 · 3 implementations · 7 checks per implementation

Case contract

Return [sum,count_of_non_NULL_values,total_row_count]. Sum is None when there are no non-NULL values, otherwise their exact integer sum, including zero. A scalar aggregate always returns this one triple.

Why this case matters

Uses SQLite to distinguish empty input, NULL rows and zero-valued observations in scalar query results; the intended task is aggregate result semantics, not estimating a missing-data mean.

One recorded failure

Sample boundary fixture

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

Boundary fixture	Actual	Expected	Outcome
no input rows	`[0, 0, 0]`	`[null, 0, 0]`	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.