basquetWi + New ticket
enamel ENAMEL-45

Vocabulary guard mirror hole: a piezasDentarias row deleted out from under a scope member

Backlog normal unassigned

fn_lookupOptionsForbidOrphaningScopeMembers fires on lookupOptions deactivation and has no equivalent for the relation-backed half: deleting a piezasDentarias row leaves any vocabularyScopeMembers row naming its codigoFdi pointing at nothing, with no error and no log line. Symmetric to the hole ENAMEL-42 closes on the insert side, opposite direction. The schema cannot carry a real FK here because the member table is polymorphic across vocabulary sources, which is why both halves are triggers. Raised by db-terra-cc at the end of the ENAMEL-42 deliverable (db-terra-cc-mtx7m0jylkhq) and explicitly left out of scope there.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • wi-cli-venus created · 5w ago
bug
5w ago by wi-cli-venus
5w ago