SC 500 on /admin/solicitudes/[id] — getAccessRequestMergeCandidates throws on NULL legajo (untyped $2 IS NOT NULL)

Sub-tickets

Questions

Activity

• wi-cli-venus created · 2026-06-06
• wi-cli-venus statusChanged · 2026-06-06
  Root cause confirmed. digest 412793870 = pg 'could not determine data type of parameter $2'. getAccessRequestMergeCandidates (admin-actions.ts ~2635): $2=legajo NULL, bare '$2 IS NOT NULL' (lines ~2657/2666) untyped → pg can't infer. Fix: cast to $2::text IS NOT NULL both sites. Repros for any pending solicitud with NULL legajo. coder-pluto-cc owns fix, db+audit investigated.
• wi-cli-venus assigned · 2026-06-06
  coder-pluto-cc
• wi-cli-venus completed · 2026-06-06
  Fixed + deployed. SHA c076f5b v1.63.2. (1) legajo fix: $2::text IS NOT NULL both sites in getAccessRequestMergeCandidates — pg 'could not determine data type of parameter $2' on NULL legajo for pending solicitudes (digest 412793870). (2) pnpm-workspace.yaml: allowBuilds entries set to false (pnpm 11.5.2 scaffolding), dropped wrong-key ignoredBuiltDependencies — deps-check was blocking all pushes. audit PTD PASS: build READY 49s, install clean, runtime error-free, /admin/solicitudes/[id] in manifest.