SQRP-292 Add sca_issues_releases

SQRP-293 add sca_issues_releases.severity column

SQRP-292 Update sca_issues_releases Dao to support persisting

SQRP-300 Add sca_issues_releases.severity_sort_key

3 files changed, 40 insertions, 2 deletions

diff --git a/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaDependencyDtoTest.java b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaDependencyDtoTest.java
index dff74348819..bf899451fcb 100644
--- a/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaDependencyDtoTest.java
+++ b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaDependencyDtoTest.java
@@ -37,7 +37,7 @@ class ScaDependencyDtoTest {
       List.of(List.of("pkg:npm/fodo@1.0.0")),
       1L,
       2L);
-    assertThat(scaDependencyDto).isEqualTo(scaDependencyDto.toBuilder().build());
+    assertThat(scaDependencyDto.toBuilder().build()).isEqualTo(scaDependencyDto);
   }
 
   @Test
diff --git a/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaIssueReleaseDtoTest.java b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaIssueReleaseDtoTest.java
new file mode 100644
index 00000000000..1a6a33a955a
--- /dev/null
+++ b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaIssueReleaseDtoTest.java
@@ -0,0 +1,38 @@
+/*
+ * SonarQube
+ * Copyright (C) 2009-2025 SonarSource SA
+ * mailto:info AT sonarsource DOT com
+ *
+ * This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License as published by the Free Software Foundation; either
+ * version 3 of the License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * along with this program; if not, write to the Free Software Foundation,
+ * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+package org.sonar.db.sca;
+
+import org.junit.jupiter.api.Test;
+
+import static org.assertj.core.api.AssertionsForClassTypes.assertThat;
+
+class ScaIssueReleaseDtoTest {
+
+  @Test
+  void test_toBuilder_build_shouldRoundTrip() {
+    var scaIssueReleaseDto = new ScaIssueReleaseDto("sca-issue-release-uuid",
+      "sca-issue-uuid",
+      "sca-release-uuid",
+      ScaSeverity.INFO,
+      1L,
+      2L);
+    assertThat(scaIssueReleaseDto.toBuilder().build()).isEqualTo(scaIssueReleaseDto);
+  }
+}
diff --git a/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaReleaseDtoTest.java b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaReleaseDtoTest.java
index 33324eaec0d..3b493e3c2a7 100644
--- a/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaReleaseDtoTest.java
+++ b/server/sonar-db-dao/src/test/java/org/sonar/db/sca/ScaReleaseDtoTest.java
@@ -37,6 +37,6 @@ class ScaReleaseDtoTest {
       true,
       1L,
       2L);
-    assertThat(scaReleaseDto).isEqualTo(scaReleaseDto.toBuilder().build());
+    assertThat(scaReleaseDto.toBuilder().build()).isEqualTo(scaReleaseDto);
   }
 }