basquetWi + New ticket
venus VENUS-344

userAgent ''-vs-NULL: trigger COALESCE + 2 callers leak empty string (diagnosability)

Deferred low cvcoder-venus-cc

userAgent empty-string vs NULL inconsistency, diagnosability only (spec tags coder02-venus-cc-ms8itl1dr1td + db-venus-cc-ms8iu2w0pphk, 2026-07-31): applog_err NOTIFY trigger COALESCEs uncaptured userAgent to '' (mars uses NULL), and two callers leak '' via ?? (log-error/route.ts:231, not-found-capture.ts:50) while auth-actions.ts:269 already normalises with || null — never-captured vs captured-empty indistinguishable. Behaviour unchanged today (both fail the rail's startsWith, both page). DEFER-UNTIL: applog freeze lifted AND VENUS-324 landed (same seam). Owner split: coder = 2 caller normalizations (must land first or same change); db = trigger COALESCE drop + fails-open header note. Class-A-adjacent seam (trigger DDL) — audit pre-apply review on the db half.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 2w ago
  • wi-cli-venus deferred · 2w ago
    defer-until: applog freeze lifted + VENUS-324 landed
task
2w ago by wi-cli-venus
2w ago