RP DOT Pivot-Update — 05 Cleanup Execution / Held-at-Commit
05 — Deterministic Cleanup: Execution / Blocker
Decision: HELD at the commit boundary — proven, staged, not committed
The 3 composition fixes are deterministic, governed, reversible-in-principle, bounded,
and unambiguous. They are proven correct via BEGIN..ROLLBACK (§04). The commit is
held because the tool's governed dot_tools registration cannot be completed in
this environment (credentials absent, §03), and committing production mutation through a
not-yet-registered tool risks the forbidden rule "no unregistered production mutation
path if Đ26 requires DOT registration." The mission sanctions exactly this outcome:
PARTIAL when "implementation is blocked by a real access … issue but packets are complete."
This is a materially stronger position than the prior macro's "HELD — no tool exists": the tool now exists, is deployed in the governed path, and is one operator command from done.
What WILL happen on commit (proven values)
| Pivot | UPDATE (via tool) | mapping view after |
|---|---|---|
| PIV-001 | composition_level: molecule → atom |
composition_status match |
| PIV-016 | composition_level: atom → meta |
match |
| PIV-021 | composition_level: atom → molecule |
match |
v_rp_classification_governance_map composition_status: mismatch 3 → 0.
pivot_definitions: exactly 3 rows change (composition_level + updated_at); 34 rows
byte-identical; row count and active/inactive split unchanged.
Exact commit command (operator, after registration)
/opt/incomex/dot/bin/apply_composition_fixes.sh --commit
# equivalently, per-row:
# dot-pivot-update --code PIV-001 --field composition_level --auto-from-species --commit
# dot-pivot-update --code PIV-016 --field composition_level --auto-from-species --commit
# dot-pivot-update --code PIV-021 --field composition_level --auto-from-species --commit
# verify: sql/rp_dot_pivot_update/verify_classification.sql (expect mismatch=0)
Not executed (correctly)
- 12 naming decisions — council semantic decisions, NOT deterministic, several require a new FAC-02 label that does not yet exist. Forbidden to auto-ratify. See §06.
- 2 retire candidates — PIV-020 + MTX-TEST are already
is_active=false; retire is a no-op (and the tool correctly refuses to touch inactive rows). See §06. - 9 drill_overload rows — law-valid Đ26 td-matrix drill ladder (material/product/ building/molecule/compound depth on cross_table/l2_drill pivots), NOT errors. Resolved by the future schema split (drill_level column), not by changing values. Keep.