Cleanup invalid records in vulnerability_feedback table
Why are we doing this work?
When working on Make sure the `Vulnerability#state` accurately ... (#324893 - closed) I realized that we have records in the vulnerability_feedback
table for Vulnerabilities::Finding
records that not longer exist.
SELECT COUNT(v_f.finding_uuid)
FROM vulnerability_feedback v_f
LEFT JOIN vulnerability_occurrences v_o
ON v_f.finding_uuid = v_o.uuid::uuid
WHERE v_o.uuid IS NULL AND v_f.finding_uuid IS NOT NULL;
┌────────┐
│ count │
├────────┤
│ 106730 │
└────────┘
Implementation plan
Edited by Michał Zając