From aa816115e31105b9623196c078afcd189c7a7207 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@sonarsource.com>
Date: Wed, 26 Feb 2014 08:57:21 +0100
Subject: [PATCH] Fix query for Oracle

---
 .../sonar/core/qualitygate/db/ProjectQgateAssociationMapper.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/qualitygate/db/ProjectQgateAssociationMapper.xml b/sonar-core/src/main/resources/org/sonar/core/qualitygate/db/ProjectQgateAssociationMapper.xml
index 8ab0864e363..a37abbac0a2 100644
--- a/sonar-core/src/main/resources/org/sonar/core/qualitygate/db/ProjectQgateAssociationMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/qualitygate/db/ProjectQgateAssociationMapper.xml
@@ -9,7 +9,7 @@
     <if test="query.projectSearch() != null">
       JOIN resource_index ind ON ind.root_project_id=proj.id
     </if>
-    LEFT JOIN properties prop ON prop.resource_id=proj.id AND prop.prop_key='sonar.qualitygate' AND prop.text_value=#{gateId}
+    LEFT JOIN properties prop ON prop.resource_id=proj.id AND prop.prop_key='sonar.qualitygate' AND prop.text_value LIKE #{gateId}
     <where>
       <choose>
         <when test="query.membership() == 'IN'">
-- 
2.39.5