From 14d6de3529b12ec0af367e551cf66ac6daae1ca7 Mon Sep 17 00:00:00 2001
From: Jacek <jacek.poreda@sonarsource.com>
Date: Mon, 8 Jun 2020 17:15:43 +0200
Subject: SONAR-13398 fail with 503 api/issues/search WS if needIssueSync is
 set to true

---
 .../org/sonar/db/component/BranchMapper.xml        | 23 ++++++++++++++++++++++
 1 file changed, 23 insertions(+)

(limited to 'server/sonar-db-dao/src/main/resources')

diff --git a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/BranchMapper.xml b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/BranchMapper.xml
index 836a428a9fa..982a77009e4 100644
--- a/server/sonar-db-dao/src/main/resources/org/sonar/db/component/BranchMapper.xml
+++ b/server/sonar-db-dao/src/main/resources/org/sonar/db/component/BranchMapper.xml
@@ -188,4 +188,27 @@
       uuid = #{uuid, jdbcType=VARCHAR}
   </update>
 
+  <select id="doAnyOfComponentsNeedIssueSync" parameterType="map" resultType="short">
+    select
+    case when exists
+    (
+    select pb.project_uuid, pb.need_issue_sync from project_branches pb join components c on pb.project_uuid =
+    c.project_uuid
+    where c.kee in
+    <foreach collection="componentKeys" open="(" close=")" item="componentKey" separator=",">
+      #{componentKey,jdbcType=VARCHAR}
+    </foreach>
+    and pb.need_issue_sync = ${_true}
+    <if test="branch != null">
+      and pb.kee = #{branch,jdbcType=VARCHAR}
+    </if>
+    <if test="pullRequest != null">
+      and pb.kee = #{pullRequest,jdbcType=VARCHAR}
+    </if>
+    )
+    then 1
+    else 0
+    end
+  </select>
+
 </mapper>
-- 
cgit v1.2.3