From 472c3e32321c5c9ecd3253cbe573187e0799824c Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@gmail.com>
Date: Thu, 18 Jul 2013 08:56:32 +0200
Subject: [PATCH] SONAR-4419 Replace SQL in by or

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

diff --git a/sonar-core/src/main/resources/org/sonar/core/resource/ResourceMapper.xml b/sonar-core/src/main/resources/org/sonar/core/resource/ResourceMapper.xml
index 3d0319a0e04..d0978802a67 100644
--- a/sonar-core/src/main/resources/org/sonar/core/resource/ResourceMapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/resource/ResourceMapper.xml
@@ -124,8 +124,8 @@
     select * from projects p
     <where>
       <if test="qualifiers != null and qualifiers.size() > 0">
-        and p.qualifier in
-        <foreach item="qualifier" index="index" collection="qualifiers" open="(" separator="," close=")">#{qualifier}</foreach>
+        and <foreach item="qualifier" index="index" collection="qualifiers" open="(" separator=" or " close=")">p.qualifier=#{qualifier}
+      </foreach>
       </if>
       and p.enabled=${_true}
       and p.copy_resource_id is null
-- 
2.39.5