From 0364112c63bc02bd0baeecab4989fdfe3c7d4e1e Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Tue, 28 Jun 2016 13:56:16 +0200
Subject: [PATCH] Fix SQL inner join on MSSQL

---
 .../resources/org/sonar/db/measure/MeasureMapper.xml   | 10 ++++------
 1 file changed, 4 insertions(+), 6 deletions(-)

diff --git a/sonar-db/src/main/resources/org/sonar/db/measure/MeasureMapper.xml b/sonar-db/src/main/resources/org/sonar/db/measure/MeasureMapper.xml
index 6641363bf0e..c256b0b34c7 100644
--- a/sonar-db/src/main/resources/org/sonar/db/measure/MeasureMapper.xml
+++ b/sonar-db/src/main/resources/org/sonar/db/measure/MeasureMapper.xml
@@ -30,10 +30,9 @@
     select
     <include refid="measureColumns"/>
     from project_measures pm
-    inner join snapshots s
+    inner join snapshots s on s.id = pm.snapshot_id
     where
-    s.id=pm.snapshot_id
-    and pm.component_uuid in
+    pm.component_uuid in
     <foreach item="componentUuid" collection="query.getComponentUuids()" open="(" separator="," close=")">
       #{componentUuid}
     </foreach>
@@ -56,10 +55,9 @@
     select
     <include refid="measureColumns"/>
     from project_measures pm
-    inner join snapshots s
+    inner join snapshots s on s.id = pm.snapshot_id
     where
-    s.id=pm.snapshot_id
-    and s.islast=${_true}
+    s.islast=${_true}
     and pm.component_uuid in
     <foreach item="componentUuid" collection="componentUuids" open="(" separator="," close=")">#{componentUuid}
     </foreach>
-- 
2.39.5