From 91efd753531f666b5c638cf13d32bbb1ea90d62c Mon Sep 17 00:00:00 2001
From: Jean-Baptiste Lievremont <jean-baptiste.lievremont@sonarsource.com>
Date: Mon, 20 Apr 2015 14:08:03 +0200
Subject: [PATCH] SONAR-6298 Fix group by clause for Oracle and MSSQL

---
 .../org/sonar/core/qualityprofile/db/QualityProfileMapper.xml   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/QualityProfileMapper.xml b/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/QualityProfileMapper.xml
index 9356b4f26d1..814b3fa4439 100644
--- a/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/QualityProfileMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/qualityprofile/db/QualityProfileMapper.xml
@@ -157,7 +157,7 @@
     INNER JOIN project_qprofiles pp ON pp.project_uuid=projects.uuid
     INNER JOIN rules_profiles prof ON pp.profile_key=prof.kee
     WHERE projects.enabled=${_true}
-    GROUP BY profileKey
+    GROUP BY pp.profile_key
   </select>
 
   <select id="selectByProjectIdAndLanguage" parameterType="map" resultType="QualityProfile">
-- 
2.39.5