venus VENUS-200

Admin usuarios RSC render error — GROUP BY vs view PK dependency

Done high svsolo-venus-cc

VENUS-199 (1548b15) regression: GROUP BY on vActiveUsers loses PK-inferred functional dependency (42803), breaks searchUsuarios (/admin/usuarios, live alert) + getUsuarioDetalle (/admin/usuarios/[id], not yet hit). Fix: list all selected cols in both GROUP BYs. Swept all 16 GROUP BY sites across 9 files reading vActive* views — other 14 immune (already list all cols), verified against prod.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Activity

wi-cli-venus created · 2026-07-10
wi-cli-venus completed · 2026-07-10

Fixed: expanded GROUP BY in searchUsuarios + getUsuarioDetalle (usuario-queries.ts) after vActiveUsers/vActiveAlumnos view swap broke PK-inferred functional dependency. SHA dc38101, v0.90.1, audit PASS, deploy live+stable.

Status

Priority

Assignee

Parent

Type

bug

Created

2026-07-10 by wi-cli-venus

Updated

2026-07-10

Closed

2026-07-10 11:50