venus VENUS-238

Drop practicas.diaId — derived-column drift bug

Done normal unassigned

práctica-detail weekday drift: practicas.diaId is a derived NOT NULL column never re-synced on correction-approval fecha edits (correction-actions.ts:527-546 generic column loop skips it; direct-edit path does re-derive). 6 live rows drifted (PRA 42,100,287,288,198,897), incl Elazar-reported PRA-198 (Sunday fecha stored as Martes). Elazar-directed fix: DROP practicas.diaId entirely (100% derived, no index/WHERE/GROUP BY, display-only) + recreate vActivePracticas/vPracticasCompletas to derive weekday from fecha via EXTRACT(ISODOW). Class-A schema change. Audit design-ping in flight.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 5w ago
wi-cli-venus note · 5w ago

audit-venus-ca design-ping sent pm-venus-cc-mrj0qrtk9otd, awaiting sign-off before db-venus-cc DDL
wi-cli-venus note · 5w ago

audit-venus-ca PASS (mrj0rhjnlseo), condition: ship view-recreate+DROP COLUMN together with coder's app-side diaId removal in same rollout. Dispatched db-venus-cc mrj0ro6ahw3a to apply DDL + coordinate sequencing w/ coder-venus-cc.
wi-cli-venus note · 5w ago

DDL applied+verified by db-venus-cc (mrj0v5vlwe1d): dropped practicas.diaId, recreated vActivePracticas+vPracticasCompletas (dia via EXTRACT ISODOW), recreated dependent vInactiveAlumnoReminderCandidates (CASCADE, unchanged, 0 rows). 6 drifted rows confirmed correct. db handed off to coder-venus-cc for app-side cleanup.
wi-cli-venus note · 5w ago

App-side shipped SHA 9731e47 (expect v0.95.18) by coder-venus-cc — practica-actions.ts, CSV route, audit-actions.ts, seed-demo.ts, practica-form.tsx cleaned of diaId. Live-break window flagged: 0.95.17 was 500ing on practica create/edit between DDL apply and this deploy (INSERT referenced dropped column) — 9731e47 closes it. Audit PTD requested mrj15b148pt2 (build+runtime logs + live version-match). Bug B still holding on Elazar's decision.
wi-cli-venus note · 5w ago

Live version-match confirmed by audit: 0.95.18/dpl_6KWhrndas3WXKjFQbAM88sKp6Xh3. Audit blocked on build+runtime logs (no vercel CLI, MCP OAuth-blocked in its session) — dispatched coder-venus-cc to pull logs directly and hand to audit per PTD fallback protocol.
wi-cli-venus completed · 5w ago

Dropped practicas.diaId (derived NOT NULL, drifted on correction-approval fecha edits — 6 live rows incl PRA-198). DDL by db-venus-cc (view recreates + column drop, verified live). App-side cleanup by coder-venus-cc, SHA 9731e47/v0.95.18. Audit-venus-ca: pre-DDL design-ping PASS + post-push Class-A PTD PASS (clean build, zero runtime errors, live version-match dpl_6KWhrndas3WXKjFQbAM88sKp6Xh3). Brief live-break window (0.95.17 500ing on practica create/edit between DDL-apply and app-deploy) self-closed by this same push.