From 0e28de827020f3bfdae0473fedc6d197ed80ad11 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Mon, 12 Nov 2012 14:28:33 +0100 Subject: [PATCH] SONAR-3944 Measure filters fail with PostgreSQL 8 --- .../java/org/sonar/core/measure/MeasureFilterSql.java | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sonar-core/src/main/java/org/sonar/core/measure/MeasureFilterSql.java b/sonar-core/src/main/java/org/sonar/core/measure/MeasureFilterSql.java index 1870b774532..c95717e2c2a 100644 --- a/sonar-core/src/main/java/org/sonar/core/measure/MeasureFilterSql.java +++ b/sonar-core/src/main/java/org/sonar/core/measure/MeasureFilterSql.java @@ -106,10 +106,10 @@ class MeasureFilterSql { } private void appendSortBlock() { - sql.append(" SELECT s.id, s.project_id rid, s.root_project_id rootid, ").append(filter.sort().column()).append(" sortval"); + sql.append(" SELECT s.id, s.project_id AS rid, s.root_project_id AS rootid, ").append(filter.sort().column()).append(" AS sortval"); for (int index = 0; index < filter.getMeasureConditions().size(); index++) { MeasureFilterCondition condition = filter.getMeasureConditions().get(index); - sql.append(", ").append(nullSelect(condition.metric())).append(" crit_").append(index); + sql.append(", ").append(nullSelect(condition.metric())).append(" AS crit_").append(index); } sql.append(" FROM snapshots s INNER JOIN projects p ON s.project_id=p.id "); if (filter.isOnFavourites()) { @@ -125,7 +125,7 @@ class MeasureFilterSql { } private void appendConditionBlock(int conditionIndex, MeasureFilterCondition condition) { - sql.append(" SELECT s.id, s.project_id rid, s.root_project_id rootid, null sortval"); + sql.append(" SELECT s.id, s.project_id AS rid, s.root_project_id AS rootid, null AS sortval"); for (int j = 0; j < filter.getMeasureConditions().size(); j++) { sql.append(", "); if (j == conditionIndex) { @@ -133,7 +133,7 @@ class MeasureFilterSql { } else { sql.append(nullSelect(filter.getMeasureConditions().get(j).metric())); } - sql.append(" crit_").append(j); + sql.append(" AS crit_").append(j); } sql.append(" FROM snapshots s INNER JOIN projects p ON s.project_id=p.id INNER JOIN project_measures pm ON s.id=pm.snapshot_id "); if (filter.isOnFavourites()) { -- 2.39.5