diff options
| author | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-01-08 14:41:10 +0100 |
|---|---|---|
| committer | Julien Lancelot <julien.lancelot@sonarsource.com> | 2015-01-08 14:41:18 +0100 |
| commit | b51e88207146f945a21e44fc7a163883423a3876 (patch) | |
| tree | 0cf62673fa009a7c9fe8dee80fbdb2c96983b0ae | |
| parent | 71451ce97546ac1356e466f425d2495e0ed011b7 (diff) | |
| download | sonarqube-b51e88207146f945a21e44fc7a163883423a3876.tar.gz sonarqube-b51e88207146f945a21e44fc7a163883423a3876.zip | |
SONAR-5909 Fix SQL query on Oracle
| -rw-r--r-- | server/sonar-server/src/main/java/org/sonar/server/db/migrations/v51/CopyScmAccountsFromAuthorsToUsers.java | 2 |
1 files changed, 1 insertions, 1 deletions
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<Long, String> 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 |