FA-44884 / Data systems / Member archive
Pivot sorts categories instead of honoring declared columns · case 04
Pivot sorts categories instead of honoring declared columns.
Case contract
Pivot [row-id,category,value] into [row-id,list-for-category...] using the caller category order. Each cell is an ordered bag list. Unknown categories do not populate cells but retain their row identity; absent cells are empty lists and null values remain elements.
Why this case matters
A bounded deterministic data engine model makes representation and changelog faults reproducible.
One recorded failure
Sample boundary fixtureThis sample comes from the broken implementation of a controlled reproducer.
| Boundary fixture | Actual | Expected | Outcome |
|---|---|---|---|
| column order | [[1, [4], [5]]] | [[1, [5], [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.
Sign in to the archive ↗