From 78f331f8f0264b56a9951f50868927b6fb66c6c4 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Tue, 16 Sep 2014 10:35:03 +0200
Subject: [PATCH] SONAR-5580 fix compatibility with Oracle

---
 .../sonar/core/persistence/migration/v44/Migration44Mapper.xml  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
index eeb24110187..acd7f5ba775 100644
--- a/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/persistence/migration/v44/Migration44Mapper.xml
@@ -41,7 +41,7 @@
 
   <select id="selectMeasuresOnDeletedQualityProfiles" resultType="long">
      select pm.id from project_measures pm
-      inner join snapshots as s on s.id=pm.snapshot_id and s.islast=${_true}
+      inner join snapshots s on s.id=pm.snapshot_id and s.islast=${_true}
       where
         pm.metric_id=(select id from metrics where name='quality_profiles')
         and pm.value is not null
-- 
2.39.5