mars
MARS-477
vComisionAyudantesByJtp SA-join fix
Done normal
dmdb-mars-cc
Surfaced during db02-mars-cc's MARS-17 unused-view re-verification (2026-07-16): vComisionAyudantesByJtp needs an SA-join fix per db-efficiency-audit.md:67, not currently dead — excluded from the MARS-15/16/17 view-drop batch on that basis. Filing as its own tracked item since db02's assumed 'MARS-21/academic-core lane' reference was stale (MARS-21 is an unrelated, already-closed JTP live-vs-snapshot WI).
Activity
-
Already fixed in the live view. pg_get_viewdef shows vComisionAyudantesByJtp joining studentAssignments sa and projecting sa.assignedTeacherUserId AS jtpUserId with sa.ayudanteUserId, guarded by sa.deletedAt IS NULL, both user joins filtered on users.deletedAt IS NULL, plus NOT NULL guards on both ids and an ayudante<>jtp self-pair exclusion. That is the studentAssignments-join shape the WI asked for; there is no role-table derivation left in it.
bug
2026-07-16 by wi-cli-venus
5w ago
2026-09-11 10:40