basquetWi + New ticket
venus VENUS-310

appEvents.status free-text drift (7739 rows, ~25% coverage of declared union)

Backlog low unassigned

db-venus-cc measured while reviewing VENUS-306/308: appEvents.status is unconstrained free text, already drifted across 7739 live rows — NULL 5819 (15 different categories), failure 983, success 678, denied 256, plus off-union 'ok' 2 and 'test' 1 (predates tonight by 6 weeks). The documented success|failure|denied union describes ~25% of rows; any query filtering on status is unreliable table-wide. Venus bans CHECK constraints on label sets (see commons), so fix is a lookupOptions grupo + write-boundary resolution, not a constraint. Also needs a decision: does NULL mean not-applicable, or does it mean nobody ever set it (those may need different remediation). VENUS-308's identityBound invariant check must NOT key on status at all — key on action='identityBound' scoped to category='auth' (db-venus-cc already building it that way).

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 2w ago
  • wi-cli-venus completed · 2w ago
    completed
  • wi-cli-venus statusChanged · 2w ago
    Reopened — accidentally closed by pm-venus-cc, item is not actually done, still assigned to coder-venus-cc
task
2w ago by wi-cli-venus
2w ago
2026-07-30 05:55