From a66abc71424b0122131a61af97f889170d85e947 Mon Sep 17 00:00:00 2001
From: Teryk Bellahsene <teryk.bellahsene@sonarsource.com>
Date: Fri, 31 Jul 2015 14:08:37 +0200
Subject: [PATCH] Add alias to temporary table in RoleMapper

---
 sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml b/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml
index d1f70ebd133..397f976f81a 100644
--- a/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml
+++ b/sonar-db/src/main/resources/org/sonar/db/user/RoleMapper.xml
@@ -113,7 +113,7 @@
   </select>
 
   <select id="countUsersWithPermission" parameterType="map" resultType="int">
-    SELECT count(id)
+    SELECT count(c.id)
     FROM (
       SELECT DISTINCT ur.user_id as id
       FROM user_roles ur
@@ -133,7 +133,7 @@
         <if test="groupId!=null">
           AND g.id!=#{groupId}
         </if>
-    )
+    ) as c
   </select>
 
   <delete id="deleteGroupRolesByGroupId" parameterType="long">
-- 
2.39.5