From ec8c11c161a2cc2c790549338433c68ad9f0067f Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@gmail.com>
Date: Tue, 14 Feb 2012 11:51:55 +0100
Subject: [PATCH] Fix PurgeDao for MySQL -  new attempt

---
 .../org/sonar/core/purge/PurgeVendorMapper-mysql.xml          | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
index f1d2cd8c145..d3449ac8622 100644
--- a/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
+++ b/sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml
@@ -4,11 +4,11 @@
 <mapper namespace="org.sonar.core.purge.PurgeVendorMapper">
 
   <delete id="deleteResourceReviewComments" parameterType="long">
-    delete from review_comments using reviews where review_comments.review_id=reviews.id and reviews.resource_id=#{id}
+    delete rc from review_comments rc, reviews r where rc.review_id=r.id and r.resource_id=#{id}
   </delete>
 
   <delete id="deleteResourceActionPlansReviews" parameterType="long">
-    delete from action_plans_reviews using action_plans where action_plans.id=action_plans_reviews.action_plan_id and action_plans.project_id=#{id}
+    delete apr from action_plans_reviews apr, action_plans ap where ap.id=apr.action_plan_id and ap.project_id=#{id}
   </delete>
 
 </mapper>
-- 
2.39.5