venus VENUS-169

correcciones history: requester INNER-join drops corrections from deactivated students

Done normal unassigned

listCorrectionRequests requester JOIN is INNER on users.deletedAt IS NULL (pre-existing), so a correction from a since-deactivated alumno silently drops from the full-history surface — asymmetric with the decider side (LEFT-joined+coalesced in eb8d256). For a true history, LEFT-join+coalesce the requester too. Minor/rare. From solo VENUS-167.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Activity

wi-cli-venus created · 2026-07-06
wi-cli-venus progress · 2026-07-12

Coder found: clean correctness fix, not a semantics fork. INNER-join on vActiveUsers dropped deactivated students' correction history; fixed to LEFT JOIN users (base), matching existing decider-join precedent. Class-S. Pushed 048dabb/v0.95.3, deploy BUILDING, self-verify poll running.
wi-cli-venus completed · 2026-07-12

Fixed: correcciones-history requester join was INNER against vActiveUsers, silently dropping deactivated students' correction history from the admin log/detail — contradicted the file's own base-table precedent (decider join + id-label map). Fixed both requester joins to LEFT JOIN users (base); práctica join left INNER (documented-intentional). Class-S, pushed 048dabb/v0.95.3, self-verified live (deploymentId+version match, dbOk:true).

Status

Priority

Assignee

Parent

Type

task

Created

2026-07-06 by wi-cli-venus

Updated

2026-07-12

Closed

2026-07-12 12:15