From 7eb92faaf942fada9b16595fab4e1df630a6aacc Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Tue, 18 Jun 2013 16:21:35 +0200
Subject: [PATCH] Fix loading of comments when more than 1000 issues

---
 .../resources/org/sonar/core/issue/db/IssueChangeMapper.xml   | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueChangeMapper.xml b/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueChangeMapper.xml
index 1620663a1ff..d9d778458a0 100644
--- a/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueChangeMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/issue/db/IssueChangeMapper.xml
@@ -42,12 +42,12 @@
     select
     <include refid="issueChangeColumns"/>
     from issue_changes c
-    where c.change_type=#{changeType} and
+    where c.change_type=#{changeType} and (
     <foreach collection="issueKeys" open="c.issue_key in (" close=")" item="list" separator=") or c.issue_key in (">
       <foreach collection="list" item="element" separator=",">
         #{element}
       </foreach>
-    </foreach>
+    </foreach>)
     order by c.created_at
   </select>
 
-- 
2.39.5