KB-1FA1
D36 NVSZ Macro A — 07 Regression Matrix
4 min read Revision 1
d36regressionmacro-a2026-05-25
D36 NVSZ Macro A — 07 Regression Matrix
Counters: pre vs post
| Counter | Pre | Post (substrate) | Post (proofs) | Δ vs Pre | Expected | Pass |
|---|---|---|---|---|---|---|
information_unit |
175 | 175 | 175 | 0 | 0 | ✓ |
iu_vector_sync_point |
152 | 152 | 152 | 0 | 0 | ✓ |
iu_lifecycle_log |
146 | 146 | 146 | 0 | 0 | ✓ |
knowledge_documents |
4272 | 4272 | 4272 | 0 | 0 | ✓ |
dot_iu_command_catalog |
26 | 30 | 30 | +4 | +4 | ✓ |
birth_registry |
750,964 | 751,008 | 751,008 | +44 | +3 explicit + trigger fan-out | ✓ (44 includes trigger expansion) |
collection_registry |
166 | 168 | 168 | +2 | +2 | ✓ |
entity_species |
41 | 42 | 42 | +1 | +1 | ✓ |
species_collection_map |
162 | 164 | 164 | +2 | +2 | ✓ |
event_type_registry |
26 | 31 | 31 | +5 | +5 | ✓ |
iu_core.iu_staging_record |
n/a | 0 | 3 | +3 | +3 | ✓ |
iu_core.iu_staging_payload |
n/a | 0 | 4 | +4 | +4 | ✓ |
collection_registry_vector_policy |
n/a | 2 | 2 | +2 | +2 | ✓ |
Object-level deltas
| Class | Schema | Pre | Post | Δ |
|---|---|---|---|---|
| BASE TABLE | iu_core | 0 | 2 | +2 |
| VIEW | iu_core | 0 | 2 | +2 |
| ROUTINE | iu_core | 0 | 5 | +5 |
| BASE TABLE | public | 267 | 268 | +1 |
| VIEW | public | 51 | 52 | +1 |
| ROUTINE | public | 496 | 496 | 0 |
d9_total_iu_core = 9 (matches expected 4 tables-as-relations + 2 views + 5 routines per information_schema's broader "tables" category).
Gate state matrix
| Gate | Pre | Post (substrate) | Inside-TX (proofs) | Post (proofs) | Inert end-state |
|---|---|---|---|---|---|
iu_core.staging_writes_enabled |
absent | false | true | false | ✓ |
iu_core.staging_cleanup_enabled |
absent | false | false | false | ✓ |
iu_core.no_vector_staging_excluded |
absent | true | true | true | ✓ (panic always ON) |
Vector boundary regression
| Probe | Pre | Post |
|---|---|---|
iu_vector_sync_point.staging_refs |
0 (no path) | 0 (no path; FK never added) |
v_collection_vector_eligibility for SPE-NVS collections with vector_eligible=true |
0 | 0 |
Qdrant iu_core_iu_chunks count |
(memory: 149) | unchanged (no SQL→Qdrant push from staging) |
| External Qdrant scroll with payload.staging_record_id filter | n/a | deferred to external probe (V6) |
Tests / SSOT / pinning bumps
- App-repo pytest: not run in this macro (no repo clone accessible from this MCP channel).
- SSOT files (
cutter_agent/iu_core/dot_commands.py,_REGISTRY): not bumped. - D9 conformance test (e.g.
test_d9_object_count): expected to need bump from 183 → 191 (or whatever the current SSOT says) — carry-forward.
PR / deploy regression
- PR #669 untouched.
- Nuxt undeployed.
- Directus admin UI unchanged (Q11 A: no Directus UI in Phase 1).
Schema dump evidence
| Stage | sha256 |
|---|---|
| pre-macroA | 57fbae483215898226d5f7a6cb07a4fb2cd10b75a0210d6275415d8df6737bd9 |
| post-macroA | 739a1ae95488248d9ddff38a9689162749aae0ec9d10b1e90c680f6ae4f6c6f8 |
Size delta +21 KB; structurally accounts for: 4 tables (3 new + 1 schema), 3 views, 5 fns, 6 indexes, GRANTS, 21 INSERTs.
Regression PASS
All 4 hard counters (information_unit, iu_vector_sync_point, iu_lifecycle_log, knowledge_documents) are UNCHANGED. The macro is additive-only with respect to existing infra.