From 5c8d43bc7610a4ab89b870954871ca54b67a2cca Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Mon, 29 Oct 2012 22:55:54 +0100 Subject: [PATCH] SONAR-3907 fix compatibility with postgresql 8 --- .../src/main/java/org/sonar/core/measure/MeasureFilterSql.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 176d50f8e41..1870b774532 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 @@ -76,7 +76,7 @@ class MeasureFilterSql { } private void init() { - sql.append("SELECT block.id, max(block.rid) rid, max(block.rootid) rootid, max(sortval) sortval"); + sql.append("SELECT block.id, max(block.rid) as rid, max(block.rootid) as rootid, max(sortval) as sortval"); for (int index = 0; index < filter.getMeasureConditions().size(); index++) { sql.append(", max(crit_").append(index).append(")"); } -- 2.39.5