Fix querying vulnerability_reads by cluster_agent_id
What does this MR do and why?
When adding vulnerability_reads.cluster_agent_id
column, we have incorrectly set it as a TEXT
column instead of BIGINT
. It has some implications that now we have to mitigate with MRs: Change column type of vulnerability_reads.clust... (!88333 - merged) and Add background migration to backfill casted_clu... (!89915 - merged).
With this MR we are temporarily fixing filtering vulnerabilities by cluster_agent_id
. We already have indexes in place (index_vulnerability_reads_on_cluster_agent_id
).
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Alan (Maciej) Paruszewski