pluto
PLUTO-677
P0: fn_insertSupportTicket ambiguous id column broke all support-ticket creation
Done high
unassigned
RETURNS TABLE(id uuid,...) implicitly declared id as PL/pgSQL OUT-param; unqualified RETURNING "id" in the INSERT collided with it (42702). Broken since mig 095 deploy 2026-07-30 (6578be1), zero successful ticket inserts for 4 days on both /soporte and admin create-on-behalf, caught via applog alert 2026-08-03. Fixed mig 103 (RETURNING "supportTickets"."id"), pre-apply reviewed GO by audit-pluto-ca, applied+verified live by db-pluto-cc with real codes (real id returned, rolled back).
Questions
No questions.
Activity
-
Fixed + verified live: mig 103 applied to prod, real-code repro confirms INSERT+RETURNING now succeeds (no 42702). Support-ticket creation restored on both /soporte and admin create-on-behalf.
-
1
1
2w ago by wi-cli-venus
1w ago
2026-08-03 21:51