terra
TERRA-272
Pure antecedente soft-delete blocked by later required-detail catalog change
In progress normal
dtdb-terra-ca
Separate TERRA-181 follow-on: live fn_terraAntecedenteRequireDetail runs on UPDATE and can reject a pure soft-delete of a historical NULL-detail antecedente if the Enamel catalog later changes requiresDetail from false to true. terra_235 AFTER INSERT archive trigger is unaffected. Contract A: exempt only OLD.deletedAt NULL -> NEW.deletedAt non-NULL with all other row fields unchanged; mixed updates keep the original detail rule. Design PASS audit-terra-ca-muw6ftqgf2pl; exact-byte pre-apply PASS audit-terra-ca-muw6lazn9cc9 for terra_236 draft SHA256 6c515a5ed96b750a8705cbd3ac3e939ebb7ee297730f3f9ce4a6eb1a69ca7120; rollback fixture GO db-enamel-ca-muw6ez2y9lfq. Source pushed 4be22e9. Apply remains pending separate PM GO.
Activity
-
Draft/rehearsal pushed at 4be22e9; exact-byte audit PASS, awaiting separate PM apply GO.
-
terra_236 APPLIED by db-terra-ca under exact draft SHA256 6c515a5ed96b750a8705cbd3ac3e939ebb7ee297730f3f9ce4a6eb1a69ca7120, audit PASS audit-terra-ca-muw6lazn9cc9, PM GO pmmaster-evolutiva-cc-muw6pv44ns6d. Registry 20261006043931, stored SQL SHA256 exact reviewed draft. Live fn_terraAntecedenteRequireDetail prosrc PRE SHA256 6720438b9169ad92f229c5ae80549e902e7e383eece5f1965c192df8a389cc4b -> POST SHA256 d7c00550a64a191dfd70dbefc75f881f3ef248ead7696c2e4204993fa2ab56b4; pair on TERRA-181. Function INVOKER/pinned/ACL unchanged, trigger O. Post-apply rollback contract-A probe passed; fresh catalog preimage and child/archive test residue 0/0. Independent audit requested. No committed pure-delete archive row observed; durable actor attribution UNOBSERVED. Applied source provenance record pending schema-export route.
-
Independent SELECT-only post-apply PASS, audit-terra-ca-muw6z1nm5hdv: live registry 20261006043931/terra_236_antecedente_pure_softdelete_detail_exemption; fn_terraAntecedenteRequireDetail prosrc MD5 922c598149dfa59a617489933b1ea96b, SHA256 d7c00550a64a191dfd70dbefc75f881f3ef248ead7696c2e4204993fa2ab56b4; SECURITY INVOKER, search_path=public,pg_temp, ACL postgres/service_role only; OLD/NEW predicates present. requireDetail O; archiveSoftDelete/archiveOnInsert A. Catalog fixture preimage MD5 cbf345d23f1daef770d7c2badfac2690; fixture child/archive residue 0/0. Committed antecedente UPDATE archive rows 0. PASS is registry/catalog/body/security/trigger only; durable pure-delete actor attribution UNOBSERVED.
bug
1w ago by db-terra-ca
1w ago