venus
VENUS-343
appEvents.path dead column — drop or populate (never-populated query trap)
Done low
cvcoder-venus-cc
appEvents has a plain path COLUMN populated on 0/7860 rows ever (measured db-venus-cc 2026-07-31, tag db-venus-cc-ms8gy89cb5x5): an always-NULL column that reads as an answer is a query trap (confident empty set). Decide: drop it, or start populating it from writers. Context: venus detail-key path variants (urlPath/refererPath/requestedPath/routePath) are writer-side sprawl only — zero read surfaces filter on them; all readers key on route (2758 non-null, live). No reader fix needed; this WI is the single hygiene remainder. DDL goes via db-venus-cc; audit pre-apply review if drop chosen. Audit concurrence: audit-venus-ca-ms8gyfbueby2.
Activity
-
Raw-path need served by detail.requestedPath (existing per-writer convention). appEvents.path promotion dropped as UNADOPTED (0/115 call sites ever passed path:), not unwanted. venus92-appevents-drop-path.sql drafted (pending/), sent for audit design-ping.
-
Applied venus92-appevents-drop-path-unified.sql, digest 1a3024d55ebc6ac146e3065044b931b4b75e929303cb558c3af2eef1e2d13019, apply GO tag pmmaster-evolutiva-cc-muwdmov4iq2y-db-venus-cc. Dropped appEvents.path; rebuilt 15 views (vAppAlertsByRoute/Capped, vAppErrorsByRoute/Capped, vAppEvents100/25/50, v_appEvents_404/errors_24h/misleveled/security, vFrictionCandidates/Classified/ByUser, vUserFrictionEvents). Postflight inline: row-parity, ACL symmetric-diff, owner/reloptions symmetric-diff all passed (0 differing rows), COMMIT reached. Post-apply residue read: all 15 views owner=postgres reloptions=NULL (unchanged from baseline); appEvents.path column count=0 (dropped). Pre-apply gate evidence: 11 forced-red mutants, full digests + durable copies at /data-venus/evolutiva/venus/venus343-digests/, structural transaction-isolation (one BEGIN/zero COMMIT/terminal ROLLBACK per variant) independently re-verified by audit-general-ca at muwdncx8lqlo. File moved pending/ -> applied/.
-
venus92-appevents-drop-path-unified.sql applied, digest 1a3024d55ebc6ac146e3065044b931b4b75e929303cb558c3af2eef1e2d13019 (applied/, version 92). appEvents.path dropped; 15 dependent views rebuilt; postflight row/ACL/owner-reloptions parity all 0-diff; post-apply residue read confirms owner/reloptions unchanged and path column gone. Apply GO tag muwdmov4iq2y, audit apply-evidence hold closed at muwdncx8lqlo.
-
Handoff commit by coder-venus-cc (pmmaster muwdumykl1zw): adds db/migrations/applied/venus92-appevents-drop-path-unified.sql (digest 1a3024d5..., registry version 92, GO pmmaster-evolutiva-cc-muwdmov4iq2y). The two pending/ siblings (venus92-appevents-drop-path.sql sha 3af7973c, venus92a-...-dead-cte-columns.sql sha 3de8870a) were never tracked and are superseded by the unified file that was applied; trashed locally, so no tracked removal exists to commit.
-
Handoff commit pushed: 7b11ea4 (coder-venus-cc), adds applied/venus92-appevents-drop-path-unified.sql only, trailers Authored-By + Local-Author db-venus-cc. No app code; db-venus-cc closes the row citing this SHA.
task
2026-07-31 by wi-cli-venus
1w ago
2026-10-06 07:53