SONAR-10504 remove full scan of DB migration #1908 on Oracle

1 files changed, 6 insertions, 2 deletions

diff --git a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v70/DeletePersonAndFileMeasures.java b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v70/DeletePersonAndFileMeasures.java
index a97dfe1dc85..67db190fab0 100644
--- a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v70/DeletePersonAndFileMeasures.java
+++ b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/version/v70/DeletePersonAndFileMeasures.java
@@ -52,7 +52,11 @@ public class DeletePersonAndFileMeasures extends DataChange {
     massUpdate.update(getDeleteSql());
 
     massUpdate.execute((row, update) -> {
-      update.setString(1, row.getString(1));
+      String analysisUuid = row.getString(1);
+      update.setString(1, analysisUuid);
+      if (getDialect().getId().equals(Oracle.ID)) {
+        update.setString(2, analysisUuid);
+      }
       return true;
     });
   }
@@ -86,7 +90,7 @@ public class DeletePersonAndFileMeasures extends DataChange {
           "  where pm2.analysis_uuid = ? " +
           "  and (c.qualifier in ('UTS', 'FIL') or pm.person_id is not null) " +
           "  and pm.id = pm2.id" +
-          ")";
+          ") and pm.analysis_uuid = ?";
       default:
         throw new IllegalStateException("Unsupported DB dialect: " + getDialect());
     }