From e0b09631fe4041cfceac233532c9ff84efefb2b0 Mon Sep 17 00:00:00 2001
From: Julien Lancelot <julien.lancelot@gmail.com>
Date: Wed, 28 Aug 2013 13:12:38 +0200
Subject: [PATCH] Fix query

---
 .../resources/org/sonar/core/resource/ResourceMapper.xml    | 6 +++---
 1 file changed, 3 insertions(+), 3 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 18cbecb6dc1..3cec051123a 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
@@ -153,7 +153,7 @@
   </select>
 
   <sql id="selectProjectsByQualifiersQuery">
-    select <include refid="resourceColumns"/> from projects p
+    select p.* from projects p
     inner join snapshots s on s.project_id=p.id
     <where>
       <if test="qualifiers != null and qualifiers.size() > 0">
@@ -166,8 +166,8 @@
     </where>
   </sql>
 
-  <select id="selectGhostsProjects" parameterType="map" resultType="Resource">
-    select <include refid="resourceColumns"/> from projects p
+  <select id="selectGhostsProjects" parameterType="map" resultMap="resourceResultMap">
+    select p.* from projects p
     left join (<include refid="selectProjectsByQualifiersQuery" />) availableProjects on availableProjects.id=p.id
     <where>
       and availableProjects.id is null
-- 
2.39.5