diff options
| author | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-06-28 13:56:16 +0200 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@sonarsource.com> | 2016-06-28 13:56:16 +0200 |
| commit | 0364112c63bc02bd0baeecab4989fdfe3c7d4e1e (patch) | |
| tree | 178c1153f837cb5e22825fb5496d0d8037039163 /sonar-db/src/main | |
| parent | 983b3c4a62c4541bbc0bab5d96c43f55efa52100 (diff) | |
| download | sonarqube-0364112c63bc02bd0baeecab4989fdfe3c7d4e1e.tar.gz sonarqube-0364112c63bc02bd0baeecab4989fdfe3c7d4e1e.zip | |
Fix SQL inner join on MSSQL
Diffstat (limited to 'sonar-db/src/main')
| -rw-r--r-- | sonar-db/src/main/resources/org/sonar/db/measure/MeasureMapper.xml | 10 |
1 files 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> |