aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSimon Brandhof <simon.brandhof@gmail.com>2013-07-04 20:16:08 +0200
committerSimon Brandhof <simon.brandhof@gmail.com>2013-07-04 20:16:08 +0200
commit06e09258ae7400acf208598e9eed841481c81948 (patch)
treed6e0e1a244e8d9f2c64a225443b8318ad6bab9eb
parent8238533b7b1555c348c96c9a0330fb96642d9535 (diff)
downloadsonarqube-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.java4
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 {