diff options
author | Simon Brandhof <simon.brandhof@gmail.com> | 2013-07-04 20:16:08 +0200 |
---|---|---|
committer | Simon Brandhof <simon.brandhof@gmail.com> | 2013-07-04 20:16:08 +0200 |
commit | 06e09258ae7400acf208598e9eed841481c81948 (patch) | |
tree | d6e0e1a244e8d9f2c64a225443b8318ad6bab9eb | |
parent | 8238533b7b1555c348c96c9a0330fb96642d9535 (diff) | |
download | sonarqube-06e09258ae7400acf208598e9eed841481c81948.tar.gz sonarqube-06e09258ae7400acf208598e9eed841481c81948.zip |
SONAR-4470 fix migration on SQLServer
-rw-r--r-- | sonar-server/src/main/java/org/sonar/server/db/migrations/ConvertViolationsToIssues.java | 4 |
1 files 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 { |