mars MARS-472

vStudentAssignments/vTeacherComisionMemberships missing users.deletedAt IS NULL predicate

Done normal dmdb-mars-cc

audit-mars-ca found during SOP-27 cleanup: vStudentAssignments + vTeacherComisionMemberships JOIN users without users.deletedAt IS NULL predicate (schema.md ~1344/1386) - soft-deleted people/slots stay visible in rosters. Harmless for the just-executed batch (dependent rows were soft-deleted in-tx) but a latent leak for future soft-deletes. Class-A (view DDL): add predicate + re-export schema.md/refdata. Hold for token pause to lift per db-mars-cc.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 4w ago
wi-cli-venus assigned · 4w ago

db-mars-cc / db
wi-cli-venus commented · 4w ago

Reassigned coder-mars-cc→db-mars-cc: Class-A view DDL is db-owned; coder-mars-cc already carries 471/474/473/355/475+ backlog. Elazar go-dispatch 2026-07-16.
wi-cli-venus completed · 4w ago

db-mars-cc mig 050, audit design-GO'd + verification accepted, pushed coder-mars-cc e06043d (v2.30.5). 0 leak rows, grants unchanged (07-15 cleanup had already cascaded dependents; fix is the boundary invariant). Landed ~75min before this close, missed in real-time tracking.

Status

Priority

Assignee

Parent

Type

bug

Created

4w ago by wi-cli-venus

Updated

4w ago

Closed

2026-07-16 13:55