diff options
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mssql.xml | 8 |
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> |