diff options
| author | Simon Brandhof <simon.brandhof@gmail.com> | 2012-02-14 11:51:55 +0100 |
|---|---|---|
| committer | Simon Brandhof <simon.brandhof@gmail.com> | 2012-02-14 12:04:07 +0100 |
| commit | ec8c11c161a2cc2c790549338433c68ad9f0067f (patch) | |
| tree | 03f43d66549c497b7e172d5372921d8627f6dad5 | |
| parent | 0e10dd4728b124717469508a9ab99dcaa62fc1f3 (diff) | |
| download | sonarqube-ec8c11c161a2cc2c790549338433c68ad9f0067f.tar.gz sonarqube-ec8c11c161a2cc2c790549338433c68ad9f0067f.zip | |
Fix PurgeDao for MySQL - new attempt
| -rw-r--r-- | sonar-core/src/main/resources/org/sonar/core/purge/PurgeVendorMapper-mysql.xml | 4 |
1 files 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> |