From b309ce1704e490af7daef2a0d0ab1bbba8c930b8 Mon Sep 17 00:00:00 2001
From: Duarte Meneses <duarte.meneses@sonarsource.com>
Date: Mon, 31 Oct 2022 15:58:49 -0500
Subject: SONAR-17547 When creating a project, error is returned if key already
 exists in multiple branches

---
 .../resources/org/sonar/db/component/ComponentMapper.xml     |  1 +
 .../test/java/org/sonar/db/component/ComponentDaoTest.java   | 12 ++++++++++++
 2 files changed, 13 insertions(+)

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
index 5f67411da9d..6fd35693df0 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/ComponentMapper.xml
@@ -39,6 +39,7 @@
     FROM components p
     where
       lower(p.kee)=lower(#{key,jdbcType=VARCHAR})
+      and p.main_branch_project_uuid is null
   </select>
 
   <select id="selectByKeyAndBranchKey" parameterType="String" resultType="Component">
diff --git a/server/sonar-db-dao/src/test/java/org/sonar/db/component/ComponentDaoTest.java b/server/sonar-db-dao/src/test/java/org/sonar/db/component/ComponentDaoTest.java
index 706b1012917..80904430f7c 100644
--- a/server/sonar-db-dao/src/test/java/org/sonar/db/component/ComponentDaoTest.java
+++ b/server/sonar-db-dao/src/test/java/org/sonar/db/component/ComponentDaoTest.java
@@ -2065,6 +2065,18 @@ public class ComponentDaoTest {
     assertThat(result.getKey()).isEqualTo(projectKey);
   }
 
+  @Test
+  public void selectByKeyCaseInsensitive_should_not_match_non_main_branch() {
+    String projectKey = randomAlphabetic(5).toLowerCase();
+    ProjectDto project = db.components().insertPrivateProjectDto(c -> c.setKey(projectKey));
+    BranchDto projectBranch = db.components().insertProjectBranch(project);
+    ComponentDto file = db.components().insertFile(projectBranch);
+
+    ComponentDto result = underTest.selectByKeyCaseInsensitive(db.getSession(), file.getKey()).orElse(null);
+
+    assertThat(result).isNull();
+  }
+
   @Test
   public void selectByKeyCaseInsensitive_shouldNotFindProject_whenKeyIsDifferent() {
     String projectKey = randomAlphabetic(5).toLowerCase();
-- 
cgit v1.2.3