From 06e09258ae7400acf208598e9eed841481c81948 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Thu, 4 Jul 2013 20:16:08 +0200 Subject: SONAR-4470 fix migration on SQLServer --- .../org/sonar/server/db/migrations/ConvertViolationsToIssues.java | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sonar-server/src/main/java/org/sonar/server/db/migrations/ConvertViolationsToIssues.java b/sonar-server/src/main/java/org/sonar/server/db/migrations/ConvertViolationsToIssues.java index 7613a7d1845..d289ba79c52 100644 --- a/sonar-server/src/main/java/org/sonar/server/db/migrations/ConvertViolationsToIssues.java +++ b/sonar-server/src/main/java/org/sonar/server/db/migrations/ConvertViolationsToIssues.java @@ -284,11 +284,11 @@ public class ConvertViolationsToIssues implements DatabaseMigration { private static String SQL = "select rev.id as reviewId, s.project_id as projectId, rf.rule_id as ruleId, rf.failure_level as failureLevel, rf.message as message, rf.line as line, " + " rf.cost as cost, rf.created_at as createdAt, rf.checksum as checksum, rev.user_id as reviewReporterId, rev.assignee_id as reviewAssigneeId, rev.status as reviewStatus, " + " rev.severity as reviewSeverity, rev.resolution as reviewResolution, rev.manual_severity as reviewManualSeverity, rev.data as reviewData, rev.updated_at as reviewUpdatedAt, " + - " s.root_project_id as rootProjectId, rev.manual_violation as reviewManualViolation, plan.action_plan_id as planId " + + " s.root_project_id as rootProjectId, rev.manual_violation as reviewManualViolation, planreviews.action_plan_id as planId " + " from rule_failures rf " + " inner join snapshots s on s.id=rf.snapshot_id " + " left join reviews rev on rev.rule_failure_permanent_id=rf.permanent_id " + - " left join action_plans_reviews plan on plan.review_id=rev.id " + + " left join action_plans_reviews planreviews on planreviews.review_id=rev.id " + " where "; static { -- cgit v1.2.3