← Ledger
AFP-2026-0001Widenedmaterial

Address normalisation dropped unit numbers

Opened
04 Sept 2026
Dated end
30 Nov 2026
Widenings
1
Organization
2OGS
Filed by
A. Reyes

Summary as filed

The importer stripped everything after the first comma in the street field, discarding unit and apartment numbers. Found while reconciling delivery failures against source records. As filed, believed limited to the January batch.

Current scope: Records ingested via the January CSV importer (18,420 rows)

Timeline

  1. Open04 Sept 2026, 14:52by A. Reyes

    Defect filed.

  2. Widened04 Sept 2026, 14:52by A. Reyes

    Scope widened from "Records ingested via the January CSV importer (18,420 rows)" to "All records ingested via any CSV importer between January and March (41,908 rows)".

Widenings and count-neutrality proofs

Widened — credit04 Sept 2026, 14:52 · A. Reyes

From Records ingested via the January CSV importer (18,420 rows)
To All records ingested via any CSV importer between January and March (41,908 rows)

Evidence: Query run 2026-09-04, attached as audit note 17

BeforeAddedRemovedAfter
18420+23488−041908

18420 + 23488 − 0 = 41908 · reconciles

Count-neutrality proof, in full

The 23,488 added rows are the February and March importer batches, previously excluded because the importer was assumed patched on 31 January. That assumption was wrong: the patch shipped on 4 April. No rows were removed; the original 18,420 remain in the population unchanged, so 18,420 + 23,488 - 0 = 41,908.

Retroactive statements

regional-summary-2026-Q1.csvAuto-generated04 Sept 2026

Affected range: All output of csv-importer at 2026-09-04

Artifact "regional-summary-2026-Q1.csv" was produced by csv-importer, which reported no tool version. Because the producing version cannot be identified, the full output range of that tool on 2026-09-04 must be treated as potentially affected by defect AFP-2026-0001. This statement was generated automatically and awaits review.