From b51e88207146f945a21e44fc7a163883423a3876 Mon Sep 17 00:00:00 2001 From: Julien Lancelot Date: Thu, 8 Jan 2015 14:41:10 +0100 Subject: [PATCH] SONAR-5909 Fix SQL query on Oracle --- .../db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/server/sonar-server/src/main/java/org/sonar/server/db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java b/server/sonar-server/src/main/java/org/sonar/server/db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java index 7a46c971ce6..ab401370f2c 100644 --- a/server/sonar-server/src/main/java/org/sonar/server/db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java +++ b/server/sonar-server/src/main/java/org/sonar/server/db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java @@ -59,7 +59,7 @@ public class CopyScmAccountsFromAuthorsToUsers extends BaseDataChange { try { final Multimap authorsByPersonId = ArrayListMultimap.create(); context.prepareSelect("SELECT a.person_id, a.login FROM authors a," + - " (SELECT person_id, COUNT(*) AS nb FROM authors GROUP BY person_id HAVING COUNT(*) > 1) AS group_by_person" + + " (SELECT person_id, COUNT(*) AS nb FROM authors GROUP BY person_id HAVING COUNT(*) > 1) group_by_person" + " WHERE a.person_id = group_by_person.person_id " ).scroll(new Select.RowHandler() { @Override -- 2.39.5