Reset `resolved_at` attribute vulnerabilities

Mehmet Emin INACrequested to merge
512857_clear_resolved_at_attribute_while_unresolving_vulnerabilities into master

What does this MR do and why?

Reset resolved_at attribute of vulnerability records while changing their states from resolved to detected in ingestion logic.

Related to Reset `resolved_at` column of `vulnerabilities`... (#512857 - closed).

Database review

This MR changes an existing update query to update a new column and removes a redundant filter predicate.

Here is the old query execution plan: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/35123/commands/108869 Here is the new query execution plan: https://console.postgres.ai/gitlab/gitlab-production-main/sessions/35123/commands/108868

Edited by Mehmet Emin INAC

Merge request reports