Add ORDER BY to vulnerability namespace statistics upsert SQL

rossfuhrmanrequested to merge
add-namespace-id-sorting-to-upsert into master

What does this MR do and why?

Add ORDER BY to vulnerability namespace statistics upsert SQL

This change sorts the upsert statements by namespace_id and traversal_ids to ensure consistent ordering in the generated SQL queries for both the UpdateService and AdjustmentService in vulnerability namespace statistics.

References

Lock contention when inserting `vulnerability_n... (#557964 - closed) • rossfuhrman • 18.4

Screenshots or screen recordings

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by rossfuhrman

Merge request reports