As maintainers of sqlite in z-streams of RHEL, we frequently hit failing regression tests during gating and testing, for CVEs that haven't been fixed for older streams of RHEL. We can avoid this by checking where a CVE has first been fixed and then adjusting the relevancy of these tests to only make them run on versions where they have been fixed.

Acceptance criteria

• Gather data about which CVEs have been fixed in which versions
  • Source 1: spec file changelogs and git logs
  • Source 2: most recent tier1 gating results, e.g. https://dashboard.osci.redhat.com/#/details/brew-build-68371188?focus=baseos-ci.brew-build.tier1.functional 
• Test relevancies are adjusted in fmf files inside the tests/sqlite repo
  • TODO: GitLab repo link
• Merge request is created and merged after approval