From b9d94b8d30aa8aecece79ed44b0f8a4c0e8b1ca1 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@gmail.com>
Date: Wed, 14 Aug 2013 17:50:05 +0200
Subject: [PATCH] Fix query

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

diff --git a/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml b/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
index bcfbe774bd3..10f52f8d5e0 100644
--- a/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/user/RoleMapper.xml
@@ -97,7 +97,7 @@
     INNER JOIN user_roles AS ur ON ur.user_id = u.id
     <where>
       AND (ur.role = #{permission} AND ur.resource_id IS NULL)
-      AND u.active = true
+      AND u.active = ${_true}
     </where>
     UNION
     select u.id as id
@@ -107,7 +107,7 @@
     INNER JOIN groups AS g ON g.id = gu.group_id
     <where>
       AND (gr.role = #{permission} AND gr.resource_id IS NULL)
-      AND u.active = true
+      AND u.active = ${_true}
     </where>
     ) AS tmp
   </select>
-- 
2.39.5