Skip to content

Fix querying vulnerability_reads by cluster_agent_id

Alan (Maciej) Paruszewski requested to merge fix-cluster-agent-id-query into master

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.

Edited by Alan (Maciej) Paruszewski

Merge request reports

Loading