Fix PurgeDao for SQLServer - second attempt

1 files changed, 6 insertions, 2 deletions

diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
index 7f086c79613..b47bf4f3213 100644
--- a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml
@@ -4,11 +4,15 @@
 <mapper namespace="org.sonar.core.purge.PurgeVendorMapper">
 
   <delete id="deleteResourceReviewComments" parameterType="long">
-    delete from review_comments rc inner join reviews r on rc.review_id=r.id where r.resource_id=#{id}
+    delete review_comments from review_comments
+    inner join reviews on review_comments.review_id=reviews.id
+    where reviews.resource_id=#{id}
   </delete>
 
   <delete id="deleteResourceActionPlansReviews" parameterType="long">
-    delete from action_plans_reviews apr inner join action_plans ap on ap.id=apr.action_plan_id where ap.project_id=#{id}
+    delete action_plans_reviews from action_plans_reviews
+    inner join action_plans on action_plans.id=action_plans_reviews.action_plan_id
+    where action_plans.project_id=#{id}
   </delete>
 
 </mapper>