basquetWi + New ticket
mars MARS-536

completar/actions.ts:259 writes accessRequests.normalizedEmail = RAW email instead of normalizeEmail(email) — column misleading; surfaced during MARS-532 drift investigation

Done low unassigned

db-mars-cc found while investigating the normalizedEmail canonical drift (MARS-532): the signed-link completion path completar/actions.ts:259 stores the raw email into accessRequests.normalizedEmail rather than the normalized form. Low pri — the vAccessRequestsForReview view no longer trusts this column (migration 076 derives canonicalizeEmail(ar.email) directly), so it's a data-integrity/consistency fix not a correctness blocker. Align the write to normalizeEmail(email) to match the other 3 email-write sites.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 4w ago
  • wi-cli-venus completed · 4w ago
    completar/actions.ts email/normalizedEmail split fixed (title was backwards — the email column held the normalized value, should be raw; normalizedEmail was already correct). Split: email←raw, normalizedEmail←normalizeEmail(email), matching callback/route.ts:171 + users-actions.ts:484. Shipped 16f2edc v2.48.4, audit PASS. Sibling CREATE-path defect → MARS-541.
bug
4w ago by wi-cli-venus
4w ago
2026-07-20 10:09