diff options
| author | Julien Lancelot <julien.lancelot@gmail.com> | 2013-08-28 13:12:38 +0200 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@gmail.com> | 2013-08-28 13:12:38 +0200 |
| commit | e0b09631fe4041cfceac233532c9ff84efefb2b0 (patch) | |
| tree | 4e3b37a736da4c99818b6b2a75e6d37a7c402049 | |
| parent | 9a2efea4d9a7c1e8b936b0c8f7c37f8d74a87338 (diff) | |
| download | sonarqube-e0b09631fe4041cfceac233532c9ff84efefb2b0.tar.gz sonarqube-e0b09631fe4041cfceac233532c9ff84efefb2b0.zip | |
Fix query
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/resource/ResourceMapper.xml | 6 |
1 files 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 |